NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
How to share an MS Access database
Hello all,
Im new to ReadyNAS and this forum and hope I can learn much from you all.
We are a small manufacturing business of 10 operating WITHOUT a server. I have installed ReadyNAS to assist with sharing files and maintaining backups.
I wish to run an MS Access database on the ReadyNAS that will be used by 3-4 staff occassionally throughout the day to record thier production data. I wish to view the production data live from my PC.
If I split my database with the back end on ReadyNAS and the front end on each PC, will the links from the front end to the back end work and can each user access the same single backend of Access on the ReadyNAS? I dont want them downloading the backend onto their machine.
Thanks
Dean
3 Replies
Replies have been turned off for this discussion
I haven't done this, but I think splitting the database is the right approach.
There is more info on that here: https://support.office.com/en-us/article/Ways-to-share-an-Access-database-2c24eb08-bee1-453e-be8e-455f847c5c74
When you create the back-end database, you specify a NAS share as shown in the note here: https://support.office.com/en-us/article/Split-an-Access-database-3015ad18-a3a1-4e9c-a7f3-51b1d73498cc
Thanks Stephen.
Are there any particular settings in ReadyNAS I should be aware of to accommodate for this particular use of the file system such as such as file sharing protocols?
Dean
If you are running Windows 7 through Windows 10, there shouldn't be any special settings you need. On the NAS side, all you should need to do is set up SMB access for the network share holding the database back-end, and make sure the users all have read/write access to it. There is an SMB Plus app from Netgear that gives you control over some SMB settings.
You will want to keep snapshots turned off on the network share holding the database. Otherwise the database will get heavily fragmented.
Also, RAID is not enough to keep the data files safe - you will need a good backup plan in place for at least the shared files on the NAS. Also, you might re-visit disaster recovery.
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
