Solved Making a “production” version (1 Viewer)

PaquettePaul

Member
Local time
Today, 17:56
Joined
Mar 28, 2022
Messages
107
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

Well-known member
Local time
Today, 17:56
Joined
Mar 28, 2020
Messages
1,030
Save as ACCDE in the later versions:

1654558783474.png
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 08:56
Joined
Jan 20, 2009
Messages
12,849
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

Super Moderator
Staff member
Local time
Today, 17:56
Joined
Feb 19, 2002
Messages
42,976
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

Member
Local time
Today, 17:56
Joined
Mar 28, 2022
Messages
107
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

Super Moderator
Staff member
Local time
Today, 17:56
Joined
Feb 19, 2002
Messages
42,976
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

Super Moderator
Staff member
Local time
Tomorrow, 08:56
Joined
Jan 20, 2009
Messages
12,849
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

Member
Local time
Today, 17:56
Joined
Mar 28, 2022
Messages
107
My brother is the only client and we can force him to get a 64 bit version. Lol
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 17:56
Joined
Feb 19, 2002
Messages
42,976
@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

MVP / VIP
Local time
Today, 21:56
Joined
Jan 14, 2017
Messages
18,186
@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)

1654813020466.png
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 17:56
Joined
Feb 19, 2002
Messages
42,976
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.
 

Users who are viewing this thread

Top Bottom