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
BOFH Now, BOFH Past, Information on duplicates
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
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
cu SwattyCode:If Question = Incomplete Then AnswerNextOne Else ReplyIfKnown End If
Thanks guys
Posting Permissions
Reply With Quote