File sharing lock count exceeded - trouble with "method 2"

[FSPH]

Good day!

When pasting a large amount of data into an Access table, I get the error
message "File sharing lock count exceeded. Increase Max Locks Per File
registry entry".

I am aware of http://support.microsoft.com/?id=815281.

Under Method 2 it states in that article to load "Microsoft DAO 3.6 Object
Library".

When I attempt that, I get error message "Name conflicts with existing
module, project, or object library".

I use Access 2002 (SP3). Under VB Editor, Tools, References I find:
Microsoft Access 10.0 Object Library
Microsoft DAO 2.5/3.51 Compatibility Libary

So I don't have "Microsoft DAO 3.6 Object Library" loaded, and I don't seem
to be able to do that.

How can I implement "Method 2" properly? What's happening here?

Thanks very much for your help!

 

[Tom Wickerath]

Try removing the reference to the "Microsoft DAO 2.5/3.51 Compatibility
Libary". This library should only be needed for really old coding standards.
Such code should have been updated a long time ago. After removing this
reference, then set a reference to the Microsoft DAO 3.6 Object Library. It
should be available in the references listing. Sometimes, it is towards the
top of the list (not in alphabetical order). If you simply cannot find it
anywhere in the list, then search your hard drive for the file named
DAO360.dll. Once you know which folder it is in, use the Browse button in the
Tools | References dialog to browse to this file and select it.

Hopefully, any VBA code will compile without errors after selecting this
updated DAO library. After clicking on OK to dismiss the References dialog,
click on Debug > Compile ProjectName, where ProjectName is the name of your
VBA project. If your code compiles successfully, this option should appear
unavailable (greyed out) if you try to immediately repeat it, before making
any changes to a code module.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom van Stiphout]

On Sun, 2 Mar 2008 16:09:00 -0800, FSPH

The library:
Microsoft DAO 2.5/3.51 Compatibility Libary
is from a much older version of Access. Remove it and put 3.6 in its
place. Then open a code window and select Debug > Compile and fix what
needs fixing.

-Tom.

 

[Cassandra]

I tried the steps above to resolve my error but I received a Run-time '424'
error when I attempted Method 2, what can I do to resolve it?

Thanks,
Cassandra