Unrecognized database format Access 2007 2013

Hi All,

I have an accdb front end, which for the past 4 weeks I develop using Access 2013 on Windows 8.1 Pro. Prior to that it was developed in Access 2007 on Windows8 on a previous machine.

This gets deployed to 2 servers.
Server 1 is running Access 2013 on Windows Web Server 2008 R2
Server 2 is running Access 2007 on Windows Server 2003 SP2

Something [else] has changed in the past ~2 weeks, meaning that when attempting to open recent releases of the accdb on Server 2, the message ‘Unrecognized database format [..filename]’ appears and the accdb does not open.
•      Have decompiled, compacted and repaired
•      Have tried as an accde
•      Same file is fine on dev machine and Server 1
•      No changed to references or dlls used recently
•      Some previous version accdbs which were created on the new dev machine in Access2013 can be opened OK, so not solely to do with that change

So has anyone got any suggestions as to where I need to look to fix this? Many thanks!
K.
katerina-pAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Katerina,

<<So has anyone got any suggestions as to where I need to look to fix this? Many thanks!>>

 As a start, anytime you mix Access versions, you always want to develop in the lowest common version, so all your develop should be done with A2007.

 Second, watch out of the 32 vs 64 bit editions of Office.  This is becoming more and more of a problem.

If possible, all users should be using the same edition.

Third, there are many things that might cause a problem, not just the development.

 Take the file from server 1, zip it, then place it on server two.  Now does it work?   And are you loading the front end from the server?   If so, you want to avoid this.  It should be on the stations.   Only thing that should be on the servers is a back end with data.

Jim.
1
katerina-pAuthor Commented:
Hi Jim,

Thanks for your response.

 
As a start, anytime you mix Access versions, you always want to develop in the lowest common version, so all your develop should be done with A2007.
Yep, no doubt! Far from ideal situation I know. Unfortunately don't have a copy of 2007 here anymore.

Take the file from server 1, zip it, then place it on server two.  Now does it work?   And are you loading the front end from the server?   If so, you want to avoid this.  It should be on the stations.   Only thing that should be on the servers is a back end with data.

The deployment as follows: accdb zipped on dev machine, a copy is ftped to each station, where it's opened/used. All data is in Access backends on server 2, and some in MySQL [on Server 3...].
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<The deployment as follows: accdb zipped on dev machine, a copy is ftped to each station, where it's opened/used. All data is in Access backends on server 2, and some in MySQL [on Server 3...]. >>

 and it's the backend that has the problem then?

Jim.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

katerina-pAuthor Commented:
Jim,

Apologies, apologies. Server 1 (Windows 2008 and Access 2013) has backends.

K.
0
katerina-pAuthor Commented:
The only problem is on Server 2, older Windows and older Access. Whilst posting this I'm installing RT Access 2010 on there to see what that does (tried RT 2013 but that seemingly cannot run on Windows 2008).
0
katerina-pAuthor Commented:
Can open the same file(s) as in OP on the older server using Runtime 2010. Not ideal though - hoping someone know exactly what causes the error in OP.

K.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
So running Access on Server 2 and older Windows work stations, opening front ends local to those stations with 2007, and you the problem?

If this all happened starting two weeks ago and is happening on multiple stations, then I think your only "fix" is to make sure you develop with A2007.

There are no choices there.  Going backwards has always been problematic.   Your never entirely sure when you'll use a feature in a later version that is unavailable in an earlier one.

Also, there's the problem with the internal structure of tables and the databases.   Never know when there will be an issue there.

 A2010 for example was trashing 2007 DB's until SP1 came out.   Using 2013 and going back to 2007 is risky because so much was stripped out from 2010 to 2013 (2010 was the last "full" version on the desktop side of things - A2013 had a number of items removed).

 And BTW, I am assuming your up to date on all service packs both for 2013 and 2007 installs.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
katerina-pAuthor Commented:
No real solution. Had to upgrade all round as advised.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

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.