?
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
?
75 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 38

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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…
Suggested Courses
Course of the Month11 days, 3 hours left to enroll

770 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