Solved Making a “production” version

[PaquettePaul]

with MS Access 2007, I would split the database into data and the user interface (using and MDE file). With MS Access 2019, I see that the ability to split the database still exists but there does not appear to be an executable object (unless the database split creates one?).

what I am looking for is how do I release the application to a client without releasing the code.
thanks

 

[Mike Krailo]

Save as ACCDE in the later versions:

 

[Galaxiom]

I still use mde because accde does not support digital signatures.
I'm yet to see a facility only available in accde that is worth sacrificing that.
Packaging is unnecessary clutter in a domain environment.

 

[Pat Hartman]

The .mde and .accde formats are specific to the database version so you won't be able to create an .mde using 2007. Also, watch out for bit differences. If you have a 64 bit version of Access, it creates a 64 bit .accde which won't run on 32 bit installations of Access.

 

[PaquettePaul]

I have a 64 bit 2019 version. So, I guess I should be using ACCDE. Thanks guys.
Does anyone have a link to download the free runtime for 2019 64-bit access.

 

[Pat Hartman]

The 64-bit and 32-bit versions of office don't play well together. Are your users using the 64-bit version of Office? If they are not, I'm not sure you will be able to install the 64-bit version of the Runtime since Access shares DLL's with Office and they all need to be the same bit-ness.

I'm sorry I don't have a link but someone here may have a way to install the 64-bit runtime in a way that won't interfere with the 32-bit Office.

 

[Galaxiom]

The .mde and .accde formats are specific to the database version so you won't be able to create an .mde using 2007.

Incorrect. An mde can be created from an mdb. The mdb format continues to be supported by all version of Access.

The mdb does not support later features such as multivalued fields or TempVars but neither of them are important. The added security of the accdb if irrelevant when using SQL Server back ends with Windows Security.

 

[PaquettePaul]

My brother is the only client and we can force him to get a 64 bit version. Lol

 

[Pat Hartman]

@Galaxiom the image posted does not show .mde as an option. It does in my version so your remark seems to be true for some versions but not all.

 

[isladogs]

@Pat Hartman
If you open an MDB file in recent versions of Access such as 365, the Save As options include Make MDE (in place of Make ACCDE)

 

[Pat Hartman]

As I said, I wasn't on a computer so I was basing my assessment on what was posted. Apparently, the OP had opened an .accdb and so didn't get the .mde option. I guess I just can't trust anyone and need to look for myself.