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.

 All Forums
 Other Forums
 MS Access
 Migration of splitted database to the sql server

Author  Topic 

Diya
Starting Member

11 Posts

Posted - 2009-07-25 : 13:19:54
I have an access database (Access 2003) which is splitted into back-end and front-end. I want to migrate the back-end database into sql server. For this sql server 2005 express edition has been installed. For doing i used the Sql server Migration Assistant for Access. But after migration of back-end database, fron-end database is no longer connected to the migrated back-end database. What should I do? Please help me. Early response is to be appreciated.
With regards,
Diya

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2009-07-26 : 20:13:45
You should just need to re-link the tables using the Linked table manager.

Go to Top of Page
   

- Advertisement -