Delete Query in Macro Hangs-up

[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

 

[Jamie Richards]

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

 

[Guest]

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

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

 

[Guest]

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