Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

office 2013 and 365

Posted on 2014-10-29
7
Medium Priority
?
182 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 85
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

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 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

972 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