Hi Richard, Great solution. Thanks! My Question is regarding printing reports? How would the printing reports use case be handled? Clearly they can not be directed to the local printer in the office? So where would they be directed to?
@julienalt18802 жыл бұрын
Finally someone has run through this. Thanks.. since I'm here all you work is amazing 👍
@599CD2 жыл бұрын
Glad I could help!
@DataisKing2 жыл бұрын
I have experience migrating Access tables into SharePoint Lists. The only problem that I ran into is losing the ability to create queries. In the past 6 months, I have been migrating Access databases into Power Apps for Teams with Dataverse as the backend and that's been working well so far.
@599CD2 жыл бұрын
Yeah, I prefer SQL Server over Sharepoint myself
@carchey79 Жыл бұрын
WOW, just what I'm looking for. One question I have, are there any issues with using a Drupal web front end?
@imstevemcqueen2 жыл бұрын
Talk about a Revolution in possibilities. Create a network without having to buy expensive hardware or software and all the rigmarole that comes with it.
@599CD2 жыл бұрын
Yep!!!
@599CD2 жыл бұрын
Someone ELSE gets to deal with that nightmare.
@tomscroggin6582 Жыл бұрын
Question: can I set up the database such that customers can enter data?
@599CD Жыл бұрын
Yep. That's the whole point of this video. :)
@joefensterblau51692 жыл бұрын
Tables and linked tables can be imported from another Access database. If your tables are in Sharepoint, can they be imported as well, or are they protected?
@599CD2 жыл бұрын
That all depends on how you've got the database set up. Yes, it's possible for anyone who has access to the back-end tables to import the data.
@santoshadhikari99332 жыл бұрын
hi can we perform something like sum(column) over(partition by column2) in ms access in query? not form or table or anything else.
@599CD2 жыл бұрын
I don't understand
@chh88602 жыл бұрын
ADC is very impressive ...and the presentation is excellent. I need to address a few items internally before I take the plunge, but very likely will do so ... Two questions please 1) Regarding allocation capacity; we have designed, created and maintain 10 databases for 10 clients (the databases are near identical in design and only vary in data size from 50MB to 150MB). At the moment total storage requirements are less than a GB. How will that affect the monthly fee? ... 2) What are the additional charges for M-365? Thank you ... very much appreciate your insights ... and again, nicely done.
@599CD2 жыл бұрын
With only 1 GB you'll be fine. They don't charge extra for space within reason. My Cloud PC has 16 GB available which should be MORE than enough for most users. As far as M365 goes, they don't sell licenses, but you can get them from Microsoft for $20/user/mo. Remember, most users can use the free Runtime edition.
@chh88602 жыл бұрын
@@599CD ... Thank you ... Thank you ... Thank you ... for the prompt response.
@Jim-nu6ux2 жыл бұрын
Our company (currently 20 unique users, 5 or less simultaneous users) Access DB sends email (using MS Outlook) notifications with PDF files attached, does this service allow/accommodate that?
@599CD2 жыл бұрын
Yes, but the Access Runtime will not send email via Outlook, so you'd need to install the full version of Office on your virtual machines (with licenses) or switch to a different method of sending email, such as the Gmail option I show in 599cd.com/EmailSeminar
@Jim-nu6ux2 жыл бұрын
@@599CD thank you. I'll be using your splitting and security classes to improve the database and I'll look at using Gmail for the email. They got me a gold membership but I watch a lot of your videos on KZbin so here you see my personal handle. I'll get the splitting and security classes/videos from your website. Thank you.
@boedilllard5952 Жыл бұрын
Just looked at it - pretty pricey. Hard to figure out if it is 2 simultaneous users or 2 out of many users that they are charging for.
@599CD Жыл бұрын
It's per user account... and it's well worth it if you want to share your Access database with a team and literally have ZERO other setup worries.
@moodkn2 жыл бұрын
Thanks! Great solution
@599CD2 жыл бұрын
You're welcome!
@shajys3 ай бұрын
Hi Richard .. Its a grate solution to access the Database online. Many Thanks for that ..Now I have a question about the users . if i have 2 user ID (as per their initial plan of minimum users ) , Can my second set of two users in a different time zone/Country use the same user id when ever this first two users logged out from their PCs ? .. Kindly let me know the possibilities.. Thanks
@nasanka Жыл бұрын
it needs MS office enterprise edition. USD 144 per year. office 365 family won't work on cloud services. so anyone still didn't buy office yet then go for enterprise edition. i had also access runtime error and also removed it. ADC is the easiest method and fast connection speed too.
@pkgupta9137 Жыл бұрын
I want to see demo on how to share access database with access dabase cloud?
@599CD Жыл бұрын
Access Database Cloud: 599cd.com/ADC
@xm_tech2 жыл бұрын
Thanks for sharing. I've been looking for this solution for some time.
@599CD2 жыл бұрын
Welcome
@vikkishowe-gaither43492 жыл бұрын
Can you give me their website address? there are a lot of companies doing this when I googled Access Cloud services. What is the company name you recommended?
@599CD2 жыл бұрын
599cd.com/ADC
@mlbumbalough9 ай бұрын
Sounds great. Question: is their monthly charges per Access database or is it per Access the application with unlimited Access databases? Thanks Boss!
@599CD9 ай бұрын
You pay per user account, and I don't think there is a limit on the number of databases you can have within reason, of course. But you get your own virtual PC. I don't know how much drive space you'll have to contact them, but if you have 3-4 users, that's what you pay for the additional logins, and each one of them will have their own virtual desktop. See this page for more info: 599cd.com/ADC
@ptzzycool2 жыл бұрын
Thanks a lot for this. It's so much relieving as we finally got an easy solution to sharing our database online. And I salute you, Richard Rost for sharing this great information with everyone of us. Just a question I have and that is, how does it work with databases that have linked documents like images and various files that we normally access from our database? Do we still keep them locally on our pcs or we need to upload all of our linked files online as well? Will be happy to hear from you. Thanks
@599CD2 жыл бұрын
If you want to open / view the documents from the database, they would need to be uploaded to the Cloud Server.
@ptzzycool2 жыл бұрын
@@599CD Thanks so much for the clarification.
@majidalamri53282 жыл бұрын
Hi, Thank you for showing us this great solution. please note that I have requested a demo from their website, however I received a message saying that this service is not available in my region. can you help me with that?
@599CD2 жыл бұрын
Did you try contacting their customer service?
@bumpersmith2 жыл бұрын
This seems to be a service where the smaller business or in our case a very small non-profit Historical Society would benefit the most. If you are a larger business you are like to invest in a company wide solution that is not dependent on an outside solution such as this. For a small entity like our group the cost is just way too much for us to handle. We have 7 officers/trustee's, and this would eat up our budget in no time. Are there any other very low cost solutions that would work for our needs?
@599CD2 жыл бұрын
Access Database Cloud is the best solution for a small group that doesn't want to spend any time developing an SQL Server solution. You can get setup very easily, but sure, there is a higher monthly cost. Honestly, as long as you don't mind putting in a little time into learning SQL Server, it's not that hard to set up if you're already familiar with developing in Access. My seminar walks you through it step-by-step: 599cd.com/AccessSQL - and the cost for this kind of solution is cheap. Online SQL Server web hosting through WinHost is like $10 per month, you can use free Access Runtime editions for your users, so there's no per-user cost. This is what I use for my in-house database and my website.
@bumpersmith2 жыл бұрын
@@599CD Thank you for taking the time to answer Richard
@599CD2 жыл бұрын
My pleasure
@jungjungdelosreyes41472 жыл бұрын
Wow thank you sir.
@599CD2 жыл бұрын
Welcome
@ZacA60423 Жыл бұрын
please share link for ms access cloud.
@599CD10 ай бұрын
I'm pretty sure it's in the description of the video itself: 599cd.com/ADC
@mikewashington41882 жыл бұрын
Thanks for great explanations. This method requires no additional development but the only drawback is the additional cost for the monthly fee.
@599CD2 жыл бұрын
Yep. That's the only major downside... but they have pretty awesome infrastructure. It's fast, managed, backed up. If your database is mission critical and you want to run it from multiple locations, this is the best solution short of upgrading to SQL Server.
@robertodc622 жыл бұрын
too expensive for 2 users 122 monthly is about 2700 mx
@599CD2 жыл бұрын
Yeah, but in this case you really do get what you pay for.
@robertodc622 жыл бұрын
@@599CD yes i check is great service richard but for some of my clients is a little spensive i will tray it with biger clients
@akokohjoel98542 жыл бұрын
Then the cost yearly will be very high
@robertodc622 жыл бұрын
i used a remot desktop with a server with a multiple users
@599CD2 жыл бұрын
Yeah, if you want to go through the trouble of setting up and maintaining your own server, you can definitely do it yourself. I don't want that headache. Been there before. No bueno.
@robertodc622 жыл бұрын
@@599CD yes i know but if you registered the remote users as local users in the server and give them configuration for remote descktop and used the microsoft remote descktop is more easy the configuration, thanks richard for you work i love your videos men
@akokohjoel98542 жыл бұрын
Can you show me how you did it roberto
@gregbetti2994 Жыл бұрын
$40 per month?
@j.dasilva456729 күн бұрын
Unfortunately is way to expensive.
@599CD18 күн бұрын
It's not cheap, but you definitely get what you pay for. And if you don't want to take the time to upscale your Microsoft Access database to SQL Server, then this is a great, easy way to do it.