Microsoft Access 2010 inconsistent user access

[xkraex]

Hello, all! I am working with Microsoft Access 2010 and having a strange issue. Some users can open the database and add records and make other changes, other users open the database and add records but it only appears on their own computers. We are working off a shared drive, so I do not understand how new files are being created that only certain users can see (and they are only seeing their changes and not my changes and those of the other users). Everything looks fine in the file properties and everyone has the same security properties at the file and at the network folder level. I don't understand what is happening. Has anyone ever experienced something like this? I know that access can have issues with too many users, but we are at 5 users right now (we will be at 12 users if everyone comes online), so I did not think I had to worry about issues with too many users at this point, if ever.

thanks much,
Kristina

 

[Alansidman]

Have you split the db into a FE and BE?

Read here
http://www.databasedev.co.uk/splitting-ms-access-database.html