[AccessD] Error creating ACCDE file

[Heenan, Lambert]

Nope. No custom ribbon. I found that the development ACCDB I was copying objects from would not compile to an ACCDE, but the changes I had made were minor, so I repeated the edits in the destination copy (which were not too extensive) and I was able to create the ACCDE file.

If you Google the topic you'll find it cropping up several years ago, long before Access 2007/2010 was released.

Lambert

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Wednesday, June 17, 2015 2:07 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error creating ACCDE file


 Did you possibly have a custom ribbon?  That's the only thing I can think of outside of the form itself that would be stored as a related record.

 Outside of that, A2010 had a number of bugs out of the gate, so the typical advice applies; make sure your patched to the latest rev.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Wednesday, June 17, 2015 12:58 PM
To: 'Access-D Email (accessd at databaseadvisors.com)'; 'ACCESS-L Email (ACCESS-L at PEACH.EASE.LSOFT.COM)'
Subject: [AccessD] Error creating ACCDE file

Cross Posted

Access 2010. I'm suddenly getting the error "You cannot add or change a record because a related record is required in table 'MSysAccessStorage'."
When I try to create an ACCEE file.

I have an ACCDB file which compiles to an ACCDE, but then when I import some modified forms from a development copy, replacing the originals, I then get the above error.

I have tried exporting the forms from the development version into the production file , no good.

Importing the forms from the production version into the development version. No good.

Used SaveAsText method and LoadFromText for the forms. No Good.

I wound up having the redo all of the form edits manually in a 'clean'
(compiles to ACCDE) file and then recompiling. That worked.

Does anyone have any idea what the cause of this misery might be?

Lambert




--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com