Copy Access 97 tables to Blank Access 2002 DB 2

[Quintios]

I have a database in Access 97 format that I need to migrate to Access 2002. The original database is empty and is in a development stage; my company migrated their workstations to Office XP, so I decided to re-write the db. I want to keep the tables but ditch the front end, basically.

How does one copy all the tables and at the same time save the relationships from an Access 97 db to a blank/new Access 2002 db? If the data is copied over as well that's no big deal. But I very much want to save the relationships.

Thanks so much!

thx!

Q-

 

[JeremyNYC]

Q-

Make a copy of your database, so you're not risking your old data.

Then, you could just convert the database to XP. Your relationships will come with you. Then just build a front end database with links to that converted database.

Jeremy

PS: You are planning on having the front end separate from the back end, right? You definitely should do so. All it means is that one database holds the tables and just the tables (and that's where the relationships are built), and another database has links to all of those tables along with ALL of the other database objects (forms, reports, code, etc).

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[Quintios]

I've seen a lot of people recommend splitting a database, but why?

thx!

Q-

 

[JeremyNYC]

Quintos,

Do a search here and at groups.google.com in the group comp.databases.ms-access. There are many, many reasons to do this. The first is that it gives you more protection from corruption. The second is that it makes maintenance on your database much easier. But do a search, and you'll find all sorts of arguments. Just pay attention to who's arguing what sides (in terms of how much they seem to know about the topic).

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[Quintios]

Thanks for your help!

thx!

Q-