Delete Query in Macro Hangs-up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run delete query from a macro and it is hanging up. When I
delete the records from the table manually, I get the following error:

Couldn't Update; Currently Locked.

This error is most likely the cause of the macro hang-up.

There is nothing open or running when I try to manually delete records or
when trying to delete using the macro.

Any help would be appreciated.

Thanks,

Nick
 
If it's a record locking problem, check under Tools-->Options-->Advanced
tab. See section entitled "Default Record Locking" and if "All records" is
checked, change it to something else ("Edited record" may be good but base
your decision on how records are accessed and whether the database is
multi-user).

Consider if your db is opened in shared or exclusive mode...

HTH

Jamie
 
Thanks... I'll give ot a try!

Jamie Richards said:
If it's a record locking problem, check under Tools-->Options-->Advanced
tab. See section entitled "Default Record Locking" and if "All records" is
checked, change it to something else ("Edited record" may be good but base
your decision on how records are accessed and whether the database is
multi-user).

Consider if your db is opened in shared or exclusive mode...

HTH

Jamie
Click to expand...
 
I still get the following error message:

Couldn't Update; Currently Locked.

If I do a Ctrl-Break it let's me delete ~10,000 records at a time.

There are 700,000 records in the table.

Any other ideas would be great!

Thanks,

Nick
 
Back
Top