Designing database in new version of Access and converting to previous version

R

RWatson

I have what might be a very strange situation.

I purchased a license for Microsoft Office XP for home use. At work, we are using Microsoft Access 2000. I inherited a database that has been locked down and was originally created in Access 97. Since the databases rollout over 4 years ago, we have gone through two administrators. We don't have the administrators password and the database continually crashes and we have lost functionality for most of the reports (due to different administrators trying to fix code)

At this point, I have been given the responsibility of Administrator and the permission to develop a new database from scratch. There are not any laptops available with Access 2000 installed

Would it be possible for me to develop the database using the version of Access included in Office XP and run/maintain it using Access 2000, without running into problems between the two versions?
 
D

Douglas J. Steele

Actually, the default file format for Access 2002 is the Access 2000 format,
so you shouldn't have any problem unless you explicitly convert it to Access
2002 format.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



RWatson said:
I have what might be a very strange situation.

I purchased a license for Microsoft Office XP for home use. At work, we
are using Microsoft Access 2000. I inherited a database that has been
locked down and was originally created in Access 97. Since the databases
rollout over 4 years ago, we have gone through two administrators. We don't
have the administrators password and the database continually crashes and we
have lost functionality for most of the reports (due to different
administrators trying to fix code).
At this point, I have been given the responsibility of Administrator and
the permission to develop a new database from scratch. There are not any
laptops available with Access 2000 installed.
Would it be possible for me to develop the database using the version of
Access included in Office XP and run/maintain it using Access 2000, without
running into problems between the two versions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top