Make access .dbf an .exe file

[Bradon]

I have a database that I want to make available as a .exe file for users who do not have access on their machine.

Can this be done or can anyone point me towards a reasonably costed solution.

 

[Norie]

I don't think it is really possible. As far as I know you can't make an exe file from an Access database.

I think that if you are using Access to do something then the user might need to have Access installed on their machine.

What are you actually trying to do?

 

[DaveSwanton77]

Rather than make the database into an .exe file you could make it run in Microsoft Access Runtime. This will allow users to utilise the database without having to have the full version of Access installed on their machine.

To create a runtime compatible database ensure that a macro called AutoExec is created to display the startup form. Also ensure that all modules have error checking or the database will crash without any notification.

The error check I use is in the syntax shown below.

Sub XXX()

On Error GoTo Err_XXX

'Insert your code

Exit_Err_XXX:
Exit Sub

Err_XXX:
MsgBox Err.Description, vbCritical + vbSystemModal, "Error"
Resume Exit_Err_XXX

End Sub


Runtime downloads are dependant on the version of Access used to create the database.


Regards
Dave

 

[mdmilner]

The MS Access runtime comes with the MS Office Developers edition.
It comes with a package & deployment wizard interface.

What this means is, you can create installation packages which can be distributed to users that do not have a full install of Access. Technically, the runtime is a license limited full installation of Access. The primary difference in use is, you have no menu's at all in the runtime. You must build everything into a form that must load at startup.

Mike