Access 2000 file now opens up as Access 97

[hlobrien]

No one at my companies help desk can help me with this, so I thought
I'd go to the experts =)

I have an Access 2000 file that I've been using Access 2003 to open. I
have a laptop and a desktop at my station. When I opened up the
database on my laptop it was fine. When I opened it up on my desktop,
it shows as a Access 97 file, and now all my make table queries are
gone. I called our Help Desk and after the knucklehead touched my
laptop, I can't open it up on either system in the Access 2000 file.
IS did a file restore and it's the same thing. Anyone have any idea
what happened, or how I can fix it? I didn't create this database,
someone else had, so I'm not sure how the make table queries were
created or else I'd redo it.

Thanks

 

[Luiz Cláudio C. V. Rocha]

AFAIK, opening your database with a different version (even if not
compatible) would not cause loss of queries. Maybe someone accidentally
deleted them, or the entire file was replaced by an older version.

If the database was in 2000 format, Access 97 would not open it. If it was
in 97 format, Access 2000 would ask to convert it or to open as read-only.

You have probably converted it to 2000 format, then you may have a copy of
the original file in your laptop. Use it to recover the make-table queries.

--
Luiz Cláudio C. V. Rocha
Coordenador de Projetos FórumAccess
São Paulo - Brasil
MVP Office
http://www.msmvps.com/officedev

 

[carissimi]

c'est pas très intéressant.


or how I can fix it? I didn't create this database,

 

[Aaron Kempf]

I'd reccomend not using Access97 for anything-- and in general; don't have
multiple versions of MS Access on the same machine

 

[Susie Johnson]

I'd reccomend not supporting Access 97 and never using more than one version
of Access on your machines