Link Access 2000 DB to SQL Server 2000 DB

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.
 
A

Alex Dybenko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2000 Link to SQL Server db tables 1
pl sql code on access DB 1
Create Linked tables in access db without ODBC 18
SQL db Linking issues 4
linking to SQL Server db table 6
Coverting linked tables into local tables 2
Access 2003 db window 0
Convert Access DB to SQL 1

Top