how to create a form as an executable

[versuviusx]

hi everyone i'm super new at access. i think it's neat for now.
i just made a form that people can use to insert information. we have a network drive here and it would be super cool to be able to convert the form into an Executeable file that way people can just click on the exe Icon and open up the form without having to go into access and then open the form.
please let me know

 

[KeithG]

Not possible, you would need Visula Studio's or something similar to make an executable. You could set you form as the start up form so that everytime the user opens the database your form will be displayed.

 

[boblarson]

As Pat Hartman will tell you, there is no way, EVER, to make an access database an executable file. You can create a RUNTIME version of your database, if you have the developer's edition, which will allow you to use an Access database without having a full version of Access.

It is possible to use an mdb file for the storage facility for a Visual Basic, Visual C++, etc. program, but you would need to have that programming tool available and then the mdb file is good ONLY for the tables and queries, and you cannot use forms, reports, etc.

Again, I say (with strong emphasis, so all can hear) - You can NEVER make an Access database an executable!

Now, that being said, you can make it so that your form shows but the Access window does not (it will still be in the taskbar), but that takes some advanced work and programming as you have to use pop up forms, which means if you wanted to display a report you would have to close the form, open the report and when the report closes open the form again. There have been posts here to tell you how to do this, and I actually did it for a database of mine many, many years ago. But, I figured out that it wasn't worth the effort.

 

[CEH]

Versu...... Heres something you might consider if you simply do not want to put Access on every machine that might use your app. We have employees in another city that needed the ability to put info into one of my apps. So we put Access on the server. They log in using "Remote" they can then put the frontend on their remote desktop. Works fine.