In our company, we are wanting to have 3 to 4 people creating the databases, that the rest of our company will be using. How do we make the database files non-exclusive so we are able to make changes and save to the database with the 3 or 4 of us in it at a time.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
non exclusive databases
- Thread starter kfarley
- Start date
kevinnichols78
Board Regular
- Joined
- Aug 30, 2004
- Messages
- 112
Are you opening them with out checking the 'Exclusive' box?
Kevin
Kevin
Upvote
0
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Split the databases --- front end with queries, forms, reports, code, and links to ... backend, with all the data tables.
Give every user a copy of the front end and put it in their C Drives. Now all can use the backend (in a shared folder on a network drive).
When the logic changes (ie you make some more reports, queries, forms...) you give all users the new version.
If you want to protect the logic, make the front ends into MDE files but keep an MDB for making further changes.
Denis
Give every user a copy of the front end and put it in their C Drives. Now all can use the backend (in a shared folder on a network drive).
When the logic changes (ie you make some more reports, queries, forms...) you give all users the new version.
If you want to protect the logic, make the front ends into MDE files but keep an MDB for making further changes.
Denis
Upvote
0
Similar threads
- Question
