Having trouble with increasing MaxLocksPerFile in registry

[Oleg]

sorry for a common topic, but i couldn't find anything search for my scenerio

I increased the number in Value Date to 2 million, yet i am stii getting this annyoing message. Few questions

1) what should i have as base - Hexadecimal or Decimal ?
2) Does 'Value Date' supposed to have 'c' at the end ?
3) whats the max number i can enter ?
4) Do i have to restart PC after changing ?

 

[boblarson]

First - how about telling us about the problem which is causing you to attempt this?

1. What version of Access are you on?
2. What is the original problem?
3. What are you attempting which appears to make the original problem appear?

 

[Oleg]

hi Bob

Access 2003

getting MaxLocksPerFile error when i am trying to assign AutoID to table that has 195,000 records

 

[boblarson]

So you are adding an autonumber to that table? What I would do is to copy the table (structure only - you can right click on the table, select copy and then right click on the area where the table names are and select paste and in the options that come up when you name it, select structure only). Then you can add the autonumber field to it and then run an append query to append the 195,000 records to it. Then rename the old table (make sure that NameAutoCorrect is turned off) to something else and rename the table you just appended to the name of the old table. That should get you past this problem without having to go through all of this locks stuff (which I don't think will help anyway).

 

[boblarson]

Oh, and you should probably test this on a copy of the database first.