ActiveX library

[hi there]

hi everyone,

i was trying to write some code with ADO and found out i needed to install the Microsoft ActiveX Data Objects 2.6 Library, but when i try to install it i get the following message:

"Name conflicts with existing module, project, or object library"

i read the help file associated with this error, but i'm still confused. can someone help me with this. also i'm not sure if this is related, but when i try to run ADO code i get a runtime error stating that the machine has been placed in a state by "Admins" that prevents it from being opened or locked. i read something about this happening if the dbase was opened exclusively but i didn't do this explicitly. does anyone know what i'm doing wrong?

many thanks to all for any suggestions.

 

[Nero]

Check you are not already using the 2.5 library.
If so untick the box and then tick the 2.6 library

 

[hi there]

hi nero,

thanks for the response. someone told me i needed to check the 2.5 library to use the ADODB object. that's why i have it checked. is that wrong? what are the proper reference libraries i need for ADO code?

many thanks again

 

[Nero]

Sorry I didn't get back to you sooner,
I would uncheck the 2.5 library before you install the 2.6 library.
I'm not sure that this is the cause of your problem but Access won't let you use both at the same time.