Can you convert (just tables in) a 2010 accdb back to 2003 mdb?

Posted on 2011-09-19
Last Modified: 2012-05-12
I don't see how/where to do this; is it possible?
Question by:mlagrange
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
  • 3
  • 2
  • +1
LVL 26

Expert Comment

ID: 36563087
If you have committed no evil, then you can create a new mdb file and export all your tables back to it.
Evil being attachment fields and multi-value fields--evils you shouldn't have used anyway
LVL 61

Accepted Solution

mbizup earned 500 total points
ID: 36563094
Assuming you don't have any Access 2010 specific features, just save the database in an earlier format:
LVL 75
ID: 36563102
You mean if the ACCDB has other objects also ?

I don't think so.  But, why not just import your tables in to a blank ACCDB,  then convert that back to A2003 ?

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 75
ID: 36563200
Just to clarify ... what I meant by "I don't think so." was that you can save just the tables separately.


Author Comment

ID: 36563258
Nay, my heart is pure, and I have committed no evil! Huzzah!  :-D

I just couldn't find the "Save As 2003". Silly me - I looked in the Database Tools where it used to freakin' be!  I should have known they'd put it somewhere you'd NEVER think to look, like "Save & Publish"!

I just love Access 2010! This pictures are so pretty, and the colors are so shiny!
LVL 26

Expert Comment

ID: 36563351
I can deal with Access 2010
The Ribbon is ...well...saner than in 2007 and BackStage is reasonable to work with.
Once you have a look at what's in BackStage, you do tend to remember it.
Where they stuffed Compact & Repair in A2007 was maddening.
I rolled back from A2007 and firmly resolved to never touch it again.
Every day, day to day stuff is still A2003 though.

Word to the wise: DON'T create forms or reports in A2010 and then try to edit them in A2003
They become corrupted very quickly.
If you have created them in 2010, you may as well copy-and-paste everything to new A2003 objects.
Because they die

Author Comment

ID: 36563471
I have just spent the last 2 hours working with an app that was converted from 97 to 2003, then to 2010, was reported to have been working, then all of a sudden, "nothing works"

I got into it, and saw that all the VBA was gone (form, report, module)

Somebody I work with here says one of her 2010 converted app's lost the code, but kept the Function & Sub declaration lines!
LVL 61

Expert Comment

ID: 36563804
We had a similar isolated occurrence some time ago (in Access 2007).  In our case, it happened when a developer lost patience with the time it was taking to digitally sign the code, and killed the database through Task Manager.  The code was completely lost.  Fortunately we had backups... and we learned to just wait out the signing process.
LVL 26

Expert Comment

ID: 36563903
I personally have a lot of paranoia going on.
Everything lives on drives with shadow copies enabled.
I have a Dev folder where I work on stuff
I have a Prod folder where a copy of the production stuff lives
I have a Deploy folder where the vbscript files that pull production frontends down to each machine where it lives after I rev them.
And then the front end lives on every machine.

Between all the Previous Copies on all the HDD's in the outfit, I got it covered.

And then there's server backups.
LVL 61

Expert Comment

ID: 36564108
Sounds a bit like our environment...

Development + testing + staging + production = plenty of backups when things go wrong
LVL 26

Expert Comment

ID: 36564155
I got sick of kicking out everybody when I wanted to push out changes, and while I saw Tony Toews' FE updater, I wanted to roll my own.
So I wrote two VBScripts.
One knocks forward a number in a file called ver.txt and copies the Dev version to the Deploy folder.
On the front end, another script has a look for
1) is there a file name *Backup.mdb?
    Yup, somebody crashed their front-end, let's deep-six it and clean up, and pull something new down from Deploy
2) is the ver.txt on the local unit got a smaller rev number than the one in Deploy?
    Yup, let's pull down the changes

Then it opens the app.  Or it just opens the same-version app when no changes have been pushed.

One double-click to deploy is a happy thing.
Not EVER having to clean up crashed front-ends is also VERY nice.
"You crashed it? No problem.  Just say yes to all the prompts, and then close and re-open it again"

A nice side effect is there are multiple good prodcution copies around.
LVL 26

Expert Comment

ID: 36564166
And yes <when things go wrong > is the right description.
Having heavily tweaked forms and reports go brittle is a fact of life.
Having a working file to import an object from--which then immediately gets rebuilt--is an absolute necessity

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
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.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

738 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