Access 2007 sql server linked database closes slow

[payout1985]

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. I have unchecked compact on close. Is there any way to optimize this database to make shorten this shutdown time? Thanks for all help in advance.

 

[ByteMyzer]

If the database is merely a front-end, linked to SQL Server as a back-end, then each User should have a copy of the front-end. The Users should not be all trying to open the same front-end file.

 

[payout1985]

So each user should have a copy of the front end on their C drive?

 

[boblarson]

So each user should have a copy of the front end on their C drive?

If they have more than one local drive on their computer (not network drives) it doesn't have to be C. If they have only one local drive then yes it would be on the C drive.

 

[ByteMyzer]

Or, to put it more simply, each User's machine should have a copy of the front-end on the machine's local hard drive.