Conversion from 2003 to 97

[Guest]

I have a multiple user environment in which 2003 and 97 front ends are
running off a 97 back end.

I have been designing forms, queries, etc. in 2003, and would like to update
the 97 front end, ideally without recreating everything in 97. I do not
think I'm using fancy stuff in 2003. When I converted the 2003 front end
back to 97, I'm finding that a number of my forms cause the whole program to
crash "This program has encountered a problem and needs to close."

Any ideas as to the culprit, or what I need to do to keep this from happening?

Thanks.

 

[Allen Browne]

Before trying the conversion from 2003 back to 97:

1. Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

2. Compact the database:
Tools | Database Utilities | Compact

3. Then decompile a copy of the database by entering something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Compact again.

5. From any code window, choose References on the Tools menu. Uncheck any
libraries you do not need. You may be able to get it down to just 3 -
Access, VBA, and DAO. More info on references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

You should now find that the conversion works fine.

If the database still crashes in A97, is there anything consistent about
what causes the crash, e.g. opening a particular form, or running a query
that has a subquery?

 

[Guest]

I have now (I think) done everything you asked me to. It did not fix the
problem.

What I have found is that I have just two forms which are causing problems.
I can't open them, open them in design form, delete them, or overwrite them
from outside without making the program crash. I will try deleting them from
the master database before I convert it, and then rewriting those forms from
within 97. Heaven only knows why those specific forms turned into poison.

Thanks for the help, even though it didn't work this time.