MS Access 2016 - Multiple users adding records to different tables not working?

Question

I have an MS Access 2016 database. I have split to front-end and back-end. I have multiple forms being used. All forms and subforms have "Record Locks" set to "edited records". Both the front-end and back-end have default records locking as "Edited Records. All users have front-end on their respective desktops with linking to the back-end which is stored/located on a WD My cloud. I have 2 users who are trying to add data to 2 different tables. User 1 will add to table 1 and user 2 to table 2. If they are working at different times (i.e. User 1 is using tool and user 2 does not have Access open) then all writes to the appropriate table work without issue. However, if both users are trying to add records to their respective tables at the same time it doesn't work. I had user 1's record appear in their table while users 2's records did not get added to their table. I looked a the table data myself after each finished their add. Then later when both exited and re-entered the application, User 1 found their records had disappeared and user 2's records now existed. The 2 separate forms in question do each have combo boxes that populate data from different master tables (i.e. employee name, project name). I have made sure that the combo boxes are set to "limit to list" and "allow value list edits" to "no". Although these I just changed and haven't seen if it resolves the issue but I suspect that has nothing to do with my issue. What am I missing to get both users to add records at the same time to their different, respective tables?

Answer 1

I would be interested in finding out if you had the same issues on a local network drive. I'm not convinced My (or any) Cloud is a good alternative for an Access backend database.

Do you see a locking file created when a user first connects to the backend database?

Have you successfully used My Cloud in the past for Access?

I have not used My Cloud in past.  This client is a very small outfit with no real servers.  At one point we had the BE on a laptop that was exclusive only for that purpose.  I found that I could link my tables to the FE with my cloud which also served other purposes for them in storing their customer files.  So I suggested my cloud and they are happy with it.  However, as my issue is now that 2 users cannot seem to add records to different tables at same time, I am not happy.  They are willing to work around it by shouting out to each other when they need to use the tool.  That just simply is not acceptable to me personally.  I do see a lock file created when a user first connects to the BE.  However, I do not see a second lock created when the 2nd user connects.  I was thinking at record lock there would be a lock for each user.  However since they are both adding new records, I am wondering what "record" would be locked as the record does not even exist.  This is a brand new application so they are trying to load some historical data.  Therefore, the need for multiple users at same time may not be as big an issue once they have the historical data required loaded and they are in everyday mode.  But I want this to work properly.

Answer 2

I would be interested in finding out if you had the same issues on a local network drive. I'm not convinced My (or any) Cloud is a good alternative for an Access backend database.

Do you see a locking file created when a user first connects to the backend database?

Have you successfully used My Cloud in the past for Access?