file sharing lock count exceeded

[Ron Carr]

"File sharing lock count exceeded
Increase MaxLocksPerFile Registry entry"

I am updating 262,000 records in a DAO loop.
I get this message during the process.
How can I avoid this without updating the registry, or is that my best bet?
This needs to be installed on other machines and I prefer not to mess with
their registry.

Ron

 

[Jack Leach]

I am updating 262,000 records in a DAO loop.

Can you use an update query instead?
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Ron Carr]

No can't use query.
Updating records from a stored array of other values that can't be obtained
by query.
Ron

 

[DaveT]

This any help? See Method 2.

http://support.microsoft.com/kb/815281