Search code examples
ms-accesslinked-tablessql-server-2008r2-express

Linked tables in SQL server 2008 express

I am migrating an ACCESS 2000 to SQL express 2008 and am having trouble with the linked tables. Is there a way to replicate the ACCESS linked tables to SQL?

Thank you

Solution

  • You can use the upsizing wizard or the Microsoft SQL Server Migration Assistant 2008 for Access. Once you have the tables on your SQL server you can then link them using either the normal table linking method or through code if you want to be fancy

    EDIT:

    If they are on the same physical box then one way is to make views of the table using the full 3 name. In the below example I’m creating a view in the database Tracker_3 that is looking at the table tblStaff_details in the database Skyline_common

    USE [Tracker_3] GO

    create view [dbo].[tblStaff_details] as select * from Skyline_common.dbo.[tblStaff_details]

    GO