Adp

[accessman2]

Hi,

I created mdb and ADP files. Both file tables are from SQL Server. When I input the data on the forms in mdb, it works faster, whereas running ADP, it works a bit slowly. I thought that ADP is faster to run the forms. Maybe ADP access the tables faster, whereas run the forms slowly.

 

[BrettStah]

Accessing SQL Server data (presumably over a network connection) can be faster - especially if you are using queries to pare down the amount of data that is returned to your front-end application, and especially if you have concurrent users accessing the same underlying data. If you are comparing it to an MDB file, make sure to put the MDB file on a file server and not on your local PC, and test it with multiple queries, and with concurrent users.