Converting MS Access 2002 to 2.0

[Breunig]

I am currently using Access 2.0 (yes, I know it's old!).
I have a file in 2002 that I would like to be able to use
in 2.0. Is it possible to save the database in a way to
that I can use it in 2.0?

 

[Douglas J. Steele]

If all you want is the data, you should be able to create a blank database
in Access 2.0, and export your tables from your newer application to that
blank database.

If you want the forms, reports, etc., I don't believe there's any way.

 

[david epsom dot com dot au]

If you want the forms, reports, etc., I don't believe there's any way.

Using SaveAsText/LoadFromText. The conversion is not clean: you will
probably have to modify the text just to get it to load. After loading,
VBA will need a lot of work. Works OK for macros and queries though.

(david)

 

[david epsom dot com dot au]

Sorry, I was thinking of a different method -- and it doesn't
work the way I remembered either.

I was wrong. You cannot use LoadFromText in Access 2.0

(david)
http://www.hyphenologist.co.uk/killfile/killfilefaqhtm.htm

 

[Chris Mills]

This still seems to work, only for tables & queries though.
Set MyDB = MyWS.CreateDatabase(strDBName, dbLangGeneral, dbVersion20)
DoCmd.TransferDatabase acExport, "Microsoft Access", strDBName, acTable,
"Source", "Destination", False

(don't be confused by the Help mentioning other object types!)
Chris

 

[Chris Mills]

http://www.hyphenologist.co.uk/killfile/killfilefaqhtm.htm
I only just looked that up and got the joke! Or not a joke, whatever...much
appreciated.