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 |
|
ziva55
Starting Member
4 Posts |
 Posted - 2006-06-07 : 08:13:58
|
| Hi I have a VB6 application with ADO Connection which has to retrieve data from SQL server and MSACCESS database.I tried to work with the MSACCESS file as a leader database and create link tables to SQL server, but the performance is too slow.There is a way to make a connection from the SQL server to the MSACCESS database.I have to be able to access the tables in MSACCESS as views because my retrievals are based on joining between tables from SQL and MSACCESS Any ideas?Thanks. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-07 : 08:43:37
|
| Look for OpenRowset, LinkedServers in sql server help fileMadhivananFailing to plan is Planning to fail |
 |
|
|
ziva55
Starting Member
4 Posts |
Posted - 2006-06-11 : 03:12:51
|
| Hi Thanks for your adviceGreat, its works |
|
|
|
|
|
|
How to show data stored in MSACCESS Tables as view