File Locking Problem??

[PaulSpell]

I'm trying to run a routine under XP that worked perfectly well under NT 4.0/Novell Netware, but keep hitting a record locking problem. The error says the file sharing lock count has been exceeded.

I'm using the .edit / .update method to write new values to specific records in a table of over 200,000 records. Is there a way round this other than by changes to thr registry?

 

[PaulSpell]

Could do but wouldn't that mean that I could then end up with partial updates if one block failed, as I would only be able to roll back before commiting the transaction.

I just got this from Microsoft, do you think this will deal with the problem ?

DAO.DBEngine.SetOption dbMaxLocksPerFile, 500,000

This temporarily resets the MaxLocksPerFile for the current session. Can you see any problem with using this?

 

[noccy]

Anyone know how to solve this problem with ADO?

noccy