Thanks Peter.

I had try this solution and it works. I couldn't find any other way to connect to the database protected with password.

Thanks again,

Lavin

Allen, the query SELECT * FROM mylinkedserver.yourcatalogname..mytable doesn't work, fails with the same error. I look at Enterprise Manager and, when I select Tables under the linked server, the Catalog Column shows...

I first tried with Microsoft OLE DB Provider, but I could't find a way to authenticate correctly. Then I created a system DSN, specifying the password (without user name) and...

Thanks Peter. Did you ever try to create a linked server to an Access Database with password protection using Microsoft OLE DB Provider for ODBC Drivers and specifying an ODBC...

The problem is that my Access database is protected with just a password, without user. When I define the linked server, I can't leave the login in blank and when I...

Look at Mike Pearson's article "Changing Rogue Database Collations" posted to this forum in 05/26/2003

Sorry, but I don't know how to format the text in order to make my question clear, so I going to use _ to align the text correctly.

Table A

RecID______________Value

1__________________first_value

2__________________second_value

Table B

RecID______________Related_Value

1__________________str1

1__________________str2

2__________________str3

2__________________str4

2__________________str5

Both...