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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sharing Access database... 1
- Thread starter Albano
- Start date
-
1
- #2
Here is one way to do it...
Try creating a repository database (MDB) containing only your tables. Place the repository database to a central location. The path to that location should be identical for all workstations.
Then, inside the application MDB (this has your forms and code) link the tables from your repository MDB. You can then compile the application MDB into an MDE and distribute copies of the MDE among workstations. Remember, in order to use the MDE, each workstation needs to have Access installed.
Each user should be able to work with the repository database using your application MDE simultaneously.
If you are still confused, I would read up on the topics I mentioned above either at Microsoft.com or the MS Access Help, or MSDN subscription, if you have it.
Gary
gwinn7
Try creating a repository database (MDB) containing only your tables. Place the repository database to a central location. The path to that location should be identical for all workstations.
Then, inside the application MDB (this has your forms and code) link the tables from your repository MDB. You can then compile the application MDB into an MDE and distribute copies of the MDE among workstations. Remember, in order to use the MDE, each workstation needs to have Access installed.
Each user should be able to work with the repository database using your application MDE simultaneously.
If you are still confused, I would read up on the topics I mentioned above either at Microsoft.com or the MS Access Help, or MSDN subscription, if you have it.
Gary
gwinn7
- Status
Similar threads
- Locked
- Question