Unable to create .mde from .mdb

CBR1000f

Registered User.
Local time
Tomorrow, 04:13
Joined
Oct 5, 2012
Messages
24
Good afternoon

When I click the Create MDE button I get the error message You cannot add or change a record because a related record is required in table 'MySysAccessStorage'.

I am a user who has been making some improvements to our database. I have been pretty successful with the help of this forum. Now that I want to test the improvements I need to create an mde, but can't.

The database was created in Access 2003 and I am now using Access 2007 on windows 2010. The original developer advised that we continue to use mde format - something to do with the runtime version everyone else who uses the database have.

Can anyone suggest what I need to do to convert my mdb to an mde?

With thanks

Greg
 
If you are using the runtime version, there is no reason to stick with an old version. Upgrade to A2010 for your users.

Sounds like corruption. Create a new empty database (preferably .accdb) and import all the objects from the original mdb. Add the necessary references and menus and set the start up properties. Compile the database and fix any compile errors. You should then be able to create an .accde
 
Thank you for your reply Pat. From your description it sounds like upgrading is beyond me. I don't have any programming experience - I'm only on this because I'm the most experienced user we have here.

Perhaps I can track down the source of the corruption and address it at the source. Is there a link to corruption problems that you can point me to please?
 
I think you need to take a look at the table MySysAccessStorage and how it works in the database. What happens if you run a Compact & Repair
David
 

Users who are viewing this thread

Back
Top Bottom