Where can I get info on updating an Access2000 database to SQLServer2000

Thanks in anticipation

http://www.google.com/search?hl=en&l...atabase+to+sql

Thanks for the very prompt reply.

Most Grateful

David Jenkins

Quote:

---

Originally Posted by jenkinsdjj

Where can I get info on updating an Access2000 database to SQLServer2000

Thanks in anticipation

---

There are two things to consider when doing this. You can upload your data to SQL Server using the same table and field names, then relink the tables to the SQL Server database. This is a simple process and you can use your Access app with no changes.

However this doesn't take full advantage of the capabilities of SQL Server. Also A2K doesn't have as many tools as later versions for dealing with SQL Server. Microsoft does provide a migration utilit and plenty of migration advice on their web site.

Thanks for the replies. I have now successfully updated the database.

You have been a great help.