Database with multiple users

[sueviolet]

I need some advice on the best way to do this.

I have created a single database (3 tables - Access 2000) with a simple data entry form.

What I need to do:

There are going to be about 5 people that need to enter data into this database. A database will need to sit on their desktop so they can enter the data, possibly at the same time. I want there to be a 'master' database where all data is located.

I am unsure as the best way to do this (splitting database??)

Your help is greatly appreciated!

Thanks

 

[Randomblink]

My Recommendation

What I have done is this:

I created a BackEnd database.
I called it: BE_MTS.mdb

This is because the database was built for a company named:
Midwest Title Services

and the BE tells me it is the BackEnd

I put ONLY Tables in this Database.

THEN:

I created a FrontEnd database.
I called it: FE_MTS.mdb

The FE tells me it is the FrontEnd

In THIS database, I put all my Forms, Queries, Modules, Macros, etc...

I put the BackEnd on the Server.

I put the FrontEnd on my Desktop.

The next step is to LINK the Tables.
What I did then was, if you right-click in the Tables area (you know? where you create and view your tables), you will get a Menu, one of the Options is: Link Tables

Select that option.
Once you select it, you are taken to a window where you browse TO your BackEnd... Here is the Tricky Part.

Browse to the BackEnd NOT through your Networked Drives... Use the server address instead...

IF you use the server address, then you can just email your FrontEnd to any other user with permissions on that server and they will now have the same access you do...

IF you instead use the Network Drive? Then you will have to re-LINK your tables once you get the FrontEnd to another computer.

Once you have finished the Linking...
You will have a split database.

Now I went even further...
I am using some code that will CHECK another server folder where I store a TEMPLATE_FE_MTS.mdb
Inside the Template DB I have a field I can set called Version. Whenever a user opens the FrontEnd on their Desktop it checks my Template DB and if the versions don't match? It copies the Template OVER the older FE they were using...

Kinda cool cause then I just make adjustments on the server to the Template, and all users now are using the newest db out...

Hope that helped... Any other questions... just ask...

 

[sueviolet]

Thanks for your help! I will give that I try

 

[pcEars]

Access 2k2 has a wizard [maybe other versions also] that will do it for you.

Tools|Database Utilities|Database Splitter

Be sure to make a backup BEFORE you try it