can two people enter data into the same database at the same time?

[chriswrcg]

I know the answer to this is probably no but I had to ask anyway. Is there any way for two people to work on the same database at the same time entering in data and then combine the two into one whole database again?




Here is the scenario,
We have multiple days of data to enter into the data base. Lets say Friday through Monday. In order to speed up the process and not put it all on one guy, can two people open up instances of the database on two computers and put in the data and then merge the two back into one database again?


I understand that what will happen is that there will be the same record number for two different lines of data since both are working independently. I was just hoping there is a merge setting that will automatically reset those records numbers accordingly.

[isladogs]

Yes it can be done - but not the way you describe it

In a multi-user environment, all databases should be split with all tables in a shared backend database on the server (or a shared network drive)
The front end database contains everything else - forms, reports, queries, modules, macros
Each user must have their own copy of the front end on their own hard drive

The purpose of doing all that is so that several users can safely use your application at the same time
Each will be able to enter or edit records as the data is stored in the shared backend database

HOWEVER, whilst one user is editing a specific record that record will be LOCKED so the other user will not be able to edit the same record until the lock is removed - when user 1 leaves that record

Hope that all makes sense to you

[chriswrcg]

The front end database is located on server as well as on individual computers. What settings would I have to change to make it a multi user environment?

[isladogs]

Do you have a shared backend as described?
Are all tables in the backend? If not, any tables in the front end will not be visible to other users

What is the purpose of the copy of the front end on the server?

[orange]

You may get additional info from this multi-user article by FMS.