Forum Discussion
Shared Access Database Launched From Teams
- I know this is not what you want to hear but Access DB will never work very well over WAN or internet. It was barely usable on a LAN with high speed ethernet on mapped drives. Access DB is very susceptible to corruption and row locking problems when in multi-user scenario. You may get it to work by mapping drives using WEBDAV to the Teams location or by copying to a single users OneDrive and creating shares but trust me it will never be stable and offer the performance you desire. You may be better served to spend the time using the New Lists App in a Team tab or migrating the DB to a SQL server instance in a small Azure subscription and maybe use the Access DB for Forms and Query front end from each workstation and link to the Azure SQL.
PassRusher I use access successfully with teams. You need to replicate all the tables in your database as SharePoint Lists (With the same name as the tables. then you remove the original tables and connect to the SharePoint lists in stead. You still need to have the access file on your local pc but the data now resides in the Teams SharePoint site. The only limitation is that you cannot access the db in teams itself or on a mobile device. If you want to access the app on mobile, you will have to redevelop it using PowerApps. Hope it helps!
Hi, I have the similar issue for accessing the MS access file from Teams. Every time my team tries to access it, that starts to download on PC. I see you were able to resolve it.
Could you please elaborate the steps with some more details on replicating all the tables in your database as SharePoint Lists ??? . I'm not an expert in MS access 😞
Thanks,
RJ