DAO.Recordset Lock

[paddler]

Hey

 The laptop I have EA installed on crashed whilst I was working on a diagram. Now, every time that I select said diagram ( or export the model to XML) I get an error

"DAO.Recordset[3197]

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

 Does EA offer a means of identifying and eliminating locks within the database? This one is more of an anooyance but I am concerned it may  happen on something more important next time

...p.s. : Yes, I am trying to get the client to move this to a server on the prod network so I can ditch the laptop

[Paolo F Cantoni]

Have you done a repair with MS Access?  The .EAP file is just a renamed MS Access DB.

If you do a repair and compact after having rebooted to ensure nothing is "holding on" to the DB then that may clear your problem.

HTH,
Paolo

[paddler]

Hey Paolo

 I found articles on the web suggesting what you pointed out. Unfortunately, I do not have MS Access installed on the laptop so I cannot open/repair the db that way.

 oddly enough, it seems I could delete all items related to the diagram but not the diagram itself. Once I tool away all "diagram child" objects I could then delete the folder which contained the offending UML diagram....spooky.

 You must be enjoying the beginnings of spring as I contemplate the onslaught of my Canadian winter?

Cheers
PT

[Paolo F Cantoni]

Hi PT,

Glad to see you managed to get around your blockage.

If you don't have MS Access, Sparx provide some management functions directly via Tools|Manage EAP file>

Have a look in case you need them in the future.

I would, however, advise that you get a copy of MS Access so you can check on what EA is doing.  Most of us have found it extremely beneficial to "see" what EA is doing directly in the DB.

HTH,
Paolo