Solved

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

Posted on 2016-10-12
5
40 Views
Last Modified: 2016-11-02
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
0
Comment
Question by:Adam Matz
5 Comments
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 83 total points (awarded by participants)
Comment Utility
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.


Kelvin
0
 
LVL 34

Assisted Solution

by:PatHartman
PatHartman earned 83 total points (awarded by participants)
Comment Utility
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.
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 83 total points (awarded by participants)
Comment Utility
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.

Jim.
0
 
LVL 1

Accepted Solution

by:
Peter Cole earned 251 total points (awarded by participants)
Comment Utility
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!

Peter.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now