SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
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.
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 :)
