Access Frontend Slow

[anon1971]

I am running access 2003 frontend with tables linked to sqlexpress 2005 backend. I upsized the data from access and all was great ran very well for a while and I was twiking it and for some reason it is really slow. It use to take 5 seconds to refreash the linked tables but it takes almost 3 mins. I am in a pickel if anyone has had this problem please let me know?

 

[JoeAtWork]

What do you mean by "refresh" the linked tables? When you open the tables directly? When you open a bound form?

Do your forms bind directly to tables, or to queries?

 

[anon1971]

Bind to the tables in access. When you refreash the tables by highlighting a table and right clicking go to link tables then select all and refresh them. They use to refreash in about 5 seconds but now its like two mins I have tried everything and I think its somthing I have done but I am stuck. Kinda looking foolish after three days of not figuring it out.

 

[anon1971]

It also gives an 18452 SQL error when trying to log in for any computer but the server and it has not done that untill the slowness started.

 

[anon1971]

This has got to be an access issue I tried upsizing another database and it is very slow doing that to when before it was quit fast.

 

[anon1971]

I have got to be the biggest idiot on this planet. Please check this if you have linked table issues running really really slow before you check anything else:::

I went to ODBC Data Source Administrator clicked on the Tracing Tab and low in behold there was a reace running I stopped the trace and it is like lighting.