Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sven2
Yak Posting Veteran
57 Posts |
 Posted - 2010-04-05 : 03:11:38
|
| Hello,what do I have to do to connect MS access with a SQL server 2008 true the internet?So far, I have enabled the tcp/ip support.What do I have to do more ...Thanks in advnace,Sven. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-05 : 05:27:44
|
| you need to enable distributed queries and use OPENROWSET or add it as a linked server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sven2
Yak Posting Veteran
57 Posts |
Posted - 2010-04-05 : 08:40:42
|
| Hello,i think it is best to add it as a linked server.What is the best way to add a linked server?Thanks in advance,Sven. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Connection with a SQL server 2008