Moving from Access97 to Access with MOffice2003

[Mark]

Hello All,
Work is thinking of moving to the Access version that comes with
Office 2003
We currently use Access97 and in it is a lot of Macros, the kind that
appears in the Database window also I don't know if there are macros
lurking elsewhere.
Among my concerns are:
Will the present macros work at all?
If conversion is needed is it simple, straightforward?
Any sort of backward/forward compatabilty?
Anything else that could happen?

I'm pretty nervous about this as the db is mission critical.

I hope my concerns turn out to be nothing.
Any kind of guidance would be greatly appreciated.

Thanks,
Mark

 

[Allen Browne]

Answers embedded.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Work is thinking of moving to the Access version that comes with
Office 2003
We currently use Access97 and in it is a lot of Macros, the kind that
appears in the Database window also I don't know if there are macros
lurking elsewhere.
Among my concerns are:
Will the present macros work at all?

Yes. Macros are virtually unchanged betwen A97 and A2003.

If conversion is needed is it simple, straightforward?

Usually very straightforward. Unless the A97 db originally started out in
Access 2 and so is using the compatibility layer reference, or you have
security or other odd things, give it a whirl. The conversion generates a
new file without damaging the old one.

Any sort of backward/forward compatabilty?

After conversion, Access 97 will not be able to use the Access 2003 mdb of
course.

Anything else that could happen?

See:
Converting from Access 97 to Access 2000 and later
at:
http://allenbrowne.com/ser-48.html
for a discussion of setup issues, conversion issues, usability issues, and
so on.