Is there an easy way to copy forms from a .mdb database and paste them into an .accdb?

I am redoing a lot of .mdb databases to be converted into .accdb's. Is there an easy way to convert these to access all the .accdb features? Or should I keep building them by scratch?

Thank you,

Adam MatzAsked:
Who is Participating?
Peter ColeConnect With a Mentor Commented:
Even though the answer is No I hope a bit of background might be helpful

To use themes you will need to use A2010 or later. The "themes" introduced in 2007 are not genuine themes. For A2010 onwards the theme is stored in the hidden table mSysResources. A2007 does not have mSysResources but if you open a 2007 database in A2010+ it will automatically add it. If you wish to open the DB back in 2007 then mSysResources needs to be deleted.

 As the theme is stored in the table you don't have to make a copy of it on other PC's where you install the database.  However if a user changes the theme they may not be able to revert to your original if a different version of Access is installed.

The differences between 2010, 2013 and 2016 relate to the number of themes supplied. In 2010 there were 39, A2013 has 8 , which are all different from 2010 and 2016 has 9 the same as 2013 and one extra.
The advice "don't edit system tables" definitely applies to mSysResources, if you edit it Access will "tidy" it when it exits!

Kelvin SparksConnect With a Mentor Commented:
Just import them.

Open the new accdb, and from the external data menu select import and point at the mdb. Then select the objects that you want to import.

PatHartmanConnect With a Mentor Commented:
Before attempting any conversion, make sure that the app compiles in the old Access version.  You are less likely to run into trouble converting if the app compiles cleanly.  Fix any errors before converting.

Many features are dependent on the version of Access that is running the app rather than the one that created it.  For example, the date picker.  In earlier versions of Access, there was no built in date picker so for a few versions, we used an activeX control.  However, support for that control has been dropped and you can no longer even have the control on your forms so you have to remove it.  Once you remove the activeX date picker, the form will open correctly and you will see the integrated Access date picker without doing anything even though the database is still an .mdb.  But, if you open the .mdb in an old version of Access, you won't see the date picker.  Similar things happen with the new search features.

Once you do convert from .mdb to .accdb, you can no longer open the .accdb with a pre-2007 version of Access.  One thing that doesn't get fixed up is the theme.  Themes are new with A2007 and they have been changed with every version since then.  Your converted .mdb's will NOT adopt a theme.  You would need to manually change a whole lot of stuff to make that happen.  As we speak, one of the Access MVP's is working on a tool that will "theme-ize" forms and reports so you don't have to do it manually.
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
I'm assuming this is in regards to your question on Theme's and the answer is no.

There is no cut and paste, and if you convert the DB, or import the forms, or even do a saveastext and loadfromtext (a backdoor method of getting objects into a DB), they will have the same properties as they did originally.

 With Access out of the box, the only way new features in A2007 and up in regards to themes gets applied is if you create something from scratch.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.