Open database without MS Access

[kitty77]

Any way to create a database that can be opened or used without having MS Access?

 

[theDBguy]

Any database? Or are you specifically asking about Access. You can create your own application using C#.Net, for example, to use an Access database without having Access installed. You could also use the Runtime version, which is not a full version of Access.

 

[kitty77]

Yes, specifically Access. How do I create a runtime version? What do I need?

 

[kitty77]

I get an error when I same as...

 

[theDBguy]

Yes, specifically Access. How do I create a runtime version? What do I need?

You would download it from Microsoft. However, I just realized you said "create" an Access database. Unfortunately, you won't be able to create an Access database using the Runtime version.

To create an Access database without Access, you'll need another programming application, and it won't be easy.

 

[theDBguy]

I get an error when I same as...

View attachment 95844

In the VBE window, go to Tools > Debug > Compile

Fix any errors that come up.

 

[kitty77]

No, I have Access and have created the database using Access but when I try and save it for a runtime file, I get an error?

 

[theDBguy]

No, I have Access and have created the database using Access but when I try and save it for a runtime file, I get an error?

Right. You'll have to fix those errors before you can create a compiled version.

 

[kitty77]

I'm using MS Access 2019, what runtime should I install?

 

[theDBguy]

I'm using MS Access 2019, what runtime should I install?

2019. However, you don't need to install it, if you already have Access. Only your users without Access need it.

 

[kitty77]

So, how can I view the runtime version? Only users without Access can view it?

 

[kitty77]

So, my users have to download the runtime, install it and use the compiled database?

 

[theDBguy]

So, how can I view the runtime version? Only users without Access can view it?

Once you create a ACCDE, you can still use your full version of Access to view it. Only people without Access need the Runtime.

 

[theDBguy]

So, my users have to download the runtime, install it and use the compiled database?

Yes, but only if they don't already have Access on their machines.

 

[arnelgp]

i don't think you can create an A2019 Runtime.
you only install the runtime on the computer without msa not on your computer.
there is no A2019 runtime only A2016.

 

[kitty77]

I see... That's a lot to ask your customer or someone without Access to do.

 

[isladogs]

You can simulate a runtime version by renaming the file with an .ACCDR suffix
OR by opening the file with the /runtime switch.

There is an Access 365 runtime which will work with files created in 2019
Download and install Microsoft 365 Access Runtime

 

[arnelgp]

There is an Access 365 runtime which will work with files created in 2019

have you tried? as i know it will Replace your mso.

 

[CJ_London]

That's a lot to ask your customer or someone without Access to do.

Other alternatives are to

1. go to your client or connect remotely and do it for them.
2. create your db on the web - then they can user a browser. But you would have to start from scratch since access is not a web based product.
3. Or use something like citrix or terminal server (where you can use your access app and provide access runtime for them) and users then connect via remote desktop. Benefit of this is users can be using any device that supports remote desktop (typically windows/apple/linux). Also comes at a cost.

 

[theDBguy]

I see... That's a lot to ask your customer or someone without Access to do.

It's the same situation with any other application, unless it's a Standard one.

What exactly is your situation? What does your database do and who are your customers?