I think I solved my problem. Here's what i did...


After posting I realized that the ClickOnce installer installs a copy for each user profile rather than everyone. This was a problem for me, so I decided to do the following to harness the "Good Stuff" Click Once offers.

1.) Using Inno Setup I compiled an installer for my VFP app including the database.
2.) When Inno runs my setup it creates a registry entry regarding the installation directory of my App.
3.) Using the Visual Studio Bootstrapper I created a new clickOnce "Prerequisite" that basically points to the app I compiled in Inno Setup.
4.) In VFP I created a launcher program that basically looks for that registry entry and executes my VFP app using that entry.

5.) Finally I created a ClickOnce deployment using the VFP launcher program I created.


Doing it this way allowed me to install my program in the "Program Files" folder in addition to my database. If another user wants to run the program they will need to run the ClickOnce install, but it will only install the "VfpLauncher" and take just a few seconds.

If anyone has anything to add to this, feel free.

Thanks

Chris