file sharing lock count exceeded

  • Thread starter Thread starter Ron Carr
  • Start date Start date
R

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
 
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)
 
No can't use query.
Updating records from a stored array of other values that can't be obtained
by query.
Ron
 
Back
Top