No delete due to lock violations

[Charlie]

Hi,

I was trying to delete records from a history data base
using a delete query, and received the following
message: "Can't delete 978 record(s) due to lock
violations." The DB is on a network. Everyone was off
the system. Some records were deleted. Could this be a
network problem?

I appreciate any ideas/suggestions.

Thanks.

Charlie

 

[Dale Fye]

Have you checked the referential integrity rules for the table?

If you have referential integrity turned on , but don't have cascade
deletes turned on, then JET would prevent you from deleting those
records that have matching values in other tables.

--
HTH

Dale Fye


Hi,

I was trying to delete records from a history data base
using a delete query, and received the following
message: "Can't delete 978 record(s) due to lock
violations." The DB is on a network. Everyone was off
the system. Some records were deleted. Could this be a
network problem?

I appreciate any ideas/suggestions.

Thanks.

Charlie