Tips on publishing an access database to a sharepoint site

Hello,

I wanted to clarify in my mind several issues regarding hosting an access 2010 database on a share point site.  
1.  When I publish a standard access database, that employs vba, the database - in particular, the front-end  will still work as if you were accessing the database as a standalone database.  
2.  Access Web databases, when hosted or published to a share point site, do not permit the use of vba
Juan VelasquezAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
not sure about #1

On number 2, you  are correct, Access "web" databases do not allow the use of VBA...
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Regarding #1: Yes, your vba will still work. In essence, you "publish" the data to Sharepoint. Other users then run the FE of your app, and they'll use that SP data.

Note, however, that most report poor performance with this methodology. If you need a true web app then your best solution is to use a web-based language like ASP.NET, PHP, etc to create that app.
0
Juan VelasquezAuthor Commented:
HellO LSM

If I understand correctly, I would publish the data i.e. tables to the sharepoint site as lists and then other users would use the access front-end that would be loaded on their desktops to access the data.  Is that correct?
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
That is correct. Each FE would connect to the SharePoint lists.
0
Juan VelasquezAuthor Commented:
Thanks for the advice.  I think that the best approach will be to create an Access Web database.  The client is currently using a contact database created from an Access template, to contact employees.  I can modify that database and use it as the basis for the employee database.  I won't be able to use VBA but that won't be an issue since the required functionality can be provided by Macros.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you're going to go the web route, I'd suggest an upgrade to 2013. There's been quite a few enhancements to web databases (known as "web apps") in 2013, and it's well worth the upgrade.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Juan VelasquezAuthor Commented:
Thanks again
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.