UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Unrecognized Database Format 2013 To 2010 (2007), Any Version    
 
   
PaulFG
post Nov 14 2017, 11:59 AM
Post#1



Posts: 14
Joined: 4-January 16



Hello All,

Any advice and opinions much appreciated

I have a customer with an old database. He is running Access 2007.

I have been making changes using Access 2013 to modernise the screens and make the application navigation intuitive and easier to use.

For the last few months all has been going well. I change the front-end and all works fine. The last release I sent was November 6 2017.

I sent an update today (14 November) and the user is getting a dialog box "Unrecognised database format C:\Filepath\Filename.accdb" when they try and open the frontend.

The updates in the latest release are not complicated - mainly VBA and queries. The structure of the backend data database has not changed in the past week.

I have tried Compact and Repair - no luck.

The user has emailed the working November 6 frontend database to me and I can open it (in Access 2013) send it back to him and he can still open it in Access 2007.

This suggests to me I have changed "something" in the last week. Does anyone have any suggestions about the main things I should be looking out for?

I have a workaround which is to install Access 2013 runtime but I'm reluctant to take this option in case I cause any problems with other operational databases. As I am sure will be familiar to many of you, the databases are critical to the business but the powers that be are reluctant to upgrade to a more recent release of Office/Access.

Thanks for reading, all feedback welcome.

Paul
Go to the top of the page
 
Jeff B.
post Nov 14 2017, 12:36 PM
Post#2


UtterAccess VIP
Posts: 9,881
Joined: 30-April 10
From: Pacific NorthWet


<Paul>

Have you already tried "saving as" an earlier version?

--------------------
Regards

Jeff Boyce
Microsoft Access MVP (2002-2015)

Mention of hardware or software is, in no way, an endorsement thereof. The FTC of the USA made this disclaimer necessary/possible.
Go to the top of the page
 
JonSmith
post Nov 14 2017, 01:22 PM
Post#3



Posts: 3,158
Joined: 19-October 10



Backwards compatibility is a big lie. I found out with 2007 and 2010, the new layout options in 2010 causes it to be read as 'corrupted' in 2007, whats worse once you added the new options to a form in 2010 (it was empty cells causing the issue) they could not be removed, even if you deleted every object on the form the markers remained and stopped it loading. I was only able to diagnose and fix by exporting to a text file and reading line by line, deleting the extra info and re-importing.

There will be something like this in 2013, you added it somehow even if it seems like you haven't, its unlikely to be VBA and queries, I suggest exporting all the objects as text in the working and non working versions and then using a compare tool looking for differences. Hopefully you'll spot something.

Basically you need to dev in the version to be used. You should tell your user to upgrade, 2007 is out of support. Get runtime for free.
Go to the top of the page
 
DanielPineault
post Nov 14 2017, 01:26 PM
Post#4


UtterAccess VIP
Posts: 5,450
Joined: 30-June 11



You simply can't expect Access to be forwards compatible, ie expect 2007 to understand 2010+. Development is always to be done using the oldest version that will ever be used to run the database. So if they are using 2007, even though others have 2013, 2016, ... they MUST do all development in 2007. Your other option as you are aware is to install a later runtime version to ensure everyone is running the exact same version.

There is an issue with the latest update, but for 2016 (I don't think it impacted 2013, but I could be wrong).


@JonSmith - What you are describing is forwards compatibility, not backwards compatibility, and no software can see into the future and promise forwards compatibility, nor does Access make any such assertions. Now, for the inverse, backwards compatibility, say Access 2013 opening an Access 2007 database, that Access does remarkably well!

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
GroverParkGeorge
post Nov 14 2017, 02:22 PM
Post#5


UA Admin
Posts: 31,197
Joined: 20-June 02
From: Newcastle, WA


One more voice here.

I have found that, even if forms render in a different version (2010 vs 2007), there can be subtle differences in fonts and background colors in the two. It's a pain, but one should be disciplined enough to start the right version every time before even touching the accdb.

--------------------
Go to the top of the page
 
PaulFG
post Nov 15 2017, 02:37 AM
Post#6



Posts: 14
Joined: 4-January 16



Many thanks for all of your replies.

I had the feeling I was pushing my luck using 2013 where the user had 2007. I "got away with it" for a long time, right up to the point when I didn't. I'm not going to go through the decompile and compare process as the database has so many objects.

So here's the plan...

One of the PCs on their network has runtime version of 2013. I'm going to see if my database runs as expected on that PC. It should do but we'll see.

If all is OK then Ill arrange for the user to get an upgrade to Access 2013/2016. The runtime won't be suitable for this particular user which is a shame, so I'll need to revisit what the upgrade options are which I posted about some time last year. I'll also need to check all the legacy databases run properly on an up to date version of Access.

Thanks again for your help,

Paul
Go to the top of the page
 
JonSmith
post Nov 15 2017, 03:29 AM
Post#7



Posts: 3,158
Joined: 19-October 10



QUOTE
@JonSmith - What you are describing is forwards compatibility, not backwards compatibility, and no software can see into the future and promise forwards compatibility, nor does Access make any such assertions. Now, for the inverse, backwards compatibility, say Access 2013 opening an Access 2007 database, that Access does remarkably well!


Fair point, I was referring to forwards compatibility then and got my directions mixed up and you are quite right, going 'backwards' MS Office does a good job.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    12th December 2017 - 04:34 PM