Making my database executable for others.

[Czeszyn]

If you make your database into a executable file to package it, does the other person you are sending it to have to have or own Access to use it. I was under the impression that I could create a database, package it as its own program and give it to someone that does not have access and it would still work? If not, how would I do such a thing.

Thank you.

 

[pbaldy]

The other person must have Access; you can't create an executable from a db. There is a free runtime version of Access available from MS.

 

[Czeszyn]

Thank you for responding.
So with this runtime, will this allow the person who does not have access use my database. Also where do I get this runtime, and how do I work with it.
I am trying to create a database for my mother using access, but she does not have access, I though I read somewhere that you can create a database, and there was a way for the other person to use it. If not, what would you recommend.

Thank you again.
Tony

 

[CJ_London]

assuming you are using 2007 or later, use the package and sign option (File>Save and Publish) - you can add a requirement to include the runtime among other things. This creates a single file you can copy you your mothers machine which can be run to install your db and the runtime access.

Be aware that runtime access provides the bare minimum so you will not have a navigation window, ribbon or shortcut menus. You will need to write your own routines to create these if required.

To see what runtime is like from a users perspective, rename your db as .accdr and open it. When done, just rename back to .accdb or .accde as required. Note, because of a lack of a navigation window, you will need to specify a form to open (File>Options>Current Database - Display Form) or have an autoexec macro

 

[Czeszyn]

Thank you so much CJ_London, that was very helpful. I know I should break down and learn C# and create the database from scratch, but I really like Access. Thank you again.
Tony