Four Different Ways to Share Your Microsoft Access Database Online. Use Access Remotely Anywhere.

I get asked this question all the time: "How can I put my Access database online so other people can use it?" There are several different things you can do to put your database online, depending on who your users are, what kind of security you need, how much work you want to put into development, and what you want the end-result to look like.

TOPICS COVERED:
File Sharing Services
Google Drive, OneDrive, DropBox
SharePoint
SQL Server Online
Chrome Remote Desktop
Access Database Cloud
Access Web Apps

LEARN MORE:

LINKS:

COURSES:

ADDITIONAL RESOURCES:

KEYWORDS
access 2016, access 2019, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, share, sharing, file sharing, dropbox, onedrive, google drive, sharepoint, sql server, online, remote desktop, access database cloud, access web apps, how to share microsoft access database online, turn access database into web application, sharing access database on onedrive, share access database on google drive, multiple users, publish access database to web, Ways to share an Access database, Can Access database be shared online, How can I share my Access database over the Internet, How do I make my Access database online accessible, You can use your Microsoft Access Databases Online

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[ziadkohail]

Although I reached 58 Y but this is the first time in my life that I write a comment on a YouTube video. I would like to thank you deeply for your wonderful way of explaining and for the great effort that you make. I live in UAE and I loved Access program since long, therefore I could learn Access on my own through books and the Internet till I succeeded to sell some of my programs (Created in access) in our local market since aim a jobless for 4 years, but Honestly, I learned a lot from you, thank you again.

[emilyduyck]

Thank you for making these videos. I'm about to embark on making this for my parents business and I wasn't sure where to begin. The 3 biggest requests from my dad are: using the program remotely (we see customers in their homes), a program that will auto fill customers information across selected forms, and can build a bill of sales from our products. Still slightly nervous to start the process but your videos are really helping.🙂

[leonardweber]

Your pricing comment seriously understates the real cost involved for multiple users.

[blangus]

Thanks, I am helping a nonprofit and needed to know if there were options for something like Access. They (non-IT folks) selected a product called Airtable, and it seems very restrictive IMHO, but then I'm a former DBA (DB2, Oracle, SQL Server, Sybase, RDS, Redshift, DBMongo, etc.). (and yes in another life I used to code a lot of small MS Access DBs. This video really did an excellent job presenting the strengths and weaknesses and your opinions which; al f which was quite helpful.

[eileenliedeker]

Excellent video! I'm looking to share a database with a small group of remote users (not employees, but chairpersons of a national association). I'm a database programmer, familiar with VB and Access, but have never used SQL Server and don't have SharePoint set up. Sounds like Access Database Cloud is a better solution. Thanks so much for sharing your expertise!

[bumpersmith]

I do use my access db's' with one drive and google G drive but I pause both one drive or G drive until I am done. This has worked for me without any problems. Just don't forget to pause before opening your database.
Access Database Cloud price is out of reach for families that want to say update a genealogy database together or for a small town none profit museum work together to update accessions, etc. This is even expensive for a small business in these trying times.

[sarak]

Thank you for your video. My workplace uses Sharepoint and I would like to share my database with my coworkers. I currently do not have the ability to create a site on Sharepoint. If I have a split database and I put my back end file with my tables in a shared folder under Documents (in site library) can I give my users copies of the front end file to store on their desktops to all access the same back end tables at the same time?

[infopatients]

Hello Sir, can we make an executable file of MS Database?

[rabidfollower]

Another way to share database files is to set up a virtual private network among your users with VPN routers, which can be had for $100 each. The only recurring charge is the $5 a month service from DynDNS, which enables your VPN routers to connect over the Internet to form a private network. This is not only a cheap and safe method (since the connection is private), but you can also do more than just sharing Access, since you get full Windows networking capabilities, allowing you to share Windows folders, printers, etc. Richard, if cost is the main concern for your users, you may want to let them consider this option.

[hedgetrimmer]

Great video - My problem is we have are a home visit company and often offline - I was hoping 2 users could use Access offline while at a home visit and then sync when back online.

[ammoodi]

Dear Mr. Richard, thank you for the valuable information ... all your videos include valuable information ...
My question is : Do you have a video explains how to use Access Database Cloud service. ?

[DAUDASOKUNBI]

Thanks for this video. Please what is the main difference between using Access database Cloud and using Asp with Sql at the backend

[BlindBanditx]

what about foldr, my school uses it and i need to save it on there

[LabeebMT]

Thanks for the video. Dear, I have a Hundred user expected solution developed in Access. What about splitting the database and keep the backend in googleDrive? or can I use Google ODBC driver?

[HuyPhan-rlbz]

Thanks very much for your video. I am using Access offline on my PC. I wish to know your idea about the option to put the access file (or Access database file) on the cloud service and map that cloud service as a network folder/drive. I tested this option I this works for me alone but have not tested it for more than 1 users.

[Chris-vpvf]

Hi Richard, thank you for all of the videos you provide. On the SharePoint option, when you say "small teams", how many people are you envisioning? I have a scenario with about 20 users on a team. Would that be too many users for the SharePoint option?

[schoolofathens]

Hi Richard. Is it possible to insert a record from and access table to google sheets with vba?

[srdjanpanic]

Hello Richard, is sharepoint good option for team of 100 and helpful video, well apreciated.

[pioneerfootballtouchdowncl]

So if a small company that already has Access Database set up but needs to make it have access to a few employees that are at different locations, and they don't have an IT guru, what is your recommendation for them to get it set up to work successfully?

[liptonjh]

Thanks for a great presentation. Let me tell you my situation.

I have a small database (12, 000 KB) with 60 or so users. We’re on VPN most days; on a LAN each Tuesday. ACCESS and VPN do NOT get along — we have frequent corruption issues. The database is already split, with the tables on the back-end and everything else (including LOTS of VBA) on the front-end.

I tried using SQL Server — used SSMA to migrate and SSMS to manage the tables. First, SSMA is HORRID! It turns on a flag in each table it migrates and won’t find the table until it’s turned of. Even then, I get lots of connection errors — there are days when it won’t migrate at all. Once I migrated my tables, I ran into the speed problem. If I run a query in Access, the result can take 4 minutes. If I run the query in SQL Server and link it as a view, my forms become read-only.

ADC looks like the way to go — just move the whole database to the cloud. $2000 per month is a tiny fraction of my company’s budget but I’m not sure if I can get it. Any advice?