Hello everybody,
I have been developping a company database for a while now.
There is quite a lot of VBA code included, macros, etc. I need multiple users from multiple devices and locations (not 1 LAN) to access the database. So I decided to use SharePoint (we have Office 365 subscription) and uploaded the tables as SharePoint lists.
However, I cannot work with the database. There are some VBA errors that aren't occuring when the database is stored locally.
Does SharePoint not support every functionality? Can I go around this somehow? Or did I do something wrong?
If SharePoint isn't the solution, what can you recommend me to do when I want several people to work with the database simultaneously? We don't have a network drive or something like that and when I try to connect the database to a backend on OneDrive or Dropbox, I run into a problem because I can't find root folder and therefore cannot determine the path to the backend (so that it would be the same for every user).
Thank you for replies.
Best regards,
Tomas