Hosting an MS Access database on Linux shared by SAMBA share

Posted on 2006-05-02
Last Modified: 2010-04-20

We use Linux as our file server and provide access to files via SAMBA shares.

We have an MS access database that we want people to have access to (they are on Windows PC's) and want to store this file on the Linux server

I have had an experience with these whereby once one person opened the database others could not.

I seem to remember it was something to do with the samba permissions not being correct.

Can anyone provide guidance or assistance in this

Thanks in advance

Question by:johnkan
    LVL 14

    Accepted Solution


    Try put these settings for the Samba share:

            share modes = yes
            read only = No
            strict sync = Yes
            sync always = Yes

    Author Comment

    Hi ppfong

    thanks for the prompt response

    I'll give that a go tomorrow.

    LVL 14

    Assisted Solution

    strict sync I don't think is right choice

    the right solution:
    veto oplock files = /*.mdb/*.MDB/*.dbf/*.DBF/

    From microsoft
    Opportunistic Locking (oplocks) on the Network File Server
    Microsoft has discovered an issue where opportunistic locking can increase the risk of Jet database corruption when the file is shared by two or more clients on a network file server. This issue applies to Microsoft Windows NT 4.0, Microsoft Windows 2000, and Novell file servers that support opportunistic locking. This issue also applies to clients that are running Microsoft Windows NT 4.0, Microsoft Windows 2000, or Microsoft Windows XP, and that connect to a file server that supports opportunistic locking.

    Another smb.conf parameter that may cause severe network performance degradation is the strict sync parameter. Do not use this at all. There is no good reason to use this with any modern Windows client. The strict sync is often used with the sync always parameter. This, too, can severely degrade network performance, so do not set it; if you must, do so with caution.

    from samba doc

    LVL 22

    Assisted Solution

    Word of warning - If you have more than 1 person accessing this database at once, then you will potentially have if this database gets to a significant size say 20-30MB, then using it will start to cause you network problems!

    Safest method that I've seen for someone needing to have centralised networked storage on an access database using a Linux server is to NX to the server:

    or vnc:

    and then use crossover office to run access on the Linux server:

    Basically, if the data is valuable, and you really *MUST* have multiple people accessing a large Access DB, then get a Win Server in and use Terminal Services so that the database can be used locally to the Win Server.

    There are synchronisation methods for Access Databases, but none are particularly good in my opinion.


    Better still, get a decent database!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
    This article will explain how to establish a SSH connection to Ubuntu through the firewall and using a different port other then 22. I have set up a Ubuntu virtual machine in Virtualbox and I am running a Windows 7 workstation. From the Ubuntu vi…
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
    Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now