SpentGeezer
Pure Noobism
- Local time
- Today, 21:34
- Joined
- Sep 16, 2010
- Messages
- 258
Greetings,
I have a database which is used by approx 7 people here. I do my developing in an mdb file. Then I compile to an MDE. The 7 people use the mde file to update 2 SQL server tables by ODBC.
Yesterday afternoon at approx 3pm some forms in the mde when opening became very slow. This has continued on and it happens randomly on forms. The weird thing is that it also happens in the mdb (which has not been touched for weeks). Random = sometimes a form will open straight away, other times, really slow.
To test the ODBC connection, I copied the mdb to my local drive and made the tables local. Same problem is still occuring.
Any ideas on what else I can check? (I have compacted and repaired as well).
I have a database which is used by approx 7 people here. I do my developing in an mdb file. Then I compile to an MDE. The 7 people use the mde file to update 2 SQL server tables by ODBC.
Yesterday afternoon at approx 3pm some forms in the mde when opening became very slow. This has continued on and it happens randomly on forms. The weird thing is that it also happens in the mdb (which has not been touched for weeks). Random = sometimes a form will open straight away, other times, really slow.
To test the ODBC connection, I copied the mdb to my local drive and made the tables local. Same problem is still occuring.
Any ideas on what else I can check? (I have compacted and repaired as well).
