Table Analyzer Wizard - failure to partition table

[Guest]

I have a single table in an Access database - 133000 names and addresses. I
am trying to partition table into two parts - names & addresses. Table
Analyzer seems to get 80% through, then fails with message "file sharing lock
count exceeded; increase registry entry MaxFilesPerFile.

Default value of 'MaxFilesPerFile' is 9500. Tried 25000 and 250000 with no
observable change in behavior.

Originally, failure was in Access2002 on computer on Novell network - IT
asserted that problem was to to conflict with Novell drivers. Current
failure is on standalone computer running Access 2003

 

[Arvin Meyer [MVP]]

Record Locks per File is a Novell thing. I haven't worked much with Novell
since NT4 came out 9 years ago, but I can tell you the settings for older
systems:

In the AutoExec.ncf change the settings to:

(for 3.x servers)
SET MAXIMUM [RECORD] LOCKS PER CONNECTION=10000
SET MAXIMUM [RECORD] LOCKS = 200000

(for 4.x servers)
SET MAXIMUM [RECORD] LOCKS PER CONNECTION=20000
SET MAXIMUM [RECORD] LOCKS = 400000

I have no idea what to do with later versions of Novell. You should not have
this problem on a stand-alone unconnected Windows computer.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access