Hi Mike,

I looked at the link and it is only for Access ver 2.0 Access 95 and 97. I have Access 2002. When I looked for the ini file msacc20.ini I could not find it. The help file sent me to look for the dll files in my registry and they are all in there. In regards to my connection string, am I using the wrong connection string? I don't know. I pasted my connection string in my initial post. Do you mind taking a look at it and see if it's wrong?

Thanks,
Judy

Hi Judy,

Your connection string looks OK, but I don't deal with them a whole lot, so I could be wrong. I have been playing with creating a linked table to my Oracle Database using ODBC, and have been successful on both 2000 and 2003. Would this be a viable option for you?

Mike

Mike
EchoVue.com

Hi Mike,

You were right about the connection string might be wrong which is why it was giving me that error message. I just went back to the help file again like you suggested. I used the link function, went to design view properties and looked for the connection string. It was totally different from what I was using originally. It worked afterwards. Thank you for your patience and help.

Cheers,
Judy

Hi Judy,

No problem at all. I am glad it worked out for you. I found a whole lot of extra features that I was not aware of before, so it looks like it was a win/win situation all around!

Mike

Mike
EchoVue.com