Relinking Access to SQL tables produces slow loading forms.....
Posted on 2003-10-28
I am baffled by this one;
I am currently working on a database. This database has an access 2000 front end and it is LINKED to tables is SQL Server 2000. Everytime I make any changes to the tables I have to relink them. This is not a big deal though, as it just takes a second or two. I have been having problems with Form Loading Speeds. After working on this for several days something has come to my attention. Say I have Form1; when I relink the tables in my database and then open Form1, it takes it 7 seconds to load. I can leave access, reboot my machine whatever I do everytime I load it, it takes 7 seconds. Until I go into Form1 in design view and click save. Thats it ... I don't need to make any changes.. I just go into design view and click on the save icon. After doing this I load Form1 and it only takes 1 second to load. I can leave access, reboot the machine... whatever and it only takes 1 second. As soon as I relink the SQL tables it will resort back to the 7 second load until I save again. Does anyone have any idea why .... or what I am doing wrong or if there is a workaround?