Access 2007 sql server linked database closes slow

[hedgracer]

We have a perplexing problem. We recently converted to 2007 from 2003. We have a large database with a lot of linked sql server 2005 odbc tables that is used by about 15 users (many times all at once). Response times on queries is good but the problem comes with closing the database. In 2003 the database closed in about 5 seconds; in 2007 the database closes in about 30-35 seconds. I have googled this problem to death and have come up with zero answers. We have converted this database over to .accdb format and that did not improve the problem. The closing problem seems to be when there is a lot of users in the database because if I go into the database after 4:30 PM and close it the darn thing shuts down immediately. Is there any way to optimize this database to make shorten this shutdown time? Thanks for all help in advance.

Dave

 

[jrbarnett]

Have you got compact on close turned on?

Office menu -> Access Options -> Current Database.
Under Application Options there is a tickbox "Compact on Close" - make sure it is unticked.

John


John

 

[hedgracer]

I have compact on close unchecked.