Repost - Couldn't Update; Currently Locked.

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


"Jamie Richards" wrote:

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

"Ndel40" wrote in message
...
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

Good afternoon


I suspect that the MaxLocksPerFile setting will have to be increased. This is
discussed in article Q102522

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.

How can I find the article?

"StCyrM" wrote:

Good afternoon


I suspect that the MaxLocksPerFile setting will have to be increased. This is
discussed in article Q102522

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.