Linking MS Access tables into SQL Server

[Smarty]

Hi,

On 1 machine, I have an Access databas. On another machine, I have an SQL Server. Is it possible to LINK the tables that exist in the Access database into a newly created database on the SQL Server? It is possible the other way around, and also importing the access database tables into a new SQL Server database is possible, but I want to link so that my Access database is still the master.

Can any1 help me with this problem?

 

[tran008]

Used import/export tool to transfer the MS-Access to Sql. Used DSN to link MS-Access to Sql.