Automatic Database Copy (Data Migration)

[brkiran]

Hi Everybody,
I wanted to know some information about Database programming which is liek Migration of Data from one type of Database to other type of Database.
Is it possible for us to automatically insert a record into SQL-Server or Access Database whenever we insert a record nto the Access or SQL-Server database with same tables and vice versa.
Thanks in advance to somebody who solves my doubt or problem.

[kirankumar]

Create a DTS package that exports the new record in the sql server table to the access table and execute that package from a trigger on the sql server in the After Insert.

[brkiran]

Hello,
According to u we can transfer the data from SQL-Server to Access but what to do if we are transferring the record from Access to SQL-Server.