Migrating from Access 2000 to SQL Server 2000 - Establishing links to SQL 2000 Server database

(Page 5 of 6 )

In this step, using import data in MS Access, you can set up links to the MS SQL Server Migrate1 database using the same ODBC connection which is already established. In this way you will link back all the tables and some system tables that will come by default as shown. As we saw in an earlier tutorial, the tables will come with the prefix dbo_  added  to the table name. For example, the employees table on SQL Server will come over as dbo_employees.

Renaming Links

The SQL query previously established had table names without this appendage, and will not function correctly for these tables even though the same data is present. It will be necessary to rename the tables to their original name. For example, you will need to rename dbo_customers to customers. The MS Access database with the new linked objects will appear as shown, retaining all the other UI objects.

 

Next: Verifying functionality of existing objects >>
 

More Microsoft Access Articles
More By Jayaram Krishnaswamy

Comments On: Migrating from Access 2000 to SQL Server 2000

· Database growth is a natural consequence of the business growth, and to meet all the...    · It looks like you are still using Access as a front-end in this scenario. Why not...    · I am not suggesting the best practice which may be, even not use Access at all. This...    · I went throught the conversion exercise using Access2003 and SQLServerExpress2005...    · Microsoft always supports for a while till the next version is in the horizon,...    · Access Project is in Data Access Pages is out in Office 2007.What do you say...   >>> Post your comment now!