Shared database not accessible

[OracleVictim]

I have a combination of Access 2000 and Access 2003 users. My application was developed in a 2003 version of Access. The production version of this application is on share drive. I have a form that uses a query for a the record source. That query is set "record lock = no lock".... My problem is that when a "2000" user does an update or creates a new record using this form the database become inaccessible by any other user until the current user dismisses that particular form. The message that one gets is that the database has been put in a state by admin that makes it inaccessible (doesn't say anything about locking)..... I've tried inserting a requery and a refresh with the "save" with no success.... Any ideas?

 

[JerryKlmns]

If you change it to record lock = Edited Record?
Don't forget the form...

 

[OracleVictim]

Thanks a bunch... I'll give that a try.