Solved

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

Posted on 2011-09-19
12
252 Views
Last Modified: 2012-05-12
I don't see how/where to do this; is it possible?
0
Comment
Question by:mlagrange
  • 5
  • 3
  • 2
  • +1
12 Comments
 
LVL 26

Expert Comment

by:Nick67
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
0
 
LVL 61

Accepted Solution

by:
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:
http://office.microsoft.com/en-us/access-help/save-an-access-2010-database-in-an-earlier-file-format-HA010341553.aspx#_Toc258329152
0
 
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 ?

mx
0
 
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.

mx
0
 

Author Comment

by:mlagrange
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!
0
 
LVL 26

Expert Comment

by:Nick67
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
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:mlagrange
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!
0
 
LVL 61

Expert Comment

by:mbizup
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.
0
 
LVL 26

Expert Comment

by:Nick67
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.
0
 
LVL 61

Expert Comment

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

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

Expert Comment

by:Nick67
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.
0
 
LVL 26

Expert Comment

by:Nick67
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
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 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

13 Experts available now in Live!

Get 1:1 Help Now