Re: Access XP >> 2000 >> 97

From: Billy Yao [MSFT] (v-binyao_at_online.microsoft.com)
Date: 03/04/04 

Date: Thu, 04 Mar 2004 13:57:05 GMT

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
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Relevant Pages

  • Re: Oracle RAC, and reboots
    ... crs. ... Any place to look to troubleshoot this? ... srvctl status database -d BMRAC ... Instance BMRAC1 is running on node lsbcmdbp01 ...
    (comp.databases.oracle.server)
  • Acc97->Acc2K->Acc97 compress filesize
    ... Acc2K database format and convert it back from Acc2K to ... Acc97 format the filesize is a lot smaller than before. ... databases you must compress them by converting them to ...
    (microsoft.public.access.conversion)
  • RUntime crashing
    ... function crash the database. ... Is there a way to return the line number that caused the fatal error so I ... can troubleshoot because going line by line would be horribly long because of ... out of my control reasons. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access ignores my request for a code break - why?
    ... to break the code at that point so you can troubleshoot what you're ... Been playing with the database properties, ... Use Access Special Keys from Tools | Startup? ...
    (comp.databases.ms-access)