Although I reached 58 Y but this is the first time in my life that I write a comment on a TH-cam 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.
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.🙂
I would start here: 599cd.com/ACB1 and get your database built properly to where you're happy with it for a single user. Then, once it's running the way you like, move it up to the Cloud. 599cd.com/ADC
@@599CD I must say, I love the fact that you actually get back to comments and take time to reply!!! Been subscribed but right now, I'd love to subscribe again! Perhaps I can do the bell icon. Hadn't done that. Edit: Turns out I had. I don't have much but I can do the join bit just to show my support in what you're doing. Thank you very much.
Well it's one of those things where if you don't want to put in any work to set up a proper multi user online database yourself with Access and SQL Server this is a solution that does it all for you with minimal work on your end. Obviously you get what you pay for and their service is fantastic but it's going to cost a little more as a monthly fee then just doing it all yourself so it's a trade off.
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.
Yeah, I played with some tools like Airtable, and they're okay. But like you said, they're kind of restrictive. Personally, if you need to get data online, I recommend Access for your PC desktop front-end, of course, and then put the data in SQL Server on the web. Then, you can access the data from pretty much any other tool out there or even build your own web pages in something like ASP, which is what I do.
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?
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.
That's the key: you have to pause synching or Google Drive will mess up your database. I recommend copying it from G: to your Desktop, working on it, and then copying it back to G: when you're done. As far as the price goes, yes, it's not cheap. It's a business-quality solution, and you definitely get what you pay for. The sweet spot is around 9 users. The cost per user goes down then when you figure it's $37 per user plus $48 maintenance fee for up to 9 users.
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. ?
Hello Richard! Just recently started looking at your website and the many lessons in it. I am now subscribed; I intend to become a paid subscriber (via your Join) very soon (if my clients leave me alone). This topic is 2 years old and I am wondering if you have any updates on it - or even if updates are needed. Thank you immensely for such a clear exposition of the many choices. You do such a good job!
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!
Yes if you want to share your access database to people in remote locations with the minimal amount of work then Access Database Cloud is the best solution.
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.
This is definitely an option to consider if cost is your primary concern. I've set up solutions like this in the past, but the performance was very slow. If you're going to share a database online and you don't want to go thru the work of properly upgrading your back-end to something like SQL Server, then a cloud PC setup is definitely the way to go. Sending just the screens over the Internet is a whole lot faster than a VPN solution WITH ACCESS alone.
@@599CD That is soooooo correct! I’m trying to use SQL Server for my database and individual tables take 4 minutes to load and views are read-only. I’ll post my situation in a separate comment.
@@liptonjh You need to design your database so it will minimize the amount of data being retrieved, such as avoiding loading a table full of data. Any online data connection demands the "client server" model, which all websites, mobile apps, etc., use, and which Access doesn't really use. If this comment section had 1k comments, would it load all 1k of them and slow down your Internet connection? Of course not. But Access would. Access retrieves data willy-nilly with no regards of performance. That's because Access was invented in the early 90s when online data connection was nonexistent.
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.
As long as nobody uses the database at the same time then you can use something like Google Drive or OneDrive to share the database file but if two people open it at the same time you're going to lose data. You're better off with a remote desktop solution and if you need concurrent multiple users then look into Access Database Cloud.
I think the video pretty much explains the difference. Access database cloud is all about using your exact access database on a different computer and just modifying and working with the screens and a PC session over the Internet. ASP is a web programming language so you're developing a new front end using web development tools to connect to an SQL Server back end.
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?
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.
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?
Access doesn't work well over a VPN. SQL Server is what I normally would recommend, but SSMA is horrid. Build the tables yourself and then copy the data over. ADC is a good solution if you have the budget.
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?
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?
Could I mirror the database onto a laptop from my home PC, then do my sales and updates on the road, then when I get home, update the home database with my laptop database.
Hi Richard. Thanks so much for this video. Very helpful. Does Access Database Cloud work for end users using a Mac? I develop for two companies whose employees use Macs exclusively. TIA! ~Stacey
Hi Richard. My department wants to make a new database to replace the current database. reason being the current database which is using Ms Access can only be used in the office since it was connected to the office server. The problem is most of us work out of the office and need to access the database to get data or update new data. I want to ask your opinion on which database is suitable for us. plus we have no expertise in this field so complicated software that need coding is a no no. please help me T^T
Bro im a beginner and i want to make database about book. The problem is i want to search th tiitle book and subject in page of book. I only make in one table. Can it work? Plase make a video 🙏
@@599CD oh I just re-watched this video and realized they were using remote app, but still cool and seems like another way of making Access available on the web: th-cam.com/video/JTQBNrZ8ga4/w-d-xo.html
Although I reached 58 Y but this is the first time in my life that I write a comment on a TH-cam 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.
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.🙂
I would start here: 599cd.com/ACB1 and get your database built properly to where you're happy with it for a single user. Then, once it's running the way you like, move it up to the Cloud. 599cd.com/ADC
@@599CD I must say, I love the fact that you actually get back to comments and take time to reply!!! Been subscribed but right now, I'd love to subscribe again! Perhaps I can do the bell icon. Hadn't done that.
Edit: Turns out I had. I don't have much but I can do the join bit just to show my support in what you're doing.
Thank you very much.
Your pricing comment seriously understates the real cost involved for multiple users.
Well it's one of those things where if you don't want to put in any work to set up a proper multi user online database yourself with Access and SQL Server this is a solution that does it all for you with minimal work on your end. Obviously you get what you pay for and their service is fantastic but it's going to cost a little more as a monthly fee then just doing it all yourself so it's a trade off.
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.
Yeah, I played with some tools like Airtable, and they're okay. But like you said, they're kind of restrictive. Personally, if you need to get data online, I recommend Access for your PC desktop front-end, of course, and then put the data in SQL Server on the web. Then, you can access the data from pretty much any other tool out there or even build your own web pages in something like ASP, which is what I do.
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?
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.
That's the key: you have to pause synching or Google Drive will mess up your database. I recommend copying it from G: to your Desktop, working on it, and then copying it back to G: when you're done. As far as the price goes, yes, it's not cheap. It's a business-quality solution, and you definitely get what you pay for. The sweet spot is around 9 users. The cost per user goes down then when you figure it's $37 per user plus $48 maintenance fee for up to 9 users.
is there a way to pause the synchronization from VBA Code?
Good one. But how it will work with a multiuser access file. Simultaneous update?
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. ?
Yes there are more videos on my website that explain how to use it and set it up. 599cd.com/ADC
@@599CD I reviewed it and it was very helpful : thank you vey much
Hello Richard!
Just recently started looking at your website and the many lessons in it. I am now subscribed; I intend to become a paid subscriber (via your Join) very soon (if my clients leave me alone). This topic is 2 years old and I am wondering if you have any updates on it - or even if updates are needed. Thank you immensely for such a clear exposition of the many choices. You do such a good job!
Welcome aboard! No, I'd say not much has changed in the 2 years since I released this video. The options are pretty much the same.
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!
Yes if you want to share your access database to people in remote locations with the minimal amount of work then Access Database Cloud is the best solution.
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.
This is definitely an option to consider if cost is your primary concern. I've set up solutions like this in the past, but the performance was very slow. If you're going to share a database online and you don't want to go thru the work of properly upgrading your back-end to something like SQL Server, then a cloud PC setup is definitely the way to go. Sending just the screens over the Internet is a whole lot faster than a VPN solution WITH ACCESS alone.
@@599CD That is soooooo correct! I’m trying to use SQL Server for my database and individual tables take 4 minutes to load and views are read-only. I’ll post my situation in a separate comment.
@@liptonjh You need to design your database so it will minimize the amount of data being retrieved, such as avoiding loading a table full of data. Any online data connection demands the "client server" model, which all websites, mobile apps, etc., use, and which Access doesn't really use. If this comment section had 1k comments, would it load all 1k of them and slow down your Internet connection? Of course not. But Access would. Access retrieves data willy-nilly with no regards of performance. That's because Access was invented in the early 90s when online data connection was nonexistent.
Pls can you explain how VPN router it MS access work on internet? I am very much interested
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.
As long as nobody uses the database at the same time then you can use something like Google Drive or OneDrive to share the database file but if two people open it at the same time you're going to lose data. You're better off with a remote desktop solution and if you need concurrent multiple users then look into Access Database Cloud.
Thanks for this video. Please what is the main difference between using Access database Cloud and using Asp with Sql at the backend
I think the video pretty much explains the difference. Access database cloud is all about using your exact access database on a different computer and just modifying and working with the screens and a PC session over the Internet. ASP is a web programming language so you're developing a new front end using web development tools to connect to an SQL Server back end.
Hello Sir, can we make an executable file of MS Database?
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?
Do. Not. Use. Google. Drive. With. Access.
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.
I don't recommend it. Unless you have SUPER FAST Internet speed (and I mean like Gigabit both ways) then Access won't perform well.
Just what I needed thank you
Welcome
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?
Access doesn't work well over a VPN. SQL Server is what I normally would recommend, but SSMA is horrid. Build the tables yourself and then copy the data over. ADC is a good solution if you have the budget.
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?
20 users should be fine. It's more about the fact that SQL Server is easier to manage for larger groups of users. Sharepoint gets cumbersome.
@@599CD 100% agree from the maintenance aspect. Just was curious from the performance and capability perspective. Appreciate your help!
That's really more about the speed of your server and your Internet connection.
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?
Access Database Cloud or a Remote Desktop solution
Concurr. Thanks for concurring 🙂
Glad you concur. :)
Hi Richard. Is it possible to insert a record from and access table to google sheets with vba?
Not directly what you can use Excel as a mediary: 599cd.com/Surveys
Hello Richard, is sharepoint good option for team of 100 users?.....Great and helpful video, well apreciated.
See previous reply
What do you think about remote ODBC with mySQL. In some low cost Webhosting packages you can enable remote access to mySQL.
I personally prefer SQL Server. You can get hosting from Winhost with SQL Server for $5 per month. 599cd.com/Winhost
@@599CD how is your experience with their performance?
Ms access as front end and Office Lists as backend is the best solution
It's a GOOD solution. SQL Server as a back-end will almost always be the BEST solution - but it depends on your needs.
what about foldr, my school uses it and i need to save it on there
Never heard of it
Could I mirror the database onto a laptop from my home PC, then do my sales and updates on the road, then when I get home, update the home database with my laptop database.
Sure. But I recommend MOVING it to your laptop and then MOVING it back to your PC. This way you're always sure which is the CURRENT one.
Hi Richard. Thanks so much for this video. Very helpful. Does Access Database Cloud work for end users using a Mac? I develop for two companies whose employees use Macs exclusively. TIA! ~Stacey
It most certainly does work for Mac users.
Hi Richard. My department wants to make a new database to replace the current database. reason being the current database which is using Ms Access can only be used in the office since it was connected to the office server. The problem is most of us work out of the office and need to access the database to get data or update new data. I want to ask your opinion on which database is suitable for us. plus we have no expertise in this field so complicated software that need coding is a no no. please help me T^T
Access Database Cloud is the perfect solution for you then. 599cd.com/ADC
How can you configure Chrome Remote Desktop to be unattended? IE you don't have to have someone there to admit you in?
Yep. I use it on the road all the time. Just leave it running and leave the PC on.
Bro im a beginner and i want to make database about book. The problem is i want to search th tiitle book and subject in page of book. I only make in one table. Can it work? Plase make a video 🙏
See 599cd.com/SearchForm2
can we connect pc access database with online sql database and get data from both at a time??
Yep
@@599CD please video link where you explain this.
Thank for all
welcome
What about Microsoft Access Online as part of Office 365?
Access isn't included with the other online versions of Office apps like Word and Excel. Sadly.
@@599CD oh I just re-watched this video and realized they were using remote app, but still cool and seems like another way of making Access available on the web: th-cam.com/video/JTQBNrZ8ga4/w-d-xo.html
Is it possible we use live data form websites but on website have username passwords
Sure. Anything's possible.
@@599CD how
رقم in Arabic dose not mean No it means number must right لا
A few people have mentioned that. Thanks.
🤯
👧
How do connect my program access with another pc vi Intrent online step by step please with details ....
599cd.com/ADC