saving data from previous versions

[CHRIS]

multi-user environment. database originally in office pro
97. upgraded one computer before others. new computer
had office pro xp. converted several times. files stored
on server. have now upgraded all to xp but server has 5
db files all with different information. how can i
combine into one file and get rid of old ones.

 

[Arvin Meyer]

Import all 5 sets of tables into a single database. A Union query will
combine all identical records. You can union all 5 sets of tables into
single table with a Make-Table query built upon a Union query. You will
still need to recreate relationships.

In the future, remember that Access XP can read and write data to an Access
97 database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access