Access 2000 and Access 97 compatability

[CindyG]

I have an access 97 runtime application and an access 2000 runtime
application which i need to run on the same machine. when i open the access
97 runtime application, access wants to convert the database to 2000. i have
no problem converting it, except that the access 97 runtime stores the data
in an external access 97 database which has over 30,000 records in it - do i
also have to convert the 97 database with the data or will access 2000 write
to the 97 database??
thank you

 

[Graham Mandeno]

Hi Cindy

A front-end database opened with a given version of Access will have no
problem linking to a back-end database created with a previous version.

However, provided there are no other Access 97 front-ends linking to your
back-end, I would suggest you convert the back-end database also as you will
get better record locking performance. Don't worry that the database has
30,000 records in it - it's possible to convert databases with millions of
records. There should be no conversion issues at all, because your back-end
database will contain no code.

 

[Guest]

Access 97 applications sometimes run very slowly when converted to
Access 2000.

While it would be good to try converting the runtime application
(and even the data files) to Access 2000, just so that you could
get A97 off of your PC and avoid confusion. always make sure
that you keep a backup copy of all files before doing any conversion.

Alternatively, to stop A2000 asking if you want to convert the
A97 runtime application, you can choose to 'enable' it. Enabling
an A97 application to run in A2000 adds some extra data to
the runtime application file (which makes the file bigger) and
then A2000 stops asking the question. You can't use A2000
to make design changes to an 'enabled' file - it is still an A97
file, but it runs in A2000.

Or, just create a shortcut to your runtime version of A97, and
use that shortcut to start the A97 file, instead of using double
click on the mdb:
"c:\...\msaccess.exe" "c:\ ...\myRun.mdb"

(david)

 

[CindyG]

how do i "enable" the a97 runtime application?
thanks for your help

 

[david epsom dot com dot au]

Cindy, let me be clear that I think "enabling" an A97
database is the least attractive of the three options:

Either convert the application to A2000, test it, and
get rid of A97, or Stay with A97, and use a shortcut
to start A97 or A2K as required.

But, to answer your question, normally when you double
click on an A97 mdb after using A2K, or when you open
an A97 mdb with A2K, you are given the option of converting
or enabling the A97 mdb. What options are you given?

What does the message say when you open the file?

(david)