I have a Access Database with a whole series of MS SQL Server links. If I try to retrieve any data from these linked tables I get a SQL server fail message...I'm not what connection string I should use to get access to data via the links..I believe the problem is due to the fact it can't make a connection, because it is looking for the SQL user and password....I can use a SQL connection string to bypass the Access database but I would prefer to hook in via the linked tables in access..any ideas
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connection to MS SQL Server
- Thread starter krill
- Start date
- Status
Similar threads
- Locked
- Question
