Sharing Access 2002 Database 1

[Zed5010]

Hi,

I have designed an ACCESS 2002 (MS OFFICE XP PRO) database. What is the best way to share this DB with other users for data entry (3 users)? Should I look at a server or shared folder on a PC?

Any assistance is much appreciated.

Zed

 

[jeffshex]

If your server is doing backups I'd store it there. That way if a computer crashes you don't really lose it and assuming that all these users are using different computers, they can still access it.

Check out under the tools - workgroups.
You create a workgroup for that database file. Then each person who is going to use it have them JOIN that workgroup. That should enable the capability to have multiple people in the database at the same time. If not, each person will have it locked under administrator I believe.

 

[JoeAtWork]

You don't have to use a workgroup file for multiple users. It is an option if you want to give people different levels of permissions to the tables, forms, etc.

Just make sure nobody opens the database exclusively.

Do you know about splitting the database into front-end/back-end files?

 

[Zed5010]

Thanks Guys,

Not sure how to split the database.

Also, what is the best way to make it a stand alone database that the design elements are hidden from the user?

 

[TheTomCat]

Make a FULL backup first then;
You can use the Database Splitter under the Tools\Database Utilities to split the database.

To make it standalone, you will need Office XP Developers Edition which includes the Access Runtime Packaging Wizard.

What I do is make the database an .mde file and then package it. The .mde file basically strips out all the source code.

Be careful because the ONLY way to get back to the source code is through your original database.


Thomas Bailey
a/k/a TomCat

http://www.reportcop.com

 

[Zed5010]

Thanks TomCat!!!

Excellent advise.

Regards,

Zed