Access 365 Runtime: Click and Run offline Installer (1 Viewer)

[GPGeorge]

easily overcome by someone with a bit of access knowledge

There's an MDB floating around the internet that supports enabling/disabling the shift bypass in any other mdb on the computer. I believe it's also been updated for accdbs. You don't really even need to know how it works to use it.

 

[isladogs]

As previously stated, NEVER rely on the shift bypass alone

I think I know exactly the app George is referring to. It even has the gall to say something like 'for your Access peace of mind' or some such nonsense. The code used for MDBs will work in ACCDBs as well

Some time ago, I did post a suggestion to MS that developers should be able to block the shift bypass & prevent that being overwritten.
Whilst that could potentially lock developers out of their own database, I still feel it is an option that should be provided...with suitable warnings

 

[Pat Hartman]

I made the same recommendation to Bill personally back in the 90's when I ran into him at a bridge tournament. Access cannot be compiled because it is not just code but it should be able to be rendered as a permanent .accdr but with the ribbon and menu items useful to users still active. Of course my chat with Bill was way before the .accdr and the ribbon but he actually thought it was a good idea or maybe he just wanted to get rid of me The second time I spoke to him about it was in 2006 at a cocktail party at Redmond where I had been invited with a few other developers to preview A2007. He still thought it was a good idea.

MS could probably embed info to identify the computer that created the locked db. If you could provide that info, they could give you back the password. But you still have the same problem you have with .accde's. It is not easy to go back from a "compiled" state to source code. When they create the .accde or "locked" db, they could also make a copy of the source db and zip it and label it to KEEP SAFE. It's just a couple of lines of code to force the user to make a backup.

 

[mknight1219]

Hi Everyone.

Do you know where to get this offline installer?

I am distributing .accde file, but I am not sure if end-user has/dont have MSA, so I want them to install Access 365 runtime. Some of their PC dont have internet access.
So I wish I could send them offline installer file via USB thumdrive.

There were many good responses in this thread, but the original question does not seem to have been answered. As this is one of the first results that came up in a Google search when I was trying to address this specific issue for myself, I figured I should post what I have figured out that should allow you to have an offline installer for the Microsoft Access 365 Runtime.

Microsoft provides a tool called the Office Deployment Tool (ODT). You can download it here: (link not allowed)

Once you have downloaded it and extract it to a folder such as C:\ODT (if you use a different folder, change your references in my examples below accordingly. Also, I wanted to use the 32 bit version but change the 32 below to 64 if you want the 64 bit version).

Then create an file called accessruntime.xml in that folder with the following contents:
<Configuration>
<Add SourcePath="C:\ODT\AccessRuntime" OfficeClientEdition="32" Channel="Current">
<Product ID="AccessRuntimeRetail">
<Language ID="en-us" />
</Product>
</Add>
<Updates Enabled="FALSE"/>
<Display Level="None" AcceptEULA="TRUE" />
</Configuration>

Then bring up a command prompt and enter the following 2 commands:
cd C:\ODT
setup.exe /download accessruntime.xml

Finally, copy this ODT folder to wherever you need to run it. Bring up a administrative command prompt, and use cd to navigate to wherever you have the ODT folder located. Then run:
setup.exe /configure accessruntime.xml

Note: For the install, it is important that you run the command prompt as an administrator. If you run "setup.exe /configure accessruntime.xml" via a regular command prompt, it will give you a misleading error message ("We couldn't find the specified configuration file").

 

[Gasman]

For the benefit of those that might follow those instructions.

Download Office Deployment Tool from Official Microsoft Download Center

The Office Deployment Tool (ODT) is a command-line tool that you can use to download and deploy Click-to-Run versions of Office, such as Microsoft 365 Apps for enterprise, to your client computers.

www.microsoft.com

And Yes, I know it is a resurrected thread.

 

[DickyP]

its a NO.
either you have runtime or full version.
they will Overwrite each other.

Just not true - I have multiple versions running!

 

[isladogs]

The only restriction is that you cannot have both the runtime and full editions for the same version of Access

 

[arnelgp]

Just not true - I have multiple versions running!

the same as this is in NO Way True (post #5)

Unable to delete record due to record lock

I have a form that displays an image depending on the data input to two combo boxes. A small table is created with the image location info and multiple images can be scrolled through. This all works fine until the data is changed. Before adding new data to the table I am attempting to delete the...

www.access-programmers.co.uk