Access XP >> 2000 >> 97

[YmK]

I have on my machine Acc2003, AccXP, Acc2000 and Acc97. Each customer and
its needs...
I have written a small application in Acc2000 and it was also opened with
AccXP (Acc2000 File format) Then I realised my customer had only Acc97. I
did the conversion from AccXP AND from Acc2000 and every time I try to open
a form in Acc97 I get a crash message and Access closes.
Is there a way to convert it to prior Access version that works?

--
(¯`·.¸¸.·´¯`·.¸¸.->YmK<-.¸¸.·´¯`·.¸¸.·´¯)

Yaacov Klapisch
VB/Access Programmer - System Admin.
(e-mail address removed)

 

[Roger Carlson]

If you have ADO code in your 2000 app, it will not be converted backwards
into 97. That means you would either have to re-write it in DAO or set a
reference to ADO in Access 97. I don't know if ADO was included in Access97.
Since I have 97 and 2000 on my system, I have them in the references. You'd
have to find out if they have ADO on their system and if so, what version.
If it is pre-ADO 2.0, you still may have some coding issues.

 

[YmK]

Thanks for the reply.
I don't think it is an ADO problem. The bug is on my computer and I for sure
have the references.
Even if it was, I cannot get to the code window. I get the crash message
when I open the form or module.

 

[Billy Yao [MSFT]]

Hello Yaacov,

Thank you for posting in the community.

First of all, I'd like to confirm my understanding of your issue.

From your description, I understand that you have multiple versions of
Access on your machine. The application/project was written in Acc2000
and opened with AccXP. After that, you converted it from AccXP to Acc2000,
and finally to Acc97 for your customers' benefits as they have only Acc97.

Have I understood the issue correctly and completely? If there is anything I
misunderstood, please feel free to let me know.


I agree with Roger that you might meet with the code issue as the default
interface for new database created in Access 2000 is ActiveX Data Objects
(ADO) but the previous version used Data Access Object (DAO). For the
first time Access allows you to convert to Acc97 from Acc2000.

However, only modules that were written in Data Access Object (DAO) can
be converted to an earlier version with no problem. We cannot guarantee
the code written in ADO will work flawlessly if it is converted from Acc2000 to
Acc97 even though the ADO library is referenced.

If you have made sure that this was not the ADO problem, could you help
create a new Acc97 database, import the objects into that new database,
and reference the needed library to see if the form can be normally
opened.

On the other hand, please specify the crash message so that we can
isolate the issue more easily and quickly. If there is any update or further
information you can provide, please feel free to post them in the
newsgroup. Thanks in advance!

Best regards,

Billy Yao
Microsoft Online Support

 

[YmK]

Thanks for your care.
It is almost as you described it.
I didn't "Convert" it to AccXP but only opened it with AccXP as a Acc2000
file format.
This is the message I get:
Microsoft Access has encountered a problem and needs to close. We are sorry
for the inconvenience.

The Error signature is:
AppName: msaccess.exe AppVer: 8.0.0.4008 ModName: msaccess.exe

ModVer: 8.0.0.4008 Offset: 001a24a2

Do you want me to send you the dump file?
There is no ADO code in these forms only the "MoveNext" code of standard
buttons created with the wizard.
Maybe it is the TabControl I have on the form that makes the problem?


--
(¯`·.¸¸.·´¯`·.¸¸.->YmK<-.¸¸.·´¯`·.¸¸.·´¯)

Yaacov Klapisch
VB/Access Programmer - System Admin.
(e-mail address removed)

 

[Billy Yao [MSFT]]

Hi Yaacov,

Thanks for your update and further information!

The error signature seems to be no help on troubleshooting the issue.
However, you confirmed you didn't convert the VBA project (or the whole
database) to AccXP, instead you only opened it as the Acc2000 format.

Based on your clarification, I assumed that you convert the Acc2000
database to Acc97 using AccXP, am I right? If that, I suspect that the VBA
project was corrupt after you used AccXP to convert it to Acc97 version
from Acc2000 file format.

I'm not sure if you have tried to import the form and its underlying data
sources to a new created database, and what's result? If you haven't, we
recommend you do this import operation to see if the form can be opened.

For more methods to troubleshoot the database corruption issue, please
read the following articles:

279334 ACC97: How to Repair a Damaged Jet 3.5 Database
http://support.microsoft.com/?id=279334

209137 ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0
Database
http://support.microsoft.com/?id=209137


Please apply my suggestions above and let me know if this helps resolve
your problem. Thanks for your patience and cooperation!


Best regards,

Billy Yao
Microsoft Online Support