John Colby
jcolby at colbyconsulting.com
Wed Jun 11 16:21:35 CDT 2003
Precisely right, since both use JET to actually talk to the MDB. However... I saw mention of "going to SQL" later. If you are talking about SQL Server then you should design your app from the gitgo with that in mind. SQL Server doesn't understand VBA function calls, references to controls on forms, and many other things that makes Access the find RAD environment it is. You can paint yourself into some pretty tight corners if you don't think about these things in advance. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Wednesday, June 11, 2003 5:08 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Access Data Retrieval Just FYI, VB behaves exactly the same way as Access when they're both using an MDB as a data store. Tell THAT to the vb developers and watch them squirm! <evilgrin> Charlotte Foust -----Original Message----- From: Jeanine Scott [mailto:jscott at mchsi.com] Sent: Wednesday, June 11, 2003 9:36 AM To: accessd at databaseadvisors.com Subject: [AccessD] Access Data Retrieval I need something explained to me - this just doesn't make any sense to me but I've had quite a few hard core vb developer's swear that the following scenario is how Access retrieves data. Scenario: FE on client BE on Server tblLoans has 100,000 records with 3 fields tblLoans UniqueID - AutoNumber LoanNo (indexed) LastName (indexed) You bind a form to a specified recordset such as "Select * from tblLoans where UniqueID = 1" or "Select * from tblLoans where LoanNo = 101" What I have been told is that when Access goes to the server it brings ALL the records 100,000 records back to the client and then applies criteria to find out which record you actually asked for. So, in effect you are returning 100,000 rows of data back to the client even though you may have only asked for 1. Is this correct? If it is why is this the case and how in the world can I ever justify using Access as a development tool to a hard core VB'r?? If it isn't correct how can I explain in the exact scenario above the fact that the LAN tests show mega tons (ok -technical term there...) of data being passed back to the client when this form is called? I'm understanding that SQL will work the same way? Thank you so much! _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com