Database crapping out

[bpaquette]

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

That's the error when I try to open my split database that's stored on a shared drive. I've had all users reboot their systems to sever any leftover connections, but still nothing. If i move it to my desktop (copy, rather), it still errors out.

Anyone seen this happen? I haven't backed up in awhile, hoping this isn't a harsh lesson.

Thanks
BP

 

[Mile-O]

Either this or this and it is evidence of corruption as highlighted by this.

 

[bpaquette]

i clicked through there and read all that jazz, but it seems to imply those errors/fixes are for access 97 and all they suggest is to bring my jet engine up to date... i'm running 2002 so i'm assuming it has already been brought up to date.

any ideas? i can't even repair the damned thing nor import obj's from it w/o receiving that error


thanks
bp

 

[bpaquette]

,and, those kb pages imply that there's a data corruption problem, and that that causes the error -- but the 'back end' of the db works fine -- fields and all. the front end is the only one that's pissed out on me.

 

[The_Doc_Man]

The one that got me most often was an audit history table that would be updated by many users at the same time even though they were touching different data tables.

The only way I found to stop the crap-out was to trap the update of the audit table and put in a loop. I made the loop delay by inserting a DoEvents call, then trying to do the audit update again with a fresh time-tag.

I'm not saying that the same exact thing applies to you, but if you are doing centralized logging from a shared form, you might indeed have this problem. The table that is tripping you up isn't the one you think it is. It is your history table.

Of course, I could be wrong on this, too. Could be any table. But the above is the only experience I have with a similar problem.

 

[bpaquette]

were you able to repair the db, though?

also, you don't have a sample of that code do you? loops i'm familiar with but i'd like to see an example in action.

I am running an audit trail module, and the form is shared, so that sounds pretty feasible.

thanks
BP