Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

There is one Access database, which consists of a single table (r_data), reports, queries, and VBA modules. VBA modules can change the structure of the table r_data. VBA modules can also write data to the table r_data from another database.

Can such Access database be published on SharePoint, using Access Services?

I suspect not. Please explain to me why.

share|improve this question
add comment

1 Answer 1

I never tried it myself but after a bit of research I can say

Yes you can look at links below,

publish-your-access-database-to-sharepoint

Video for publishing to sharepoint using Access

EDIT

Since your updating Database outside sharepoint using VBA module, so it shouldn't interrupt sharepoint publishing it, you might come across few issues while publishing tho, but if I was you, I would actually try it myself first :)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.