Solved

office 2013 and 365

Posted on 2014-10-29
7
156 Views
Last Modified: 2014-11-08
Hi EE
I have a minor irritant. I am using office2013 for the first time. I create an mde then use Innosetup to install. All the PC’s have Windows 8 and office 365, Windows 64 bit and Office 32 bit.
 I have installed so far on three PC’s two successful  and one unsuccessful. The unsuccessful one gave me a message “You are using an older format etc”. To get it working I opened 2013 and recompiled into and mde on that pc and now it’s working ok.  I have a number of PC’s to install but would like to figure what happened   on the unsuccessful PC is it anything to do with 365.
When I look at the programs installed on each PC I can only see reference to 365 although when I do a search I can find Access 2013.

chestera
0
Comment
Question by:chestera
  • 5
  • 2
7 Comments
 
LVL 84
ID: 40412886
Could you post the entire message? Might help to track down the trouble.

If the target machines are all using Office 2013, then I'm curious why you are deploying a .mde file. While I understand there is some work involved in upgrading to the .accdb format, you'll find your path much easier if you maintain the same format as the target machine. In my experience, unless you move up to the .accdb format, you'll invariably run into this trouble from time to time.

As with all things like this, be sure the target machines are fully updated. In cases like this, where you're install with an Installer, you might show a dialog that instructs the user to be sure their Windows and Office installations are fully updated prior to running your install.
0
 

Author Comment

by:chestera
ID: 40414475
Scott McDaniel

I made an mde because the app was originally developed in access 2003 is it hard to convert to .accdb. All PC's were running Win 7 with access 2003 now they have updated to win 8 and 365.

Alan
0
 

Author Comment

by:chestera
ID: 40417592
Scott McDaniel

Hi Scott
Sorry for the delay I have been away. I have taken my Program developed in 2003 and imported into access 2013 and compiled into .accdb. It's working at the moment what problems could I face in the future leaving as is or do I need to do more modifications to my code

Alan
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:chestera
ID: 40418698
Scott Mcdaniel

Here is the error message i get on one of the PC's
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

I have office 2013 where the other PC's have 365. To get it working on the PC with the error message I openup office 2013 and recompile .accde then it works. The department have since installed onto more PC's and have to recompile .accde to get it working

I believe 365 and 2013 are one and the same

My PC has Win8 office2013 with SP 1. The other PC's have Win8 and Office SP1

System is 64 bit and Office is 32 Bit

Alan
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40419231
If the program seems to be working after conversion, then generally you won't have troubles with it. There were some known trouble areas - for example, some Openform and Openreport code broke - but if you haven't seen troubles, then most likely you won't see troubles.

As to your other issue - 365 is, essentially, Office 2013, but of course 365 can be run "in the cloud" or downloaded onto a desktop. With Access, I'm pretty sure you must download that (unless you're creating a Web App, which you're not), so it's fairly safe to assume that both you and the end users have the same version.

Can you open Access on one of the trouble machines and see exactly which version they're using? To do that, go to the File menu and click Account, then click the About Access button. You should see the full version in that text, towards the top of the information.
0
 

Author Comment

by:chestera
ID: 40420865
Scott McDaniel

Info requested

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
 

Author Closing Comment

by:chestera
ID: 40430592
Scott McDaniel

Thank you Scott. I have other questions on this subject so will post another question

Alan
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

920 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

16 Experts available now in Live!

Get 1:1 Help Now