Oct 01 2020 06:11 AM
Oct 01 2020 06:11 AM
I am always looking for was to start using Teams for more than a messenger program. Now after Ignite, I am determined more than ever to start now.
One of our engineers found this Access Program that someone developed for inspections on our welding equipment. Only two people need to use it and I wanted to make it available in Teams via OneDrive or SharePoint for them both to use. They both have Access on their local PC's.
I tried copying the accde file to the FILES section of the Engineering TEAM and then clicked on it but it just wants to DOWNLOAD and open locally. I'm assuming this is by design but I was wondering if anyone has successfully launched and written data to an Access DB in Teams/OneDrive.
Oct 01 2020 07:34 AMSolution
Jan 08 2021 12:17 AM
@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!
Aug 24 2021 07:26 PM
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 :(
Aug 29 2021 09:16 AM
Aug 31 2021 08:45 AM - edited Aug 31 2021 10:10 AM
I am not condoning this but, if you really wanted to try and use Access within Teams.
All the users must be members of the Team and Channel that you want to use. Unless you are going to break permissions of the SP Library (which is not recommended).
Upload the Access DB into one of the Channel Files area.
Then use the Sync feature of the Files tab to sync.
Open the Access DB from the Synced location on the local computer.
Cross your fingers and hope that a WAN or LAN issue doesn't lock or corrupt the DB.