Results 1 to 4 of 4

MS Access on a NAS server

  1. #1
    Yann63 is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2012
    Posts
    10

    MS Access on a NAS server

    Hello,



    I have an MS Access application which has to be used by different users at the same time.
    As the application is now on Dropbox, simultaneous use will cause synchronisation problems
    Before I go ahead to buy a NAS server, I want to be sure if my Access application will be usable for different users
    at the same time when it is place on the NAS server.

    Thank you for your feedback and comments.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,138
    Multi-user database should be split. Each user runs their own copy of frontend. This is a common topic.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  3. #3
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    6,131
    You need to clarify whether you mean a Network Attached Storage device or a Network Access Server and also whether is connected via a LAN or internet. If you mean Network Attached Storage and it is connected to your LAN then providing users have been granted the appropriate read/write permissions they should be able to access the back end in the same way as if it was on your standard network file server - as June says, the db should be split, the back end on the NAS and front ends on users machines. However I would still recommend you talk to the device suppliers to verify this is possible.

  4. #4
    sdel_nevo is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Apr 2013
    Location
    Gloucester, UK
    Posts
    402
    Hi

    my Database backend sits on a Qnap nas box, and works very well indeed.
    as has already been mentioned you will need to assign the correct permissions to the folder that is holding your backend tables just as you would if it was located on a Windows PC or Windows server for example
    the other benefit the NAS may bring if it has the facility is the ability to allow VPN connections, this way you could be in a physically different location to your backend table and it still works, its slower granted but workable dependant on your broadband connection of course

    Steve

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Upgrade from SQL Server 2008 to SQL Server 2014
    By RayMilhon in forum SQL Server
    Replies: 4
    Last Post: 07-12-2017, 03:54 PM
  2. ACCESS and SQL SERVER
    By elico in forum SQL Server
    Replies: 1
    Last Post: 01-31-2016, 03:34 PM
  3. Replies: 1
    Last Post: 02-23-2015, 06:06 AM
  4. Replies: 2
    Last Post: 11-21-2012, 08:57 AM
  5. Access and SQL Server on a VPN: Possible?
    By evander in forum Database Design
    Replies: 6
    Last Post: 02-03-2011, 09:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums