.adp takes long time to load

[balor]

Hi,

I have a rather large Access project connected to an SQL-Server. The larger the project gets (more code) the longer time it takes for it to start up. Even if I shift-start it. No code is running, and no data is fetched from the database. It's just the time to load the file. Do anybody have a clue why?

It takes 1 - 2 min for a 15 Mb file even if it's located on the same machine (PIII 450 128 RAM).

 

[Guest_imported]

sorry I don't have a answer for you but, I'm using ADP as well, it does take a little while to load, my guess is that it makes the connection to the sql server, and thats what taking the time. Meaning that we have alot of tables and stored procedures, it takes time to load the view of the tables and procedures into the access view.

I have a question for you, theres one machine that a developer works on, that has the rights to change the table structure from the client machine, while two others can't, I have looked on the sql server we all have the same rights as well as on the network. Do you have any ideas why or what we can do.