TSQL to Remote access

Results 1 to 2 of 2

Thread: TSQL to Remote access

  1. #1
    Join Date
    Dec 1969

    Default TSQL to Remote access

    I&#039;m looking for a way to connect to a remote (ie, via IP) access database from TSQL. I know I probably want to be using sp_addlinkserver but can&#039;t figure out how...<BR><BR>any help?<BR><BR>Karl

  2. #2
    Join Date
    Dec 1969

    Default You can't do that...

    You can&#039;t link an Access database to SQL server like you can a SQL server to a SQL server...You&#039;re also not going to be able to connect via TSQL...(To the best of my knowledge)...<BR><BR>You could link the Access table to a table in SQL however...Why don&#039;t you just use ASP...???...<BR><BR>KLC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts