Share Your Microsoft Access Database Online with Access Database Cloud

[@LuisBreak]

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?

[@stevegraffeo2375]

Can I have remote users and local users with this or must all my users of the Back end data be on this service?

[@599CD]

599cd.com/QQ

[@carchey79]

WOW, just what I'm looking for. One question I have, are there any issues with using a Drupal web front end?

[@DataisKing]

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.

[@599CD]

Yeah, I prefer SQL Server over Sharepoint myself

[@tomscroggin6582]

Question: can I set up the database such that customers can enter data?

[@599CD]

Yep. That's the whole point of this video. :)

[@joefensterblau5169]

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?

[@599CD]

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.

[@julienalt1880]

Finally someone has run through this. Thanks.. since I'm here all you work is amazing 👍

[@599CD]

Glad I could help!

[@Jim-nu6ux]

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?

[@599CD]

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-nu6ux]

@@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.

[@santoshadhikari9933]

hi can we perform something like sum(column) over(partition by column2) in ms access in query? not form or table or anything else.

[@599CD]

I don't understand

[@chh8860]

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.

[@599CD]

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.

[@chh8860]

@@599CD ... Thank you ... Thank you ... Thank you ... for the prompt response.

[@vikkishowe-gaither4349]

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?

[@599CD]

599cd.com/ADC

[@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.

[@pkgupta9137]

I want to see demo on how to share access database with access dabase cloud?

[@599CD]

Access Database Cloud: 599cd.com/ADC

[@shajys]

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

[@majidalamri5328]

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?

[@599CD]

Did you try contacting their customer service?

[@ptzzycool]

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

[@599CD]

If you want to open / view the documents from the database, they would need to be uploaded to the Cloud Server.

[@ptzzycool]

@@599CD Thanks so much for the clarification.

[@ZacA60423]

please share link for ms access cloud.

[@599CD]

I'm pretty sure it's in the description of the video itself: 599cd.com/ADC

[@imstevemcqueen]

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.

[@599CD]

Yep!!!

[@599CD]

Someone ELSE gets to deal with that nightmare.

[@bumpersmith]

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?

[@599CD]

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.

[@bumpersmith]

@@599CD Thank you for taking the time to answer Richard

[@599CD]

My pleasure

[@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.

[@moodkn]

Thanks! Great solution

[@599CD]

You're welcome!

[@mlbumbalough]

Sounds great. Question: is their monthly charges per Access database or is it per Access the application with unlimited Access databases? Thanks Boss!

[@599CD]

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

[@gregbetti2994]

$40 per month?

[@robertodc62]

too expensive for 2 users 122 monthly is about 2700 mx

[@599CD]

Yeah, but in this case you really do get what you pay for.

[@robertodc62]

@@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

[@akokohjoel9854]

Then the cost yearly will be very high

[@xm_tech]

Thanks for sharing. I've been looking for this solution for some time.

[@599CD]

Welcome

[@robertodc62]

i used a remot desktop with a server with a multiple users

[@599CD]

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.

[@robertodc62]

@@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

[@akokohjoel9854]

Can you show me how you did it roberto

[@jungjungdelosreyes4147]

Wow thank you sir.

[@599CD]

Welcome

[@j.dasilva4567]

Unfortunately is way to expensive.

[@599CD]

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.

[@mikewashington4188]

Thanks for great explanations. This method requires no additional development but the only drawback is the additional cost for the monthly fee.

[@599CD]

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.