Max Locks per File

[DrJimmy]

Hi,

I'm trying to run a very simple update query on a table that has around 200,000 rows. It is only updating one field with the month based on a date using the Month() function.

It keeps saying File sharinglock count exceeded. Increase MaxLocksPerFile registry.

Any idea's on how to do this? The online help within Access is pretty vague.....

I'm also surprised this has happened as I've run update queries on tables with several million rows in before and never had this problem. I have compacted and repaired the database and moved from our server onto the hard drive of my laptop where there is more than enough disk space and with 2Gb ram there should be enough RAM as well.

Cheers

 

[KenHigg]

Try putting somthing like the following in your code:

dbEngine.SetOption dbMaxLocksPerfFile, 20000

 

[DrJimmy]

Thanks for that. I'm not running the query through a piece of code though - anyway I can just run it on it's own?

 

[KenHigg]

I haven't ever had to use it. Found it here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;286153

I would guess you could just call it once and it would be set.

 

[DrJimmy]

Worked a treat.

Thanks for your help.

 

[KenHigg]

My pleasure.