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 |
|
doco
Yak Posting Veteran
77 Posts |
 Posted - 2011-05-09 : 12:26:10
|
Is it possible to make a connection to an Access DB from MS Sql Server Management Studio. I am guessing not, but you can't say no unless I ask  Education is what you have after you've forgotten everything you learned in school |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-05-09 : 12:55:18
|
| Yes, via a Linked Server.In SSMS, click VIEW, then Template Explorer. Expand the Linked Server node. Double click the Add Linked Server Access MDB template.That will get you started. |
 |
|
|
doco
Yak Posting Veteran
77 Posts |
Posted - 2011-05-09 : 14:12:51
|
| Thanks. Now to check if remote connection is allowed - still getting error. ARGH!Education is what you have after you've forgotten everything you learned in school |
|
|
|
|
|
|
SQL Server Mgmt Studio to Access mdb