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

How can implement "Method 2" properly?

Thanks very much for your help!

 

[soto]

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

How can implement "Method 2" properly?

Thanks very much for your help!

 

[FSPH]

Hello Soto,

you left a message on the Microsoft Access General Questions Forum regarding
"File sharing lock count exceeded - Trouble with Method 2".

For some reason your message did not contain any content.

As I am eager to have your input, I was wondering if you wanted to look at
my question again.

Thank you.

http://www.microsoft.com/office/com...f68f&mid=e23f26b5-4843-47d0-ae3b-65b5d20d4e06