Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

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
?
82 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 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 39

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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

604 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