Is it possible to link SQL server table in the same manner like Access linked tables? Can I link SQL server table to exsiting Access db (or any other DB)? If I cannot, what can I do instead of it?
Printable View
Is it possible to link SQL server table in the same manner like Access linked tables? Can I link SQL server table to exsiting Access db (or any other DB)? If I cannot, what can I do instead of it?
In theory yes you can if you use access as a go-between. It holds all the tables and you link through it to the Sql server.
The sql tables then act like tables in the access mdb.
Vince
Yes you can but in the box files of type you have to select ODBC Databases()
If no dsn is known you can create one from there.
For SQL-server you need to do it through a dsn
Thanks guys