hello everyone, i am making a database in MS Access 2003 on WinXP. when i publish this database to users in my office, i will lock it, hiding the table and all. my question is, is there a way to unlock it so that i can do maintenance and maybe improvements later on? if yes, how? helps are very much appreciated. thanx in advance.
unlock a locked database?
- Thread starter nescartel
- Start date
- Local time
- Today, 14:44
- Joined
- Feb 28, 2001
- Messages
- 30,566
Look up "Design Master" in the Help Files. Basically, there are a couple of steps to use.
First, split the DB into tables and "other stuff" - there should be adequate help in the Help files on splitting a database.
Second, make a design-master copy of your front-end, then publish the copies that are NOT design masters. Now, every time you have to do a design update, do it on the design master. Then make a new copy of the front end. Perform your locking on that copy. Publish that new FE copy to your users.
This minimizes your work load IN THE LONG RUN.
It also lets you lock down a copy of the DB a lot tighter than if you didn't take this approach.
First, split the DB into tables and "other stuff" - there should be adequate help in the Help files on splitting a database.
Second, make a design-master copy of your front-end, then publish the copies that are NOT design masters. Now, every time you have to do a design update, do it on the design master. Then make a new copy of the front end. Perform your locking on that copy. Publish that new FE copy to your users.
This minimizes your work load IN THE LONG RUN.
It also lets you lock down a copy of the DB a lot tighter than if you didn't take this approach.
Similar threads
