Access 2000 Bugs or Problem with locks

[JUANCARLOS]

I activate in the form locks by registers but in a multiuser environment when a user open the last register on a form clients, and another add a register to the same form and the last click in the bottom to save, appears the windows that says "copy to clipboard, save , not save", if he respond save, the database colapses, generating a registers with "eliminated########". And I cant add more registers but I have a ID that takes function dcount to count the registers and add more.

Someone can explain what happens, a remedy?, haw can control this?.

Plase help, thanks in advance.

JCHR

 

[JUANCARLOS]

Someone can Help with this problem.

 

[MadJock]

I have came across a known problem where Access 2000 goes overboard with record locking. I do not know the technics of what the problem is but have found that the only workaround I am aware of is to unbind all controls on the forms and then use code to populate and / or store records.

If you have a rake around the Microsoft web site, there is some info there.

Hope this gives some help.

Graeme

 

[JUANCARLOS]

Madjock, do you have a especific URL, how do you do to solve the problem. Do you have code? a example.

 

[MadJock]

Sorry JuanCarlos,

Do not have URL. Am working on code at the moment. Basics are -

Create a dynaset of the table in VBA and then go through each control on your form and store the contents into the dynaset.

Unbind any combo boxes and use code to populate them (this is in the Microsoft Acess help).

If using a review mode, populate the fields using recordsets.

If I find the URL for the Microsoft Post, I will post it here so pop back later.

Cheers,

Graeme