| | |
|
|
|
Re: Re: Problem changing datatype of a field in a table with many records |
| message from =?Utf-8?B?bWFyZzEwMzdAbm9lbWFpbC5ub2VtYWls?= on 2 Jun 2004 |
I am having the same issue, or at least a related one. i am working with an access 2000 db, and it has about 190k records in one of its tables. I am trying to add an autonumber column to it and get the message that "file sharing lock count exceeded. increase MaxLocksPerFile registry entry". currently, my registry entry for MaxLocksPerFile value data box says 251c, though I have increased it to 400,000c and 900,000c and 999,999c -- in hopes of eliminating the problem. It says it's base is hexadecimal, not decimal.
I have seen posts where users corrected this error by editing the registry entry for MaxLocksPerFile, but it does not seem to work for me -- my error still occurrs. Can you please offer other options? Thank you!
|
|
Archived message: Re: Re: Problem changing datatype of a field in a table with many records (MS Access Database)