Record Lock

[dabones99]

Hi all,

I have a database setup and shared on two computers. When I opened the database today and tried to open one of my forms I got this message:

'The Microsoft Jet Engine stopped the process because you and another user are attempting to change the same data at the same time."

I tried rebooting both machines but I get the same message, has anyone else ever gotten this error and how do I solve it?

Thanks in advance

Marlon

 

[jbehrne]

Hi Marlon,

You need to implement some sort of record locking mechanism in your db. Try this:

1)Open your db - go to 'Tools', 'Options'- on the 'Options' menu click the 'Advanced' tab, find the 'Default Open Mode' section and check to make sure the radio button for 'Shared' is checked. Below this should be a section labled: 'Default Record Locking', try setting your db to 'Edited Record'. Finally, make sure that the check box next to 'Open databases using record-level locking' is checked.

OR

2) On your each form go to it's properties, then go to Record Locks. Set it to "Edited Record". I would also set the Recordset Type to " (Inconsistent Updates)". However, if two users try to edit the same record at the same time you will recieve an error. Follow this link for more info:

http://support.microsoft.com/default.aspx?scid=kb;en-us;282382

HTH,

jbehrne