Access 2021 setup

[Pete490h]

Hi,

I’ve recently upgraded to Access 2021 on my laptop and require full access to the tables, forms, queries etc as I am both the designer and administrator plus Access 2021 runtime
Before I installed Access runtime, I had full access etc but since I’ve added runtime, I don’t seem to be able to see the tables etc

When I replicate on my works network, obviously users will have runtime but on the master PC, I need both options, as I design on there out of hours and have a user in work time
Any assistance/advice will be greatly appreciated thanks
Peter

 

[Gasman]

I believe you will need to create a dedicated shortcut to open the full version, or remove the file association with the runtime.

 

[GaP42]

Suggest you look at this item from one of our contributors:
https://www.isladogs.co.uk/office-dual-install/index.html

 

[theDBguy]

Hi Peter. You really don't need both the full version and the runtime version at the same time since the full version is capable of simulating the runtime version by using the /runtime switch or using the .ACCDR file extension.

 

[The_Doc_Man]

What Pat is talking about is called an "association" - essentially, that a file type is associated with a particular app. So for Access, you associate the file types .MDB and .ACCDB with "normal" Access applications, .MDB being the older format and .ACCDB the newer format.

In Windows 11, you can edit the associations via Start >> Settings >> Apps >> Default Apps (where you can explore and edit or remove the existing associations and assert new ones) and can, if needed remove or alter what goes where. I don't recall exactly how you do that on Win 10 but it is similar.

It is NOT considered a good idea to bulk-edit associations for the more common utilities and applications. But a spot-check or touch-up is possible.

 

[Pete490h]

Hi Peter. You really don't need both the full version and the runtime version at the same time since the full version is capable of simulating the runtime version by using the /runtime switch or using the .ACCDR file extension.

Just tried this and it works thanks
So when I need full access, I simply change the file back to the accdb extension, make any changes then back to accdr etc, right

 

[theDBguy]

Just tried this and it works thanks
So when I need full access, I simply change the file back to the accdb extension, make any changes then back to accdr etc, right

That's correct!

 

[Gasman]

Would be easier to have two shortcuts set up, I would have thought?

 

[The_Doc_Man]

Two shortcuts can be set up as long as you realize the file type is the unique field. Two different file types can point to the same app, but one file type cannot point to two different apps.

 

[Gasman]

Just thought it would be easier than renaming the file all the time?

 

[The_Doc_Man]

Just thought it would be easier than renaming the file all the time?

That's actually just a matter of degree rather than kind. Two or three shortcut icons? Not a biggie. But if you have to manage dozens of files, bigger problem.

 

[Mark_]

For your deployment, do you have all users accessing the same copy of the front end from a network server OR do you have a batch file that copies down the current version, then starts that?

If the former, you will run into issues when you need to update but can't as someone has helpfully left themselves in over the weekend. For the later, part of your copy down can be to include renaming the file from .accdb to .accdr when the batch file executes. Then you don't have to worry about file extensions, you just need to run your own batch file and you'll be using the runtime.