How do I convert from access 2002 to access 95

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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).
Click to expand...

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
 
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)
 
Back
Top