Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
NAS with personal cloud
Chris Nichol 
     
3 years ago
Hi everyone, hope you are all good.

Just a quick query but can you run a database off a NAS with a personal cloud?

At the moment I'm the only one who uses the database but I'd love to be able to give my bosses access to it especially when I'm working away. I know there's other things that can be done but I'm just thinking about the easiest and cheapest way of doing it.

Was looking at maybe getting this - Asustor Drivestor 2 AS1102T - 2 Bay NAS, 1.4GHz Quad Core, 2.5GbE Port, 1GB RAM DDR4, Network Attached Storage, Personal Private Cloud

Thanks for any advice on the matter
Adam Schwanz  @Reply  
           
3 years ago
Kevin Yip  @Reply  
     
3 years ago
Most NAS *don't run Windows.*  That may be okay for files, but Access is not just a file, but a piece of software, made to be run on Windows no less.  So it needs to be put in a Windows environment in order to run at its best.  So I advise against putting Access back ends on an NAS.

Most NAS use custom-made OS based on Linux or other open-source OS, because they are free and Windows isn't.  Connecting an NAS to a Windows PC is like connecting your Android phone to your Windows PC: you can see, copy, and paste the Android files using your Windows Explorer as if they were part of Windows.  (Android is also a free and open-source OS, by the way).  But you wouldn't put an Access back end on your Android phone, the same way you wouldn't io an NAS.

In the "Access Online" video that Adam mentioned above, Richard also advises against using Google Drive or the likes to store Access back ends.  The reason is similar: Google Drive likely doesn't run on Windows either (most likely Linux).
A Glenn Yesner  @Reply  
     
3 years ago
Richard recommends using MS SQL Server for a database backend and using MS Access as a frontend on the user's computer (splitting the database). I'm exploring using MySQL (on a hosted web site) as my backend, and so far it is working well, and using MS Access as my front end on various user's computers, here in the office and on remote sites (sublet vendors and job site users). I think it will work out well. I used ChatGPT (suggested by Richard and other site posters) to help develop the connection code.
Richard Rost  @Reply  
          
3 years ago
As the previous comments have already suggested, I wouldn't use a NAS with Access. They work by transferring changed files (or pieces of files) over the wire in a way that doesn't mesh with Access. Unless your users get a DIRECT connection to a drive on that NAS (and not just a cloned local copy of it) then I wouldn't trust it. And even if they do get a direct network connection to it, the performance over the Internet is going to be TERRIBLY slow.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/17/2026 10:43:54 AM. PLT: 0s