I am in the process of moving my database to a network so multiple users can share the data. In doing so, I have split the database. Once the database is split, I have the following problem(s):
I cannot run a report on one computer while a form is open on another. Error message is along the lines of " the database engine could not lock the table because it is in use by another person". I thought the point of splitting the database was to allow multiple users.
I then tried changing the recordset to "snapshot" from "dynaset" and record locks to "no locks" for both the form and subform. This results in error message " database has been placed in a state by another user that prevents database from being opened or locked". After I made that change, the other problem I noticed was on the form/subform, I was not able to add a record to the subform (add button was not usable).
Before I split the database I could get on it on the network and access all tables from both computers...I just couldn't run a report from a second computer while somebody was in a table on a first computer. I split the database to resolve this issue( I thought).