SOLVED

Shared Access Database Launched From Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-1734522%22%20slang%3D%22en-US%22%3EShared%20Access%20Database%20Launched%20From%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1734522%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20always%20looking%20for%20was%20to%20start%20using%20Teams%20for%20more%20than%20a%20messenger%20program.%20Now%20after%20Ignite%2C%20I%20am%20determined%20more%20than%20ever%20to%20start%20now.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20our%20engineers%20found%20this%20Access%20Program%20that%20someone%20developed%20for%20inspections%20on%20our%20welding%20equipment.%20Only%20two%20people%20need%20to%20use%20it%20and%20I%20wanted%20to%20make%20it%20available%20in%20Teams%20via%20OneDrive%20or%20SharePoint%20for%20them%20both%20to%20use.%20They%20both%20have%20Access%20on%20their%20local%20PC's.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20copying%20the%26nbsp%3Baccde%20file%20to%20the%20FILES%20section%20of%20the%20Engineering%20TEAM%20and%20then%20clicked%20on%20it%20but%20it%20just%20wants%20to%20DOWNLOAD%20and%20open%20locally.%20I'm%20assuming%20this%20is%20by%20design%20but%20I%20was%20wondering%20if%20anyone%20has%20successfully%20launched%20and%20written%20data%20to%20an%20Access%20DB%20in%20Teams%2FOneDrive.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1734522%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1734987%22%20slang%3D%22en-US%22%3ERe%3A%20Shared%20Access%20Database%20Launched%20From%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1734987%22%20slang%3D%22en-US%22%3EI%20know%20this%20is%20not%20what%20you%20want%20to%20hear%20but%20Access%20DB%20will%20never%20work%20very%20well%20over%20WAN%20or%20internet.%20It%20was%20barely%20usable%20on%20a%20LAN%20with%20high%20speed%20ethernet%20on%20mapped%20drives.%20Access%20DB%20is%20very%20susceptible%20to%20corruption%20and%20row%20locking%20problems%20when%20in%20multi-user%20scenario.%20You%20may%20get%20it%20to%20work%20by%20mapping%20drives%20using%20WEBDAV%20to%20the%20Teams%20location%20or%20by%20copying%20to%20a%20single%20users%20OneDrive%20and%20creating%20shares%20but%20trust%20me%20it%20will%20never%20be%20stable%20and%20offer%20the%20performance%20you%20desire.%20You%20may%20be%20better%20served%20to%20spend%20the%20time%20using%20the%20New%20Lists%20App%20in%20a%20Team%20tab%20or%20migrating%20the%20DB%20to%20a%20SQL%20server%20instance%20in%20a%20small%20Azure%20subscription%20and%20maybe%20use%20the%20Access%20DB%20for%20Forms%20and%20Query%20front%20end%20from%20each%20workstation%20and%20link%20to%20the%20Azure%20SQL.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1736721%22%20slang%3D%22en-US%22%3ERe%3A%20Shared%20Access%20Database%20Launched%20From%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1736721%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4306%22%20target%3D%22_blank%22%3E%40Forrest%20Hoffman%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ENope%2C%20this%20was%20a%20good%20reply%20and%20perhaps%20a%20bad%20%22first%20project.%22%20That%20said%2C%20I%20have%20a%20project%20where%20I%20can%20utalized%20SharePoint%20Lists%20and%20PowerApps.%20That%20said%2C%20being%20in%20a%20SOLO%20IT%20shop%2C%20got%20to%20find%20the%20time.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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. 

2 Replies
Highlighted
Best Response confirmed by Juan Carlos González Martín (MVP)
Solution
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.
Highlighted

@Forrest Hoffman 

Nope, this was a good reply and perhaps a bad "first project." That said, I have a project where I can utalized SharePoint Lists and PowerApps. That said, being in a SOLO IT shop, got to find the time.