Use Case Scenarios cannot be updated.

[robinjuc]

Hello:

I have a problem when i try to update some use case scenario from its Properties (Scenario tab).
There is an error, EA shows:

DAO.Recordset[3197]
The Microsoft Jet database engine stopped the process, because you and other user are attempting to change the same data at the same time.

However, i am the only user updating the data in a certain time.
The worst of all is all scenario saved previously, is erased.

I hope you can give me a solution.  

[beginner]

I occassionally get similar errors when working on my laptop. I never get this kind of error when working with our MySQL server. So I believe it's got to do with scrappy M$Asses (oops, did I misspell?). As I don't care on the laptop sandbox this is okay with me. For production I would setup a MySQL (or something similar).

b.

[robinjuc]

So, the only solution is to change the DB server from MsAccess to any other?

Well, thank you very much for the advice.

Greetings...

[KP]

So, the only solution is to change the DB server from MsAccess to any other?

Well it almost certainly isn't the only solution: if you submit a bug report through the official channels, I'm sure someone can help.

[Paolo F Cantoni]

In line with KP's comments:

1) Are you using the JET4 engine?
2) Is it an Access2000 or later db?
3) Have you run a Project integrity check and removed all issues?

I've found the .MDB file to be a very stable and useful platform, for over 5 years.  However, I took the precaution of NEVER using the "out of the box" Access97 databases...

Paolo

[beginner]

Well, for me I'm using the EA out-of-the-box installation (with Jet3 as default, if I remember right). I even do not have M$Officium installed. For me it's strange if the application tells me that records are locked on a machine where I'm the only user. But on the other hand I'm used to such kind of scrappy M$ behavior. So I ignored it. Also it is not possible to reproduce this behavior. Which in turn makes a bug report meaningless.

b.

[byron baxter]

had same issue when my xp desktop crashed with a diagram open. don't have ms access and the compact tool in EA returned error about not having read permission on the file.

i used the data sources tool ( control.exe odbccp32.cpl ). on the user dsn tab, highlight ms access and click the configure button. options to repair and compact are available.

good luck!