p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Re: VB and Access


Message #1 by "Randy Cornish" <rlcornish@c...> on Sat, 1 Jun 2002 18:14:26
I'll refer you to another thread (lengthy) on this forum, "Database 
application architecture:.  This same issue is under discussion.  Bottom 
line, if the MDB is on another machine that is NOT the users' (a server), 
the processing is still done on the user's machine.  However, what goes 
across the LAN are Indexes (assuming well-planned indexes exist) rather 
than the entire table.  Still a lot of traffic.  I would NOT classify it 
as a client-server architecture.

R

> Hello!
	I know that Access is not that quite good on multi users because 
It does not have a Client/Server Environment Setup.  But I would
like to know that if I try to use VB as my front end and Access as back 
end and have an ADO connection to access database, would it
be already a Client/Server Environment?  what I mean is all the process 
will be done at the machine where the database resides or
still it will be the same that the whole table will be carried on through 
the network to the machine doing the query then from
there execute the query?

Thanks,

Enzo


Message #2 by "Carnley, Dave" <dcarnley@a...> on Mon, 3 Jun 2002 09:37:48 -0500
I guess if your definition of "client/server" requires an active SQL engine
on the server layer, then you wouldn't.  But the generally accepted
definition of client/server allows that even an NT file server is
client/server, even without and MDB.  The example you described "However,
what goes across the LAN are Indexes (assuming well-planned indexes exist)
rather than the entire table" assumes at least enough processing on the
server to interpret the client message as a request for a table with an MDB,
which is then determined to be based on an index, which then translates into
certain blocks and sectors on the hard disk, which are read and formatted
and returned over the NIC.  That's a LOT of processing by a lot of smart
software on the server. It just doesn't include SQL processing.  Just my .02



-----Original Message-----
From: Randy Cornish [mailto:rlcornish@c...]
Sent: Saturday, June 01, 2002 1:14 PM
To: Access
Subject: [access] Re: VB and Access


I'll refer you to another thread (lengthy) on this forum, "Database 
application architecture:.  This same issue is under discussion.  Bottom 
line, if the MDB is on another machine that is NOT the users' (a server), 
the processing is still done on the user's machine.  However, what goes 
across the LAN are Indexes (assuming well-planned indexes exist) rather 
than the entire table.  Still a lot of traffic.  I would NOT classify it 
as a client-server architecture.

R

> Hello!
	I know that Access is not that quite good on multi users because 
It does not have a Client/Server Environment Setup.  But I would
like to know that if I try to use VB as my front end and Access as back 
end and have an ADO connection to access database, would it
be already a Client/Server Environment?  what I mean is all the process 
will be done at the machine where the database resides or
still it will be the same that the whole table will be carried on through 
the network to the machine doing the query then from
there execute the query?

Thanks,

Enzo



  Return to Index