Multiple Users One Database

[robinsonbst]

Hi Guys

I wonder if anyone could give me some advice on a problem i have with an access database.

I have designed a database and a data input form to collect data that is input by workers, the problem i have is that only one person can enter a record at a time.

I curently use 2 replicated database's on two seperate computers and run the synchronisation once one person has finished so that all the changes are replicated to the 2 different databases

If there is any other easier way to accomplish this i would be very greatful if anybody can shed some light on the subject.

Thanks
Brad

 

[rainman89]

look into splitting your database to a front end and backend.
if u do a search on this site you will find tons of threads on splitting. its pros and cons.
the pros definately outweight the cons. its good for data security and protecting your db from "big fingered" or "fast click" users

post back if those other threads dont help you

 

[robinsonbst]

Thanks

Thats great thanks for the info

One more question the form that people enter into has a autonumber field and when i enter records on seperate database it see's these as duplicate records will this be eliminated using the front end and the back end.

Thanks
Brad

 

[KeithG]

yes it will.