Hi everyone,
We've tried to split our database - we have a back end file with user data and passwords; and a back end file with the actual data for a study we're doing.
We successfully split the database, tables are linked and we built forms and queries on the front end.
Now when we tried to put different users using it we have a "Could not save; currently locked by another user" error. Is there any key aspects that we're missing? We've placed people with full control on the distributed files, we tried copying the distributed files to the desktop, the advanced settings on the options are also allowing Shared status instead of Exclusive. "Open Database by using record-level locking" is also ticked.
Kind regards