Keep accdb useable in both 2007 and 2010 MS Access

Posted on 2014-01-24
Medium Priority
Last Modified: 2014-01-24
I need to develop a small database that includes an attachment datatype field which means I need to develop it as an accdb file. I want to work on it both at the office, where I use a 64 bit version of MS Access 2010 and at home where I use MS Access 2007.  Problem is that as soon as I do any modifications on it at work it will no longer work at home because it seems to make some modification to the file.

Is there any way I can keep an accdb file modified using 2010 from being upgraded so that I can keep using it on 2007? I don't knowingly use any features at work that aren't available on 2007.
Question by:Rob4077
  • 2
  • 2
LVL 59
ID: 39806465
You should be able to go back and forth as long as you use no A2010 specific features.  However that's not relly recommended becasue there have been numerious problmes with that.

With that said, there's also the issue of 32 bit vs 64 bit, which is a problem.

What problem/error message are you getting?


Author Comment

ID: 39806520
After I've made some changes on 2010 and transfer to 2007 the file won't open. I get a message saying something like it is not in a recognised format. When I use an mdb format it works find but I need the attachment format field, plus it would be good to use some of the other 2007 features but it's not workable.  I was hoping there may have been some switch/flag somewhere that would force 2010 to stick to 2007 format.

The only problem I've had with the 32 bit 64 bit was easily fixed by an EE helper on a recent question.
LVL 86

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 39806586
I ran into the same thing with a client project. While working onsite on their system with 2007 installed, all was well. When I moved their file to my laptop and used 2010, I found that it would not work when moving back to their environment.

My only fix was to install 2007 on my laptop and do my work there. I could find no setting or flag or registry entry that should have made an impact, so I assumed there was something changed in the .accdb structure itself.
LVL 59

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 total points
ID: 39806729
Not sure if it will help or not, but you might want to read through this:

Backward compatibility between Access 2010 and Access 2007

You might trip over something your doing.

It should work, but what you'll see from reading the article is that it's limited.  Generally it's considered a best practice never to go backwards (always develop in the lowest version).

Also note that you should be on A2007 SP2 to gain the most compatibility.


Author Comment

ID: 39808002
Thanks Jim. Had a look though the article but I am definitely not using any of the listed features and I am running SP3 so it should work but it's not. Looks like Scott had the same trouble and confirms there is no solution.

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

607 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