Access

[tigge1r]

I have the older version of access (97) at home---and at
work we have the access 2000---my problem is I have a
program that I made at work on access 2000 and I brought
it home and tried it on access 97 and it will not open
My question is do you need to upgrade the 97 to work or
is there a way to open it in 97...
At this time I don't feel like buying the newer version--
and spending more money.

And on my labtop I have the windows XP but no Access to
open it(plus that will cost lots of money to get office
2003)just to use access..
Please help

 

[John Vinson]

I have the older version of access (97) at home---and at
work we have the access 2000---my problem is I have a
program that I made at work on access 2000 and I brought
it home and tried it on access 97 and it will not open
My question is do you need to upgrade the 97 to work or
is there a way to open it in 97...

No, but what you *can* do is open the database in 2000 at work, and
use Tools... Database Utilities... Convert... Convert to Previous
Version to save the database in A97 format. Of course if you've used
features which did not exist in A97 this won't work for those
features, and in practice it doesn't always work perfectly; but you
should be able to get something that you can at least use.

I would NOT recommend doing design changes on the structure of forms,
reports, etc. in this environment though.