Link Access 2000 DB to SQL Server 2000 DB

  • Thread starter Thread starter Joe K.
  • Start date Start date
J

Joe K.

I inherited an Access 2000 database that needs to have tables imported into
a SQL Server 2000 new database. The Access database has approximately 30
tables. The Access database has approximately 10 forms, 10 reports, and 10
modules. I would like to import Access database tables into the new SQL
Server database. After the tables has been imported I will create the
relationship between the tables. Next I will create the indexes and link the
SQL Server tables to Access database.

I know Access 2000 upsizing will complete this procedure but it must have
SQL Server v7.0 or v6.X database.

Please let me know the correct procedure so my recordsets and reports will
work properly after I linked the tables to SQL Server?

Thanks so much for the wonderful help.
 
Hi,
if you run upsizing wizard and then link tables - then all your
forms/reports should work. But in order to get a better performance - you'll
need to optimize access application - use pass-through queries where
possible, etc.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Back
Top