Distribute a MS Access form to be desktop icon

I have a database and created a form to be used by multiple users.
Is there a way to "package" that form - to allow me to distribute that form and they could have it as a desktop icon?
The form would still need to be using the datasource on the shared drive, but saved locally on multiple users desktops.

Can this be done?
Thanks!!
ba_trainerAsked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
You cannot distribute an Access form separate from the Access .mdb/.mde file it resides in.
You can have that form open automatically via Tools menu:Startup, Startup Form, then distribute the shortcut along with the .mdb/.mde file.

>The form would still need to be using the datasource on the shared drive
As long as the drive/folder/file of the data source is the same (especially drive letter if it's a shared drive), then you'll be okay here.

Hope this helps.
-Jim
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade.  Good luck with your project.  -Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.