Error From Jetdatabase.....

[salimudheen]

While i open the form the form is opened with this error message " The Microsoft Jet Database Engine stopped the process because you and another user attempting to change the same data at the same time"... But actually only one user operate this record... no more user.... Then y it was happened.. pls help me....

[nico5038]

Hard to diagnose from a distance, but in general this message is caused by code behind the form or by opening the same form multiple times.
Do you have VBA code "behind" the form ?

Nic;o)

[salimudheen]

Hi Nico,
I have the subform... i bound the form using query in desn view....
In my form is bounded well, but in my subform didnt bound and field displayed #Error, and displayed the error message "The jet database engine stopped the process bcoz u and another user are attempting to change the same record at a same time"...
But my system is working all well.... these problem from my client side only...
Wats the soln.....

[nico5038]

I get the impression that the mainform and your subform query are referring to the same table.
This can't be done and I've never experienced a situation where I had to do this.

What's the objective you have with the subform ?

Nic;o)

[salimudheen]

Using subform, to display the records from the different table bounded to the main form.......
And then i allowed to entry the new records thro the subform.....
while the form is opened, that time the problem(we discused) is occured......

[nico5038]

Hmm, then it can be a corrupted database.
Use Tools/Databases/Compact and repair to try to correct this.
When that doesn't work open a new database and use File/Get external data/Import to get all objects so you have a fresh copy.

Nic;o)

[salimudheen]

Okey nico,
I try to clear this problem with the help of ur knowledge....
Thanks to help me.....

[nico5038]

Keep me posted with your progress :-)

Nic;o)