Member Avatar for wkalo

Hi There

Is There A Way To Make Access File As Exe File

Thanks In Advance

  • 7 Contributors
  • 6 Replies
  • 1K Views
  • 4 Years Discussion Span
  • Latest Post Latest Post by ali asif

Dani AI

Generated

Short answer: you cannot turn an Access .mdb/.accdb into a true standalone Windows .exe. Compiled Access formats (old .mde, newer .accde) only lock design/VBA — they still run inside the Access engine (full Access or the free Access Runtime). If an object list is still visible after you made a compiled file, that usually means the file was opened with the full Access developer product (which exposes the Navigation Pane and special keys) rather than being run under runtime/startup options. (support.microsoft.com)

Practical, safely-testable steps (build on what and began and address ’s observation):

  • Make an ACCDE from the final front-end (Access 2007+ uses ACCDE). This prevents editing of compiled VBA but does not create an .exe. (support.microsoft.com)
  • Disable the SHIFT-bypass so users cannot open the DB in design mode (run this once in the full Access developer copy before you produce the ACCDE):
Public Sub DisableShiftKey()
  Dim db As DAO.Database
  Dim prp As DAO.Property
  Set db = CurrentDb
  On Error Resume Next
  db.Properties("AllowBypassKey") = False
  If Err.Number <> 0 Then
    Err.Clear
    Set prp = db.CreateProperty("AllowBypassKey", dbBoolean, False)
    db.Properties.Append prp
  End If
  Set prp = Nothing
  Set db = Nothing
End Sub

The AllowBypassKey behavior and startup/runtime differences are documented by Microsoft (runtime hides the Navigation Pane and special keys). Test your ACCDE on client machines with the Access Runtime to see intended behavior. (learn.microsoft.com)

If a true native .exe is mandatory, a rewrite (or port) into a compiled language or a proper application framework is the realistic route — wrapping/packaging tools are risky and usually still require the Access engine. Also plan for compatibility: compiled Access front-ends can be sensitive to Access version and 32/64-bit differences, so test the exact bitness/version you will deploy. (support.microsoft.com)

Backup the original, split data (back-end) from UI (front-end) before compiling, and validate on representative client machines.

Recommended Answers

All 6 Replies

Member Avatar for Kegtapper

1st Save a copy of your mdb file in another directory (Back up)
then Open Access with no db, Choose Convert to MDE and select the database you want to use. This should create an executable MDE file. It will only display forms and reports, NO TABLES or QUERIES shown.

Hope that helps

----------

Hi There

Is There A Way To Make Access File As Exe File

Thanks In Advance

Member Avatar for ktbhutia

Hi I tried the following:
1st Save a copy of your mdb file in another directory (Back up)
then Open Access with no db, Choose Convert to MDE and select the database you want to use. This should create an executable MDE file. It will only display forms and reports, NO TABLES or QUERIES shown.
The tables and queries are still visible and the exe file starts in Mc-Access. Can it not run independently?
thanks,
kesang

Member Avatar for ahmedproo

hi there you can use mod ( microsoft office developer ) can solve the problem

Member Avatar for iming001

Yes, you can but you need to convert your Access forms, reports, macros, modules to VB6, VB .NET or C# first and then build the application with VB6 or VS .NET. You can take a look at the converters that offers.

Member Avatar for ali asif

how to convert msaccess 2007 file into exe file???

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.