JET DB error 3197, another user try to change

[Gabor66]

Hi,

I'm using the EA 7.1 build 733 with the MDG Link for VS2008. on Win XP.

When I search in the EA project, I get a DAO error 3197:

"The Jet DB engine stopped the process, because You and another user are attemting to change the same data at the same time."

I'm using the program in a single user enviroment, but sometimes copy the eap file between the wo PC back and forth. The VS2008 installed only on one of them.

The program worked well before.

Does anybody knows the reason of this error, and can propose the solution?

Thanks in advance

Gabor

[«Midnight»]

I guessing here, but...

You might have the Desktop edition on one or both machines. This could complicate some of the issues below.

Before you do anything else, make a copy of the file. Try the following on the copy.

You might have copied the file while it was open. MS Access files - an EAP is basically an Access file with another file extension - can 'think' it is locked when this happens. Try opening the file with EA on either machine. If you succeed, exit EA normally. In Windows File Manager confirm that the .ldb file in the same folder as the EAP file has disappeared. Then try moving the file to the other machine and see if this solves the problem.

If not, try to repair the file. Open EA - but not the project - and from the main menu find Repair EAP File. [Note: I do not have an old copy of EA (you say you are using build 733) so you will have to find this option yourself. In build 833 this option is under Tools | Manage EAP File | Repair EAP file.] See if this solves the problem.

If nothing else works, try repairing the file with MS Access. If you do so, you must save the file (Access might call this an export rather than a save option). You need to save the file in Access 97 format if you have Jet 3.51 set in your Tools | Options | General dialog (this is the default setting); save in Access 2000 format if you have Jet 4.0 set.

HTH, David

[festenhas]

I'm having the exact same problem, but I DO use the file in a multi user environment. Whenever I get this message ( it happens when I try to open certain diagrams ) the .eap file gets corrupted ( message when I try to open the .eap file again: An Error has Occurred: Unrecognized database format 'FULL_PATH_HERE\MY_PROJECT.EAP'. )

I tried to repair the file but I wasn't successful with the steps mentioned by Midnight.

Is there any other way to save my project? I have weekly backups here, but I'd really appreciate if it was possible to repair the project because I don't know when this started happening ( the file only gets corrupted when I open some diagrams, and I don't even save it or anything )

I could provide the file if needed ( 33 megabytes )

thanks a lot

[«Midnight»]

Hi Gabor,

This is just a guess, but...

Perhaps the contents of the file were disrupted when the original problem occurred. By this I mean that the actual data might be readable - as far as Jet (the Access engine) is concerned - but might not have integrity as far as EA is concerned.

Once again, make a copy of the file and experiment on the copy.

Open the project in EA, and do a project integrity check. You'll find this under in the main menu somewhere. [I don't have my EA machine here, so you will need to look it up. Try Project Integrity Check in EA help.] If the integrity check can find errors, repair them and see if you are now OK.

If not, try exporting the entire contents of the project to XMI. Then import the contents to a new empty project. Do not strip GUIDs. This might work. If not you can set the strip GUIDs option and try importing to yet another empty project; perhaps something in the referencing got trashed and this would help.

Meanwhile, did you check that none of the users are working with the desktop edition (or whatever it's called) of EA? This edition seems to use different default access rights to EAP files, so perhaps that is the problem. [I think this is a long shot.]

David

[festenhas]

Got it to work.

I tried the EA menu to repair the file but it just wouldn't work

To repair it I opened the EAP file with MS Access then I exported it to the 2000 format, some errors occurred, then I switched back to the 97 format.

Now the file opens correctly but I have really no idea of what was lost. perhaps only EA metadata was lost, or some bad data that was lost inside my project.

for now everything is fine, but I was wondering if this is a good way to use EA

I mean, I'm using it in a multi user environment opening the file directly through the network.

I thought about exporting everything to a Oracle Database, is it any better?

thanks