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.🙂
@599CD2 жыл бұрын
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
@richardmwambanga2423 Жыл бұрын
@@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.
@ziadkohail2273 Жыл бұрын
Although I reached 58 Y but this is the first time in my life that I write a comment on a KZfaq 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.
@leonardweber102911 ай бұрын
Your pricing comment seriously understates the real cost involved for multiple users.
@599CD10 ай бұрын
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.
@blangus6 ай бұрын
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.
@599CD6 ай бұрын
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.
@krishnavasudevan25038 күн бұрын
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!
@599CD7 күн бұрын
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.
@bumpersmith2 жыл бұрын
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.
@599CD2 жыл бұрын
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.
@LabeebMT Жыл бұрын
is there a way to pause the synchronization from VBA Code?
@LabeebMT Жыл бұрын
Good one. But how it will work with a multiuser access file. Simultaneous update?
@eileenliedeker9625 Жыл бұрын
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!
@599CD Жыл бұрын
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.
@rabidfollower2 жыл бұрын
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.
@599CD2 жыл бұрын
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.
@liptonjh Жыл бұрын
@@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.
@rabidfollower Жыл бұрын
@@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.
@7ammoodi1 Жыл бұрын
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. ?
@599CD Жыл бұрын
Yes there are more videos on my website that explain how to use it and set it up. 599cd.com/ADC
@7ammoodi1 Жыл бұрын
@@599CD I reviewed it and it was very helpful : thank you vey much
@hedgetrimmer123 Жыл бұрын
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.
@599CD Жыл бұрын
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.
@info4patients3 ай бұрын
Hello Sir, can we make an executable file of MS Database?
@abdoulayetoure996510 ай бұрын
Thank for all
@599CD9 ай бұрын
welcome
@sarak46176 ай бұрын
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?
@DAUDASOKUNBI Жыл бұрын
Thanks for this video. Please what is the main difference between using Access database Cloud and using Asp with Sql at the backend
@599CD Жыл бұрын
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.
@BlindBandit1x3 ай бұрын
what about foldr, my school uses it and i need to save it on there
@599CD3 ай бұрын
Never heard of it
@andyrbush Жыл бұрын
Just what I needed thank you
@599CD Жыл бұрын
Welcome
@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?
@599CD Жыл бұрын
Do. Not. Use. Google. Drive. With. Access.
@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?
@599CD Жыл бұрын
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.
@HuyPhan-rl8bz2 жыл бұрын
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.
@599CD2 жыл бұрын
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.
@schoolofathens1210 ай бұрын
Hi Richard. Is it possible to insert a record from and access table to google sheets with vba?
@599CD10 ай бұрын
Not directly what you can use Excel as a mediary: 599cd.com/Surveys
@tjeffryes110 ай бұрын
How can you configure Chrome Remote Desktop to be unattended? IE you don't have to have someone there to admit you in?
@599CD10 ай бұрын
Yep. I use it on the road all the time. Just leave it running and leave the PC on.
@opencarrymagazine51342 жыл бұрын
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.
@599CD2 жыл бұрын
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.
@kinka972 жыл бұрын
Ms access as front end and Office Lists as backend is the best solution
@599CD2 жыл бұрын
It's a GOOD solution. SQL Server as a back-end will almost always be the BEST solution - but it depends on your needs.
@pioneerfootballtouchdowncl3387 Жыл бұрын
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?
@599CD Жыл бұрын
Access Database Cloud or a Remote Desktop solution
@EricaDyson2 жыл бұрын
Concurr. Thanks for concurring 🙂
@599CD2 жыл бұрын
Glad you concur. :)
@srdjanpanic8109 Жыл бұрын
Hello Richard, is sharepoint good option for team of 100 users?.....Great and helpful video, well apreciated.
@599CD Жыл бұрын
See previous reply
@bernhardherlemann37352 жыл бұрын
What do you think about remote ODBC with mySQL. In some low cost Webhosting packages you can enable remote access to mySQL.
@599CD2 жыл бұрын
I personally prefer SQL Server. You can get hosting from Winhost with SQL Server for $5 per month. 599cd.com/Winhost
@Wasifali302 Жыл бұрын
@@599CD how is your experience with their performance?
@domingosvazpintofilipe77222 жыл бұрын
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 🙏
@599CD2 жыл бұрын
See 599cd.com/SearchForm2
@Chris-vp6vf2 жыл бұрын
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?
@599CD2 жыл бұрын
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.
@Chris-vp6vf2 жыл бұрын
@@599CD 100% agree from the maintenance aspect. Just was curious from the performance and capability perspective. Appreciate your help!
@599CD2 жыл бұрын
That's really more about the speed of your server and your Internet connection.
@abdulh89582 жыл бұрын
رقم in Arabic dose not mean No it means number must right لا
@599CD2 жыл бұрын
A few people have mentioned that. Thanks.
@alejandrochavarria19542 жыл бұрын
What about Microsoft Access Online as part of Office 365?
@599CD2 жыл бұрын
Access isn't included with the other online versions of Office apps like Word and Excel. Sadly.
@alejandrochavarria19542 жыл бұрын
@@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: kzfaq.info/get/bejne/gLqBdbGjv57LkWg.html
@rizwanyousaf9942 жыл бұрын
can we connect pc access database with online sql database and get data from both at a time??
@599CD2 жыл бұрын
Yep
@rizwanyousaf9942 жыл бұрын
@@599CD please video link where you explain this.
@staceydoucette74212 жыл бұрын
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
@599CD2 жыл бұрын
It most certainly does work for Mac users.
@salamfromsalam73702 жыл бұрын
Is it possible we use live data form websites but on website have username passwords
@599CD2 жыл бұрын
Sure. Anything's possible.
@salamfromsalam73702 жыл бұрын
@@599CD how
@shahirahnadia58162 жыл бұрын
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
@599CD2 жыл бұрын
Access Database Cloud is the perfect solution for you then. 599cd.com/ADC
@yahyaahmed92912 жыл бұрын
How do connect my program access with another pc vi Intrent online step by step please with details ....