connect to Access 2.0 db and export all objects

C

Cliff

Hey all,

I've been handed an Access 2.0 database and asked to either upgrade or
rewrite using some other tool.

I can login and get the tables (+ data), but the logic, contained in
the macros; and the forms and reports (n=30) are closed off to me.

I've read some folks being able to upgrade to Access 97 first. Is that
a viable path?

I was hoping that if I could get the Macros, reverse engineer the logic
and then re-create the forms because I've read that Access 2.0 forms
wont'/don't upgrade. Hopefully the Access basic is easy enought to
pick apart.


Any advice or pointers would be greatly appreciated because my gut
feeling is that a total rewrite might be easier versus trying to
upgrade, re-compile, etc....

TIA,
Cliff
 
D

david

I've read some folks being able to upgrade to Access 97 first. Is
that a viable path?

Yes. Access 97,2000,2002. Or Access 2003 with the Access 2.0
import patch.
and then re-create the forms because I've read that Access 2.0 forms
wont'/don't upgrade. Hopefully the Access basic is easy enough to

Forms will upgrade to Access 97 - 2003.

There were one or two important VBA key words that the import
wizard, for whatever reason, didn't translate. You would need to
do a search-and-replace when you tried it the first time. This is not
a reason for a complete re-write. I only mention it so that you won't
be surprised.

Also, SendKeys, and some of the numeric menu identifiers would be
broken. Code that depends on SendKeys or the Access 2.0 menu
system would need to be re-written. Don't convert the macro's to
VBA until you have converted the database up to the final target
version.

There are several features of Access 2.0 that have quietly been dropped
For example, the use of pipes | in queries, which I think ? was for
backward compatibility with Access 1.0?

However, even if all the code, and all the queries and all the macros
are completely worthless (unlikely), it's still worth importing into
Access 97 or 2000 as a template, because it is trivial.

(david)
 

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