Access 2000 DB import tables in 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.
 

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

Link Access 2000 DB to SQL Server 2000 DB 1
Access 2000 Link to SQL Server db tables 1
Best way to deploy Access read-only database that is linked to SQL tables 6
linking to SQL Server db table 6
InfoPath 2013 crashes when trying to connect to Access 2016 DB 0
Table Security in Access 2013 1
SQL Server verses Sharepoint 12
Linked Tables and SQL Server permissions 3

Top