I want to export my existing sql server 2000 database to a new ACCESS
2000 database. I don't want to export any data, but just all the table
structures, and constraints and relationships between tables.

Right now I use the export wizard to export all tables. But I get a copy
of ACCESS with no primary keys and foreign keys.

How do I preserve the relationship between tables during the export?

Hello q_test,


Going from SQL Server to Access you can't, well not very easily anyway.
You will have to write something that queries the constraints etc on SQL
Server and then applies that logic in the style of Access to the Access DB.
This will involve coding yourself as there is nothing in the box that will
do this

Allan

[quoted text, click to view]