My Access database is split with the backend on the server and frontend on user PCs. Recently, on closing the database, Access will not close. I've tried deleting the ldb file. That doesn't work. Tried rebooting. Tried repairing the database, and it tells me I can't do that because Admin is using it on my PC. There are only five PCs linked to the backend. Only two of us use it frequently and only these two are having problems. However, the frontend on one was copied over to the other recently, which could explain why we are both having problems. The front end on another user PC is not affected. I've tried copying that file over to my PC, but I have the same trouble with that file. Can anyone point me in the right direction? I would like to avoid rebuilding the database if I can. But if I must, how do I do it? Is it just a matter of linking to the backend tables and importing the queries, forms, reports, macros and modules?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access will not close
- Thread starter Creeker
- Start date
Hi:Creeker:
Try to open EXCLUSIVELY by
Opening a blank database > cancel on the default existing file > desktop > MY Network Place > and click once to highlight the file name
Use the drop down arrow to the right of OPEN and click on OPEN EXCLUSIVELY and if you get the prompts for repair try to repair it, then there.
If not use Tools > Database Utilities > Compact and Repair Database
Delete all the links to the back end tables and then relink them.
If the above idea does not work
Highlight the file and open the db by Shift+Enter
Delete the existing links to the back end table and then relink and then try to compact and repair the db.
Hope you get it back to working condition.
Try to open EXCLUSIVELY by
Opening a blank database > cancel on the default existing file > desktop > MY Network Place > and click once to highlight the file name
Use the drop down arrow to the right of OPEN and click on OPEN EXCLUSIVELY and if you get the prompts for repair try to repair it, then there.
If not use Tools > Database Utilities > Compact and Repair Database
Delete all the links to the back end tables and then relink them.
If the above idea does not work
Highlight the file and open the db by Shift+Enter
Delete the existing links to the back end table and then relink and then try to compact and repair the db.
Hope you get it back to working condition.
- Thread starter
- #3
I opened the database exclusively and it still would not repair. It said the folder holding the database was not shared. I set the folder to share and it still would not work. It keeps telling me that it is open already by another users, Admin. Then I shutdown and logged on as "Administrator" on the my PC only, not the network.
Still it would not let me repair until I opened only Access and selected the file to repair without opening. It said it repaired it. Ha, Ha. It would also compact this way.
But I still have the same problem of Access not closing. Also, when I try to refresh the linked tables, now it tells me I don't have permission to use the Documents and Settings/../My Documents folder. It has nothing to do with that folder!
Still it would not let me repair until I opened only Access and selected the file to repair without opening. It said it repaired it. Ha, Ha. It would also compact this way.
But I still have the same problem of Access not closing. Also, when I try to refresh the linked tables, now it tells me I don't have permission to use the Documents and Settings/../My Documents folder. It has nothing to do with that folder!
Have you tried to create a new database and import all your reports, forms, queries, etc. into the new database and see if that works? First though, make sure you create a backup if you haven't already done so. Sounds like you may have a corruption problem.
Try using Microsoft's JetCompact utility to compact the database. This often does a better job than the standard compact. You can get it at
It also sounds to me like you have memory leaks. Check all your VB code. Any time you have declared and set an object, make sure you have closed it and set it to nothing afterwards e.g.
Dim rst as Recordset
Set rst = db.openrecordset("Something")
.
'rest of program
.
rst.close
set rst = Nothing
Leaving objects open leaves references hanging and frequently you get unexpected things happening, especially Access not closing fully and minimising to the taskbar.
It also sounds to me like you have memory leaks. Check all your VB code. Any time you have declared and set an object, make sure you have closed it and set it to nothing afterwards e.g.
Dim rst as Recordset
Set rst = db.openrecordset("Something")
.
'rest of program
.
rst.close
set rst = Nothing
Leaving objects open leaves references hanging and frequently you get unexpected things happening, especially Access not closing fully and minimising to the taskbar.
- Status
Similar threads
- Locked
- Question
- Locked
- Question