error when opening form 2K > 97

[Tezza]

I receive a msgbox with an error message when i try to open a form in a db
converted from 2k to 97. The msgbox has an icon of a doctor with
stethyscope. this is the text...

msaccess.exe has generated errors and will be closed by Windows.You will
need to restart the program. An error log is being created. [OK]

cannot open in design view either.

it's a long shot given the info suppied, but any ideas?

TIA
Terry

 

[Rick Brandt]

I receive a msgbox with an error message when i try to open a form in
a db converted from 2k to 97. The msgbox has an icon of a doctor with
stethyscope. this is the text...

msaccess.exe has generated errors and will be closed by Windows.You
will need to restart the program. An error log is being created. [OK]

cannot open in design view either.

it's a long shot given the info suppied, but any ideas?

The conversion process only converts the file format. It doesn't necessarily
produce a working appication in the older version. If the 2K file used any
functions or features that do not exist in A97 then those will need to be found
an rewritten.

Have you tried a "compile and save all" in the 97 file? This should locate any
code that needs fixing. You might also try Compacting the file. You often get
the "illegal operation" stuff when your file is corrupted.

 

[Tezza]

I receive a msgbox with an error message when i try to open a form in
a db converted from 2k to 97. The msgbox has an icon of a doctor with
stethyscope. this is the text...

msaccess.exe has generated errors and will be closed by Windows.You
will need to restart the program. An error log is being created. [OK]

cannot open in design view either.

it's a long shot given the info suppied, but any ideas?

The conversion process only converts the file format. It doesn't
necessarily produce a working appication in the older version. If the 2K
file used any functions or features that do not exist in A97 then those
will need to be found an rewritten.

Have you tried a "compile and save all" in the 97 file? This should
locate any code that needs fixing. You might also try Compacting the
file. You often get the "illegal operation" stuff when your file is
corrupted.

tried to compile but kept failing when it met recordset code generated by
the wizard when i created a 'find record' combo.

Set rs = Me.Recordset.Clone

the 2k version compiled ok on my xp machine (i have oxp but use o2k file
format). and the 'dodgy' form opens ok on my xp machine too (as 97 format).

I'll work my way through the form to see what changes i made last night.

Thanks for your speedy assistance.

Terry

 

[Rick Brandt]

tried to compile but kept failing when it met recordset code
generated by the wizard when i created a 'find record' combo.

Set rs = Me.Recordset.Clone

Has to be RecordSetClone in A97.

 

[Tezza]

Has to be RecordSetClone in A97.

interesting. this isn't converted. but it's never prevented the form from
opening before. I changed all occurrences, compiled and saved but the darn
thing still will not open. will dig a little deeper.

once again, thanks for your help

terry