Two users entering data at the same time?

[alext49]

I have a database where two users might pull data from one central table.
They would then each enter data into separate form, creating data in separate
forms. They would then run a report which would pull data from that central
table and print it.

Is there any issue with them using the Database at the same time (i.e. both
of them having it open)? The data they enter in separate forms goes to
separate tables. The only reason the database is structured as 1 database
instead of two is both of their reports pull some additional data from the
same separate table.

Thanks, AT

 

[Golfinray]

I you have not already, you need to split the database. Several reasons, 1.
Corruption. The database is likely to become corrupted if two users using the
same files on an unsplit database. 2. Conflicts. They are much less likely on
a split database. Split and put the Backend (BE) on your lan. Load the
frontend (FE) on each users machine. Make sure the BE file has
read/write/edit/ and delete rights for each user and the folder it resides in
as well.