I want to split a database and put front ends on multiple users computers (8-10 computers). I split the database I have created, on our shared network drive, and left the back end there. I then put copies of the front end on each users computer. I then tested to see if it would work by having each of them open forms and start inputting data. However, only the first person was able to open their form, the other users got an error saying the table (CallInfo) was already opened. I can't seem to find a setting that would fix this, and my understanding is that multiple users should be able to input data simultaneously. I tested it on my own computer and the network drive and it worked fine, so It does work for one user at a time. Any ideas on this? I looked through Using Microsoft Access 2007 but was unable to find anything to fix this.
Note- my database is not completely optimal in its design. I have two tables that get updated simultaneously from any of the Forms. They share information about a particular call and are linked by an autonumber on the first table as the Primary Key and a lookup on the second table as a foreign key, that matches the autonumber in the first table, to match them up as one row of data. I did this because otherwise the table was very large. Not sure if this matters, but figured I'd mention it.