Access 365 accde problems with Runtime

Question

First off, let me preface this by saying that everything runs fine on my Windows 7 laptop. But not on my daughter's Windows 8.1 machines at work nor mine.

I created the database on my Windows 7 machine. I'm running Access 365 (15.0.4659.1001) and created an accde. It's a 32-bit version, and I downloaded Runtime_86 (15.0.4569.1506). The accde opens to the point of displaying the security message. When I click the open button, Runtime simply quits and closes.

I created another database with only one table with 2 fields and one form. When made into an accde, this file gets past the security message, and Runtime opens to a blank page with just the File tab in the upper left.

Please help.

Linda

Answer 1

No need to uninstall. Rename the file as accdr. This will force Access to run the app as if it was just the Runtime license so you can test. 

Yes, I agree with your plan, that if the error trapping is not providing help, then you should install Office on the 8.1 machine and see if you can find where it is erroring out. 

Also, did you try error trapping in the On Error event of the form? If its crashing before executing any code, that might catch it. Finally, did you make sure you set Trusted Locations on the 8.1 machines?

Answer 2

Yes, I have error trapping beginning with the first bit of VB code on the splash screen. The program doesn't get far enough into it for the error trapping to work. The log file shows nothing.

I have Office 365 on my machine running Windows 7. I compiled the database on that machine and made it into an accde there. It runs great. I'm going to uninstall Office 365 on that machine and see how it does with Runtime. (And yes, I should have the latest version of Runtime, SP1, that I downloaded yesterday.)

I need this to work with Runtime because I will be distributing this to people who don't necessarily have the full version or who might be running an ancient version.

I'm thinking what I should try next, if it works with Runtime on the Windows 7 machine, is to install the full version of Access on the Windows 8.1 machine and compile the database there. I have some other critical things I have to do today, but I'll work on this tomorrow and let you know.

Thanks,

Linda

Answer 3

First, do the 8.1 machines have a full version of Access on them? Second, have you put in Error trapping in the apps. 

When using the Access runtime, you have to code everything you want done and provide error trapping for when it doesn't work. Also, if you have not made the folder where you are running the app from a Trusted Location, this could also cause problems. 

Did you set a default form for the app (either one)? Is there code in the On Open or On Load events of the default form? Is there error trapping in that code?

Answer 4

There was a thread on this a few months back, one that I had participated in.

The gist of it was that the full version was updated early-on, and the run-time version was not.

Try downloading a new version of the Runtime.

If I recall ... Microsoft has promised that this will not occur again as both versions will be released concurrently.

HTH,

Don

Answer 5

If you already have the full version of Access on your machine, there is no need for installing the runtime. Rather you would use a shortcut with the /runtime command line switch.

Does the app still work in full version? Does it compile (Code window > Debug > Compile)?

Does it have any broken references? Code window > Tools > References.