Link to a table

There is a way to create a link from a SQL Server database to a table located on a MSAccess database? I mean like creating links from MSAccess to other databases. The requested table is updated many times/day, and I dont want to import the table each time an update happens.

Thanks,

Richard

Sure. You can use linked servers, which is easy to configure in Enterprise Manager. You can take a look at this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp

|||Thanks!

Link Tables

Hi,
Still i m not getting the result. My question is can link the table in SQL like MSAccess has.(from other database we can use the table). Bcz i want a data from other database table and use the table data for other database.

Thanks
imtdid u mean to join the table or database....

Quote:

Originally Posted by imtmub

Hi,
Still i m not getting the result. My question is can link the table in SQL like MSAccess has.(from other database we can use the table). Bcz i want a data from other database table and use the table data for other database.

Thanks
imt

|||

Quote:

Originally Posted by reon

did u mean to join the table or database....

I want if the data change one table it need to sutomatically update second table. The both table are not in one database. They are diffrent database in sql server. In Access i can use link table to get data from another database table. In sql i don;t know how to use. If anybody knows how to do this option it will very helpfull.

Thanks