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 |
|
dzisaacs
Starting Member
2 Posts |
 Posted - 2006-03-24 : 10:59:19
|
| I know it's possible to link tables between Access and SQL Server using ODBC....however can u use DAO to do this? If there's a way i would appreciate some help. Thanks in advance. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-27 : 00:55:36
|
| Look for Linked servers, OpenRowset in sql server help fileMadhivananFailing to plan is Planning to fail |
 |
|
|
a_r_satish
Yak Posting Veteran
84 Posts |
Posted - 2006-03-28 : 00:25:03
|
| To use the Linked Server or Openrowset, the settings should be appropriate in your systema and also when using in n/w, u should have permission.Y i am saying this is coz, Few days back i too needed the same linked server,i found all the maximum possibilities and my system settings and the n/w settings was not compatible. So i couldn work on... jus check whether all the setings are correct.Regards,satish.r"Known is a drop, Unknown is an Ocean" |
|
|
|
|
|
|
Linking tables