Unable to create .mde from .mdb

[CBR1000f]

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

 

[Pat Hartman]

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

 

[CBR1000f]

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?

 

[DavidAtWork]

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

 

[CBR1000f]

Resolved. From what I understand I needed to compile the database prior to trying to make the mde. It was very easy to resolve once I knew what to do.

I followed help from this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=38174

boblarson and Pat Hartman to the rescue once again.