Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Location
    UK
    Posts
    67

    Unanswered: S.O.S. - Could not update, currently locked by another user

    Hi All,

    I am having a very bizzare error, this database is opened exclusively by me for loading massive amount of data overnight (i am talkin 1 million rows). Now, overnight some thing happens and I get the error message "Error 3046: Could not update, currently locked by another user".

    I have gone down to stop the backup jobs looking at my folder where I am loading this data. I am still referring to the master data in another folder which is backed up. But that does not help either.

    I am still getting the same error, but it is now delayed by some 30 minutes (does it mean that I cannot even read the data from master data backend).

    Can some one tell what next do I have to do, (copy the tables to temorary front end to laod and validate the data)?

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    What did you do when it happend. Did you add-ed a new record,
    or changed an old record. Was it the first time you got this error ????

  3. #3
    Join Date
    Jan 2002
    Location
    UK
    Posts
    67
    This is a data load application and allows to import new data from CSV files. The current data is not touched at all.

  4. #4
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    I don't know exactly what it can be. I suppose you have got
    ayn LOCKS in your App, (Record Locks or something similar).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •