Access XP to Access 97 Conversion Problems

[Luci]

Background Information: I developed a complex Access database system for
tracking construction projects around our city. Several external agencies are
required by city ordinance to enter their project information into this
database so we can coordinate work efforts in the right of way. There are
approximately 150 users of this system, two rather large agencies have not
upgraded from Office 97. I need to make this resource available to them as
soon as possible. The original design of this system took several months and
I cannot invest any more time into development for Access 97.
Steps Taken:
I used the built-in Data converter supplied by Access XP to convert the data
to Access 97. The automated process is not as clean as one would assume. The
Switchboard forms will not work, and need to be re-created. I re-compiled all
my VBA modules and they are now 97 compatible.

My big problem is that in the conversion process somehow a macro got added
to one of my forms and I cannot open it. Don't know where to look for the
problem macro call. I did not design any macro calls in my XP version. Any
suggestions.

A secondary problem is that I did use macros to assist with report queries
and none of them work either.

 

[John Nurick]

Background Information: I developed a complex Access database system for
tracking construction projects around our city. Several external agencies are
required by city ordinance to enter their project information into this
database so we can coordinate work efforts in the right of way. There are
approximately 150 users of this system, two rather large agencies have not
upgraded from Office 97. I need to make this resource available to them as
soon as possible. The original design of this system took several months and
I cannot invest any more time into development for Access 97.
Steps Taken:
I used the built-in Data converter supplied by Access XP to convert the data
to Access 97. The automated process is not as clean as one would assume. The
Switchboard forms will not work, and need to be re-created. I re-compiled all
my VBA modules and they are now 97 compatible.

There are area many of features of Access 2002 that didn't exist in
Access 97. Unless you took care to avoid all of those a clean conversion
simply isn't possible.

My big problem is that in the conversion process somehow a macro got added
to one of my forms and I cannot open it. Don't know where to look for the
problem macro call. I did not design any macro calls in my XP version. Any
suggestions.

Is it the macro or the form you can't open? If it's a macro it will
presumably be in the Macros page of the Database Window, and if you have
full design privileges and can't open I'd suspect the mdb file has
become corrupt.

If it's preventing the form from opening it is presumably called from
one of the form's events (such as Load, Open or Current) that run as the
form opens.

A secondary problem is that I did use macros to assist with report queries
and none of them work either.

I suggest you go back to the Access 2002 version of the database and
check through all these macros to ensure that they're not doing or using
anything (commands, properties, constants...) that doesn't exist in
Access 97.

 

[david epsom dot com dot au]

There is no macro -- that is a generic message which tells you
little more than you already knew, which is that there is some
problem when you are trying to open the form.

You need to first check for broken references (from the
references menu item in the VBA UI). Conversion from A2K2
back to A97 does not correct the references, so unless you
have done this already you may still have invalid A2K2 references.

If it is not a reference problem, then it is a corruption
problem: you should /decompile a copy of the 2K2 database
and try again, and if that fails, salvage the good forms,
and what you can of the damaged forms, into a new database.

(david)

 

[karolina]

Background Information: I developed a complex Access database system for
tracking construction projects around our city. Several external agencies are
required by city ordinance to enter their project information into this
database so we can coordinate work efforts in the right of way. There are
approximately 150 users of this system, two rather large agencies have not
upgraded from Office 97. I need to make this resource available to them as
soon as possible. The original design of this system took several months and
I cannot invest any more time into development for Access 97.
Steps Taken:
I used the built-in Data converter supplied by Access XP to convert the data
to Access 97. The automated process is not as clean as one would assume. The
Switchboard forms will not work, and need to be re-created. I re-compiled all
my VBA modules and they are now 97 compatible.

My big problem is that in the conversion process somehow a macro got added
to one of my forms and I cannot open it. Don't know where to look for the
problem macro call. I did not design any macro calls in my XP version. Any
suggestions.

A secondary problem is that I did use macros to assist with report queries
and none of them work either.