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.

1 Answer 1


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

Yes you can look at links below,


Video for publishing to sharepoint using Access


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 :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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