Making a DB executable

[Gilfdz]

Hello

I'm about to finish my first database (some tables, lots of forms and reports) and i need to know how to make it "executable" so that the user will open one file and the BD will open with a default form which he WONT be able to change into DESIGN mode...but just enter information, move from form to form, print reports, save DB, etc etc.

How can i do this??

Gilberto

 

[boblarson]

You can't make an Access database into an executable file. You CAN, however create an MDE file which will then protect your forms, reports, and code from being able to be modified. If they have the full version of Access they will still be able to modify queries and tables, but if they use the runtime version then they can't.

 

[Bee]

You can't make an Access database into an executable file. You CAN, however create an MDE file which will then protect your forms, reports, and code from being able to be modified. If they have the full version of Access they will still be able to modify queries and tables, but if they use the runtime version then they can't.

I did not know you could modify MDE files. What do you mean by full version? Also, would an MDE file work in exactly the same manner as an mdb file?

Thanks,
B

 

[boblarson]

What do you mean by full version?

Having the Full-Version of Microsoft Access, which lets you create and edit databases. If they have Access installed then they can go modify queries and tables in an MDE file. If they don't have Access installed, but have the Access Runtime installed then they can't modify anything except data where they have been provided a way to enter and edit data.

Also, would an MDE file work in exactly the same manner as an mdb file?

Somewhat - with an MDE file, it is a compiled file so that all code must be able to compile without error and you need to make sure to have error handling to handle errors or else the user will get an error message for an error and then the program will just quit. Also, you must provide them with menus and toolbars as they are not automatically provided for those running via the Access Runtime.