Share Your Microsoft Access Database Online with Access Database Cloud

  Рет қаралды 35,671

Computer Learning Zone

Computer Learning Zone

Күн бұрын

Пікірлер: 61
@LuisBreak
@LuisBreak 6 ай бұрын
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?
@julienalt1880
@julienalt1880 2 жыл бұрын
Finally someone has run through this. Thanks.. since I'm here all you work is amazing 👍
@599CD
@599CD 2 жыл бұрын
Glad I could help!
@DataisKing
@DataisKing 2 жыл бұрын
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
@599CD 2 жыл бұрын
Yeah, I prefer SQL Server over Sharepoint myself
@carchey79
@carchey79 Жыл бұрын
WOW, just what I'm looking for. One question I have, are there any issues with using a Drupal web front end?
@imstevemcqueen
@imstevemcqueen 2 жыл бұрын
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
@599CD 2 жыл бұрын
Yep!!!
@599CD
@599CD 2 жыл бұрын
Someone ELSE gets to deal with that nightmare.
@tomscroggin6582
@tomscroggin6582 Жыл бұрын
Question: can I set up the database such that customers can enter data?
@599CD
@599CD Жыл бұрын
Yep. That's the whole point of this video. :)
@joefensterblau5169
@joefensterblau5169 2 жыл бұрын
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
@599CD 2 жыл бұрын
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.
@santoshadhikari9933
@santoshadhikari9933 2 жыл бұрын
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
@599CD 2 жыл бұрын
I don't understand
@chh8860
@chh8860 2 жыл бұрын
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
@599CD 2 жыл бұрын
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
@chh8860 2 жыл бұрын
@@599CD ... Thank you ... Thank you ... Thank you ... for the prompt response.
@Jim-nu6ux
@Jim-nu6ux 2 жыл бұрын
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
@599CD 2 жыл бұрын
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
@Jim-nu6ux 2 жыл бұрын
@@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
@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
@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.
@moodkn
@moodkn 2 жыл бұрын
Thanks! Great solution
@599CD
@599CD 2 жыл бұрын
You're welcome!
@shajys
@shajys 3 ай бұрын
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
@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
@pkgupta9137 Жыл бұрын
I want to see demo on how to share access database with access dabase cloud?
@599CD
@599CD Жыл бұрын
Access Database Cloud: 599cd.com/ADC
@xm_tech
@xm_tech 2 жыл бұрын
Thanks for sharing. I've been looking for this solution for some time.
@599CD
@599CD 2 жыл бұрын
Welcome
@vikkishowe-gaither4349
@vikkishowe-gaither4349 2 жыл бұрын
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 2 жыл бұрын
599cd.com/ADC
@mlbumbalough
@mlbumbalough 9 ай бұрын
Sounds great. Question: is their monthly charges per Access database or is it per Access the application with unlimited Access databases? Thanks Boss!
@599CD
@599CD 9 ай бұрын
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
@ptzzycool
@ptzzycool 2 жыл бұрын
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
@599CD 2 жыл бұрын
If you want to open / view the documents from the database, they would need to be uploaded to the Cloud Server.
@ptzzycool
@ptzzycool 2 жыл бұрын
@@599CD Thanks so much for the clarification.
@majidalamri5328
@majidalamri5328 2 жыл бұрын
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
@599CD 2 жыл бұрын
Did you try contacting their customer service?
@bumpersmith
@bumpersmith 2 жыл бұрын
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
@599CD 2 жыл бұрын
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
@bumpersmith 2 жыл бұрын
@@599CD Thank you for taking the time to answer Richard
@599CD
@599CD 2 жыл бұрын
My pleasure
@jungjungdelosreyes4147
@jungjungdelosreyes4147 2 жыл бұрын
Wow thank you sir.
@599CD
@599CD 2 жыл бұрын
Welcome
@ZacA60423
@ZacA60423 Жыл бұрын
please share link for ms access cloud.
@599CD
@599CD 10 ай бұрын
I'm pretty sure it's in the description of the video itself: 599cd.com/ADC
@mikewashington4188
@mikewashington4188 2 жыл бұрын
Thanks for great explanations. This method requires no additional development but the only drawback is the additional cost for the monthly fee.
@599CD
@599CD 2 жыл бұрын
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.
@robertodc62
@robertodc62 2 жыл бұрын
too expensive for 2 users 122 monthly is about 2700 mx
@599CD
@599CD 2 жыл бұрын
Yeah, but in this case you really do get what you pay for.
@robertodc62
@robertodc62 2 жыл бұрын
@@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
@akokohjoel9854 2 жыл бұрын
Then the cost yearly will be very high
@robertodc62
@robertodc62 2 жыл бұрын
i used a remot desktop with a server with a multiple users
@599CD
@599CD 2 жыл бұрын
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
@robertodc62 2 жыл бұрын
@@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
@akokohjoel9854 2 жыл бұрын
Can you show me how you did it roberto
@gregbetti2994
@gregbetti2994 Жыл бұрын
$40 per month?
@j.dasilva4567
@j.dasilva4567 29 күн бұрын
Unfortunately is way to expensive.
@599CD
@599CD 18 күн бұрын
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.
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 57 МЛН
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 22 МЛН
Мясо вегана? 🧐 @Whatthefshow
01:01
История одного вокалиста
Рет қаралды 7 МЛН
Migrate MS Access Data to the Web in 9 Minutes
9:15
The m-Power Platform
Рет қаралды 86 М.
Lecture 15 - Digital Forensics
29:02
Atif Farid Mohammad
Рет қаралды 21
Access News 9, Nov 2024
22:56
Karl Donaubauer
Рет қаралды 1,4 М.