Click here to Skip to main content
15,895,656 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am working on a existing MS Access 2007 project that has a linked table link to Sql Server database.

When I mouse over to the linked table I can see a connection string
'ODBC;DRIVER=SQL Server;SERVER=10.0.0.1;UID=test;APP=Microsoft Office 2003;WSID=abc;TABLE=dbo.test'

This looks like a dsn-less linked table.

Question

Where the connect string locate at? How to change it (example database name)?
How can I create a similar dsn-less linked table? Anytime when I create a linked table Access 2007 always force me to choose\create a dsn (file or machine).

What I have tried:

1.Open the database that contains links to tables.
2.On the Tools menu, point to Database Utilities, and then click Linked Table Manager.
3.Select the Always prompt for new location check box.
4.Select the check box for the tables whose links you want to
change, and then click OK.
5.In the Select New Location of dialog box, specify the new location, click Open, and then click OK.
Posted
Comments

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900