Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
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
Medium Priority
?
95 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
4 Comments
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 332 total points (awarded by participants)
ID: 41841085
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 40

Assisted Solution

by:PatHartman
PatHartman earned 332 total points (awarded by participants)
ID: 41841100
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 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 332 total points (awarded by participants)
ID: 41841764
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 1004 total points (awarded by participants)
ID: 41843502
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

580 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