How do I convert from access 2002 to access 95

[Guest]

NCR's Queryman Application stores history in Access 95 format. I merged 2
people's history databases, but had to do it in Access 2002. I can convert
back to Acess 97, but Queryman won't function properly. Is there anyway to
get all the way back to Access 95?

 

[John Vinson]

Is there anyway to
get all the way back to Access 95?

Only by exporting the data to an external file (dBase or comma
separated text) and reimporting, as far as I know.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Tony D'Ambra]

As I no longer have Access95 installed, I have not tested this, but you
could use the un-documented SaveAsText and LoadFromText methods of the
Application object, which was introduced in Access95, to export all objects
to text files in Access 2002 and then to import all the objects into
Access95 and rebuild the database (excluding DAPs of course).

While these methods are undocumented, all the syntax and constants reverence
is available from Intellisense once you enter:

Application.SaveAsText or Application.LoadFromText

Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net

 

[John Vinson]

As I no longer have Access95 installed, I have not tested this, but you
could use the un-documented SaveAsText and LoadFromText methods of the
Application object, which was introduced in Access95, to export all objects
to text files in Access 2002 and then to import all the objects into
Access95 and rebuild the database (excluding DAPs of course).

Hrm. Hadn't thought of that trick! The only drawbacks might be that
there may be features in 2002 which do not exist in 95, and (I
believe) the text files contain version information. I was moving
forms from 2000 to 2002 using this technique and they weren't
importing until I converted the target database to 2000 format.

Certainly worth a try for database objects; for Tables I'd still
export them to text or dBase.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[david epsom dot com dot au]

Open A2002. Open the Merged Database. LINK (File,Get External Data, Link)
to all the tables in a valid A95 Queryman database. Copy and paste
the data from your tables into the linked tables, or use queries to
append the data from your tables into the linked tables.

(david)