BoulderRidge
Programmer
--- Posting same thread on MS Access: Other and MS Sharepoint forums ---
I have an MS Access app that I need to deploy to multiple users who don’t share a single network drive. Their best common access point is via Sharepoint. What I’ve read to date suggests that publishing the Access app fully onto Sharepoint will severely limit the functionality I can use in the app—i.e. no VBA code under my forms. This is not really an option.
What other options might work for deployment? Could I publish only shared tables to Sharepoint, link them back to my MDB containing forms, and distribute this as an MDE file to my users? Or is there a way from a Sharepoint site to either let them run the MS Access “front end” in a multi-user mode or download an updated front end MDEs when changes are made?
I can use MS Access 2003 or 2007 and Sharepoint WSS3 or 2007, no higher on either count. I cannot assume all users will have MS Access installed locally. I have experience with Access development but am a newbie with Sharepoint. Any help is greatly appreciated!
-- BoulderRidge B-)
I have an MS Access app that I need to deploy to multiple users who don’t share a single network drive. Their best common access point is via Sharepoint. What I’ve read to date suggests that publishing the Access app fully onto Sharepoint will severely limit the functionality I can use in the app—i.e. no VBA code under my forms. This is not really an option.
What other options might work for deployment? Could I publish only shared tables to Sharepoint, link them back to my MDB containing forms, and distribute this as an MDE file to my users? Or is there a way from a Sharepoint site to either let them run the MS Access “front end” in a multi-user mode or download an updated front end MDEs when changes are made?
I can use MS Access 2003 or 2007 and Sharepoint WSS3 or 2007, no higher on either count. I cannot assume all users will have MS Access installed locally. I have experience with Access development but am a newbie with Sharepoint. Any help is greatly appreciated!
-- BoulderRidge B-)