Multi-User with split database

[clloftus]

Hello .. I have a split database, and several users have a copy of the front-end on their desktop. I need to make updates to the back-end (tables and forms). Is there a way I can do this when the users have the front-end open? A locked file is created, and when I try to access the back-end file, it will not open because of this locked file.

I try to make the updates early in the morning when I come into work, but unfortunately, people stay logged in and have the DB open. So I need to figure out how/if I can make updates when other people still have the DB open.

If there isn't a way, what would happen if I deleted the locked file?

Any assistance someone can provide is greatly appreciated.

 

[gemma-the-husky]

you cannot amend a table design while that table is in use (ie open query/form bound to the table in question). you can amend unused tables while the database is in use.

you won't be able to delete the ldb file while the file is in use.

just ask them all to log out.

you may be able to automate a logout procedure, but it won't be easy to achieve reliably. the users should get in the habit of closing all forms, and returning to the main menu - then you sohuld not have any locked tables

there should not be any forms in the backend. these go in the front end, and you just reissue a new front end whenever appropriate

 

[clloftus]

Thank you for your response.

That is correct, I do not have any forms in the back-end, only the front end. So if I'm understanding you correctly, I can only make changes to the tables in the back-end if everyone is logged out?

 

[fitshase]

I've had the same issues with users not logging out when I want to make back-end changes. After a lot of searching, I came across a solution but I cannot post a link. I'll see what I can do though.



I have implemented it on my database front ends and it works a treat.

 

[fitshase]

http://www.databasejournal.com/features/msaccess/article.php/3548586/Auto-Logout-Users-for-DB-Maintenance.htm
aha - 10 posts so can post a link now.