Microsoft Jet Database Error!!!

[cschuette]

Hi all,
quick question, while editing a record in my database I got pulled away while still in the record and during that time someone else entered the same record and made some changes. When I got back to my computer and finished making my changes I got the following message "The Microsoft Jet database engine stopped the process because you and other user are attempting to change the same data at the same time" Now I cannot make any changes to the record or even view the record without recieving this error message. I have tried to change the data in the table but still get the same message. Aside from deleting this record is there anything I can do to fix this? Any help would be greatly appreciated. Thanks. Oh yeah, I have tried writing code to run an update on the record but that didn't work either. Thanks again.

Chad

 

[ruthcali]

Do you see a circle with a line thru it (like a 'do not enter' sign) in the top left corner of the screen?

if yes, that means the other user is still in that record or a record next to it. And you can't edit the record until he moves away.
ruth.jonkman@wcom.com

 

[cschuette]

Actually I tried to check this out and I'm not seeing this icon, does that mean that something is wrong somewhere? Also the problem is that this has already happened and corrupted a record and I need to know how to fix it if at all possible. Thank you for your reply.

Chad
chad.schuette@numatics.com

 

[ruthcali]

I'm not too familiar with that error. i have just had locking errors in the past. i changed my database into a .mde and ALL the locking errors went away.

but, for now, i know this sounds lame, but can you close the database and then re-open it and see if you can then view that record?

do you know what user was in your record? is he still in it? ruth.jonkman@wcom.com

 

[cschuette]

Yes, I can open and close the database but the error still remains. This actually happened about a week ago so I'm unable to determine what user modified the record. I also am unable to create an .mde because in our version of access this option is unavailable. What do you think about the icon not appearing? Thanks again for your suggestions.

Chad
chad.schuette@numatics.com

 

[ruthcali]

The icon just shows you if someone is in that record. That icon is called the Record Selector.

Your form might not display it because it can be removed by going to View, Properties, Format Tab, Records Selectors=no.

But, if Records Selectors =yes and you don't see the circle with the line thru it, you are not having a locking error.

How many users use the database? if noone is in the database, do you still see the .ldb file?

if you are sure noone is using the database (you can try to open it exclusively to see if others are using it), but the .ldb file is still there, then delete the .ldb file.

normally, the .ldb file is automatically deleted when the .mdb file has no users. but, when there are problems, it can remain and cause errors.


ruth.jonkman@wcom.com

 

[cschuette]

I did come up with the Record Selector, that works fine, but as for the .ldb file that is all working correctly. It's perplexing to me as well. I've tried everything in the help files but still can't get this to work correctly. Also in the field that I tried to change there is a "#Error" value now as well as getting the message box when I enter that record. Thanks again for all your suggestions, I'll be turning on that record selector.

Chad
chad.schuette@numatics.com

 

[JimRich]

Have you tried deleting the '.ldb' record? You may have to delete it on many users computers.

 

[cschuette]

The .ldb record diappears once everyone logs out. This has happened with no problems since the record was corrupted. The .ldb file doesn't seem to be the answer.

Chad
chad.schuette@numatics.com

 

[nogarede]

you must have had a corruption on your table due to a network problem while working on the database or a pc not shut down properly. Try to repair/compact the file. Try also to create a new file and to reimport all the table/query...etc

 

[junkjones]

I am having the exact same problem as cschuette is describing - it started when i was uploading a database through ftp to the server, and i got cut off halfway through the upload and had to start again. I created a new file and tried to import the table, but i still get that darn error when I try to import it. I'm starting to get scared!!

 

[jofarrell]

Because you were away for awhile why not check and see if the .ldb file didnt get saved to a temporary folder or something. I got an error similar doing something completley different and sure enough there was another .ldb file present for the same database on my computer and the folder in which I was using the database had the .ldb closing as normal. Just a suggestion if you cant find anything else that may be causing it.

Joanne

 

[junkjones]

Hey - I repaired the database and it worked! Hopefully it will work for you too cschuette!

 

[cschuette]

If only I was so lucky, I've repaired, compacted, and also imported all of my data into a copy of the database frame and I still end up with that error. Also I was unable to locate any renegade .ldb files. So does it look like I'm screwed or what? Please tell me that somebody knows how to fix this!!!!!

Chad
chad.schuette@numatics.com

 

[NiteLink]

Just to add on, is there any way to revent this kind of errors? I have this problem with my table.

I have tried compacting and end up with a new table called "db1" with all the same data inside the table. But one of the currupted record has ##### instead of the original data.

Is there anyway to prevent this from happening?