Originally Posted by
Stingaway
Have a similar issue to this one - hoping someone can assist. I have a database that was working great with two people accessing at the same time. Database consists of several ODBC linked SQL server tables and a few internal tables. When more users needed access to the database I decided as a precaution to split the database. Database split, front ends were copied and distributed.
Now when one person is in the database with any version of the front end, said individual can perform all functions to a table (for this is example we are inserting records).
When two individuals attempt to enter the database the table becomes read only and users cannot enter new records.
Client settings are set to default open shared, record locking on edited record. Have checked network permissions, at this time all users accessing the database have full access to the folder.
What am I missing?
Clarification:
Access 2007/2010 version
Thanks in advance