ConvertAccessProject problem

[Guest]

Hello,

I have an Access FE/BE application where the FE is in Access 2003 and the BE
was developed in Access 97. The BE consists of tables which are linked to the
FE during startup.

I want to programmatically convert the BE to Access 2003 format, so I am
using the ConvertAccessProject method through the FE database.Everything
seems to be working fine, but when I close the FE I receive the "Microsoft
Access has encountered an error and needs to close..." message. When I
re-open the FE and close it again, I don't get this message.

Has anyone encountered this problem?

Thank you very much

 

[Marshall Barton]

I have an Access FE/BE application where the FE is in Access 2003 and the BE
was developed in Access 97. The BE consists of tables which are linked to the
FE during startup.

I want to programmatically convert the BE to Access 2003 format, so I am
using the ConvertAccessProject method through the FE database.Everything
seems to be working fine, but when I close the FE I receive the "Microsoft
Access has encountered an error and needs to close..." message. When I
re-open the FE and close it again, I don't get this message.

Just last month actually.

In my case, the key issue was that the front end caches a
lot of information about the back end's tables and their
fields. Tony Toews straightened me out about not using any
tables/queries until after closing, compacting the FE,
deleting all links and then reestablishing the links.

From my perspective, I strongly advise against embedding
Compact in an automated procedure without having it part of
a robust backup activity.

 

[Guest]

Thank you very much, Marshall.

Just last month actually.

In my case, the key issue was that the front end caches a
lot of information about the back end's tables and their
fields. Tony Toews straightened me out about not using any
tables/queries until after closing, compacting the FE,
deleting all links and then reestablishing the links.

From my perspective, I strongly advise against embedding
Compact in an automated procedure without having it part of
a robust backup activity.