Access in shared enviroment doesn't update

[gouldish]

I have access 2000 database working in a shared enviroment. To hold the data it creates an .idb file of the database. Only problem is once everyone shuts down the database the DB doesn't completely update the data and the .idb file remains. If I try to shut down the host computer I tells me that one or more people are connected to my computer and then one or more files are open and shutting them down will result in data loss. I know for sure that everyone is closed out of the DB.
Is this a glitch in access and is there a fix for it? Is there someting I need to change in the setting?

This also affects me going in exclusively to update the DB. We have a password to access the DB. I don't know if that is necessary but I thought I would throw that in.

 

[jiqjaq]

Make sure that all the users are exiting out of Access cleanly. If they have the application open and just turn off their pc, the database will still indicate that they are in it and the .ldb will remain. It only takes one user.
Find out who is still connected and how they exit Access.

 

[JeremyNYC]

Are you having all of your users use the same copy of the database? If so, you should seriously consider changing this practice, as it's bound to lead to lots of problems.

The way this is normally done is by splitting your database into a front end and a back end. The BE has just the tables, the FE has everything else. The BE and the master copy of the FE go on the server. Users have copies of the FE on their PC, pointed to the table in the BE. You do your development on a copy of the master FE. When it's time to roll out a new FE you replace the master and the users grab copies of that.

I've written up the method I use for this on my website, in the Deploying Databases bit of the Developers' section, if you're interested.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.