Solved

Access 2013

Posted on 2014-11-08
14
305 Views
Last Modified: 2014-11-17
Hi EE

I have an app developed in access 2003 and now converted into access 2013 running as .accde.
When I install on other PC's I initially get this message

This data is unreconized format
The Database may have been created with a later version of Microsoft Access then the one your are using. Upgrade your version of Microsoft Access to the current one, Than this Database

To get over this I recompile on the other PC's in .accde and it then works ok.

My PC has windows 8 64 bit and Office 2013 32bit Professional edition.
The problem PC's have windows 8 64bit and Office 365 32bit Professional edition

The only difference is 365.  My PC doesn't have 365 installed.

I never had this problem when using access 2010


Any help appreciated

chestera
0
Comment
Question by:chestera
  • 9
  • 4
14 Comments
 
LVL 12

Expert Comment

by:pdebaets
ID: 40430765
What version of Access do the problem computers have installed? Is it a 32 or 64-bit version of Access?
0
 

Author Comment

by:chestera
ID: 40430826
pdebaets

Both 32bit
Here is the Version info

My machine Info
Microsoft Access 2013(15.0.4569.1503) MSO (15.0.4569.1506) 32 bit
Part of Microsoft Office Professional Plus 2013

Product ID: 00216-53040-01457-AA643



Machine giving wrong format
Microsoft Access 2013 (15.0.4505.1000) MSO (15.0.4505.1005) 32 bit
Part of Microsoft Office 365 ProPlus

Product ID: 00202-50086-21955-AA838

Alan
0
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 40431124
Hi,
I suggest you use Access 2010 instead, as Access 2013 does not support many features on Access 2003/2007/2010.
0
 
LVL 12

Expert Comment

by:pdebaets
ID: 40431245
Try upgrading the problem computer(s) to v15.0.4569.1503 (same as your computer).
0
 

Author Comment

by:chestera
ID: 40431558
HuaMinChen

I have not option the company  is locked into Office365. Once I compile on their machins .accde it works with no problems

Alan
0
 

Author Comment

by:chestera
ID: 40431566
pdebaets

Office 365 is 2013 but is a pay as you go yearly or monthly. Once you subscribe you then down load to each PC so you would assume the current version.

Alan
0
 
LVL 12

Accepted Solution

by:
pdebaets earned 500 total points
ID: 40431676
I think the problem might be with Access 2013 which is not a part of the Office 365 subscription. Please try upgrading the version of Access 2013 on the problem computer to the same version that you created the .accde file with.

Edit: Well after further investigation Access may be a part of the office 365 subscription, but that doesn't mean that a particular installation is up-to-date.
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:chestera
ID: 40431784
pdebaets

Went on site this morning and reinstalled office 365 on a PC and stated it was the latest version.

Microsoft Access 2013 (15.0.4505.1000) MSO (15.0.4505.1005) 32 bit
Part of Microsoft Office 365 ProPlus

The person who did the install said out of 8 PC's three installed with no problems but Five came up with the  wrong format message
All PC's have windows 8 64bit and office 365 32 bit.

Bottom line is the program is running ok after sorting the wrong format problem

Alan
0
 
LVL 12

Expert Comment

by:pdebaets
ID: 40431822
0
 

Author Comment

by:chestera
ID: 40431969
pdebaets

I did put SP 1 on a couple of the PC's. I will see which one haven't got it and install. I had forgotten about SP1 many thanks for reminding me. I will get back to you and let uou know how I got on

Alan
0
 

Author Comment

by:chestera
ID: 40431976
pdebaets

I can't get to the site until Wednesday of this week so there will be a delay until get back to you. I will check the PC's with the error install SP1 if not installed then re-Install the program and see what happens.

Alan
0
 

Author Comment

by:chestera
ID: 40437016
pdebaets

When I install SP1 on one of the PC's giving wrong format error I get the following message
"There are no Products affected by this package installed on this system"
In the about I checked the MSO version
If SP1 is installed the MSO version number should be 15.0.4569.1506 or higher (according to web information)
On the PC I get 15.0.4505.1005. I am completely stuffed

Alan
0
 

Author Comment

by:chestera
ID: 40438476
pdebaets

"There are no Products affected by this package installed on this system"

I think the above message when installing SP1 is because it is already installed. If that is the case then I am back to square one.

Alan
0
 

Author Closing Comment

by:chestera
ID: 40448786
pdebaets

Many thanks for your information. Bottom line I am going to compile to accde with the company PC rather than my PC. Getting the same version on my PC is not an option.

Alan
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

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…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

746 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

10 Experts available now in Live!

Get 1:1 Help Now