Access locking up with multiple users

[Dragn73]

Is you network platform Microsoft of Novell?

Are there memo fields in your data entry form – if so how many?

Does your query contain 2 or more tables with a one to many relationship? If so, a Main Form / Subform approach should be used.

Look at the design view of each of your Forms, Reports, Modules, and Queries and look at the Record Locks Property of each – make sure it is set to “No Locks”.

Also, try opening MS Access twice on your PC - each instance opening the database. See if you can consistently reproduce the error by entering data in both open sessions (switch back and forth between the two). If you can recreate the steps the users are doing – you may be able to narrow down the field – tables giving you the issue.

thanks for the suggestions.
I have a Microsoft platform

I have 1 memo field

I have 1 query with 2 tables linked (there is nothing showing in the relationship section however. In the design view of the query itself it shows a link from help desk tech to issue Id numbers. As of now it appears that the query pulls the data correctly, in data form, it shows the issue ID and the tech its linked to. If I delete the relationship, then in the data view, it shows a line of issue ids for every tech in my table.) I haven't used a main form/subform route yet,so I am not sure how to do this

I show "no locks" on all

I did alot of testing with another teammate and we never once had it lock up on us, I can't recreate the issue. And it happens more on 2 of the 3 users. The other person has only had 2 small lockups in 3 weeks, where the other 2 have lock ups all day.

 

[Dragn73]

Dave (dcobau) – you are correct if page level locking is being used (good point).

Dave (Dragn73) – at each users workstation select Tool > Options from the menubar in MS Access. From the Advanced tab make sure the checkbox “Open database using record level locking” IS checked.

All my users are using Access Runtime so i can't so this on each machine, but i did check this before I gave them their copies of the FE and actually i read somewhere else that I should uncheck that box, so right now, its unchecked.

Since that isn't working, i will go back and check it and see what happens.

Thanks

 

[MicroE]

You need to enforce referential integrity between your 2 tables.

Place the focus on the database window – from the menu bar select Tools > Relationships and create the relationship between the PK and FK on the 2 tables.