Re: Convert a2000 back to a97
From: '69 Camaro (Black_hole.To.69Camaro_at_Spameater.org)
Date: 08/12/04
- Next message: '69 Camaro: "Re: File conversion downward"
- Previous message: John Nurick: "Re: Convert a2000 back to a97"
- In reply to: Frank: "Convert a2000 back to a97"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 11 Aug 2004 23:03:05 -0700
Hi, Frank.
Your computer is missing some of the DLL's or TLB's that come with Access
97, which is understandable. Most likely, your computer is missing
DAO350.DLL, which isn't required for Access 2K, since it uses the next
version, DAO360.DLL.
The proper way to fix the References is to open the application in Access
97, find the "MISSING" References in the References dialog window, delete
them, then add the correct References by browsing for the appropriate
library files, then compile the code.
It's possible that you may find someone who has Access 2000 on their
computer, but with some of the old Access 97 Reference libraries left over
from an old installation. If this is the case, then make a copy of your
Access 2000 version of the application for him to convert to Access 97 for
you. And remember, upgrading from one version to the next can be relatively
easy, but downgrading from one version to another has no guarantees that the
conversion will work properly in the earlier version of Access.
Thinking about other alternatives, you probably can't use your Access 2000
version with the "off the shelf" application, since the application probably
has the database connection hard-coded to use data access methods specific
to Access 97. Those simple loads and conversions you mentioned -- could
that data be imported into the original Access 97 database to replace the
data in the original tables? (You MUST make a backup first.) You can link
an Access 2000 database to tables in an Access 97 database to do this.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
"Frank" <anonymous@discussions.microsoft.com> wrote in message
news:4a3201c48010$80ca2520$a601280a@phx.gbl...
> Hello
>
> As a favor for a friend ( I should not volunteer as I
> do ! )
> I am working on a backend db written in Access 97 and used
> by an off the shelf application. I only have access 2000.
> I converted it to access 2000 (got a message that said I
> had to or could not change the db) did some simple loads
> and conversions and need to save it as an access 97 db so
> that the app can use it. When I try the tools , db utils,
> convert db to prior access version I get a message.
> Your computer is missing at least one of the ms access 97
> object libraries. YOur converted database will not work
> with access 97 until you open this database using access
> 97 and then fix the missing references.
>
> What will I have to "fix".
> Should I attempt this some other way?
>
> Thank you so much for your help
> Regards
> Frank
- Next message: '69 Camaro: "Re: File conversion downward"
- Previous message: John Nurick: "Re: Convert a2000 back to a97"
- In reply to: Frank: "Convert a2000 back to a97"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
