Allowing a database to be opened by more than one person

[JBurlison]

How can i have multiple people entering data into a database, also there is an excel file that imports the info every few min, if i have that open i cannot enter data into the database. theres going to about 4-5 users plus the excel file.

 

[georgedwilkinson]

Split the DB into a front end and back end.

Each user and/or process gets their own copy of the front end.