Book a Demo

Author Topic: DAO.Recordset[3197] Error  (Read 3870 times)

hobby

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
DAO.Recordset[3197] Error
« on: December 15, 2010, 01:22:51 am »
DAO.RecordSet[3197] Error
"The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at same time."

I am facing this issue with my EA Model for the last couple of days. This EA model was being shared by multiple users using a shared folder. We were not experiencing this issue over the last four weeks of shared using. Now this issue exist even after removing the share of the folder. This error is only for few Packages and not for whole EA Model.

Please share your experience as how to fix this with the existing model.

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: DAO.Recordset[3197] Error
« Reply #1 on: December 15, 2010, 08:24:33 am »
We use SQL Server
Orthogonality rules
Position and Team disestablished, thanks austerity.
Now itinerant.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: DAO.Recordset[3197] Error
« Reply #2 on: December 15, 2010, 07:59:39 pm »
You could try to do some maintenance on the db (Tools|Manage .EAP|Repair or Compact), but in general I would advice to start using a "real" database iso the eap file.
MS Access + Multiple Users => trouble :P

Geert