Hi,

I have an application which uses a certain Access database in windows.

I need two users to use the same database file from different machines, (we are controling who updates by code).

If I set the database in a samba share, the second user wont be able to open the file, not even in read only.

How can I change this?

If I set the same on a shared directory in windowze it works fine.

The reason for this is so 2 users wont be writing partially complete files to the same file.

I don't know how you are doing this in windows.

Samba is for sharing directories that are mounted with a windows machine or 2 Linux machines.

Samba is like Windows shared folder program, netbios I believe please explain in detail what you are trying to do.

thanks for your answer

What I'm trying to do is one of those "shouldn't do things", quite silly actually and am not proud of it.

I have a software which ussually reads and seldom writes to an access database,

because of a time/cost matter, instead of doing it by the book... i.e. reprograming the application in a multi-tier enviroment, and changing to MySQL or SQL Server or similar, I'm trying to share the same access database.
To avoid going into development.

I thougth an access database would only lock the record instead of the file, and so this appears to happen on a shared windows directory but when going into a samba directory, the whole file is blocked.

I can even open many applications with the same aplication using the same database on the local drive on the computer and Access will defend the record so that only one writes at that record at a time.

So I thougth there must be something wich is locking the file within Samba.

I know there is a general parameter for file locking, but this is a general parameter and goes to all files, I only need to unlock this one or at least this share, and they recommend not to set it to off,

is there anything else I can do?

I dont know bud, what you are doing seems to be just beyond my comprehension.

locate all file/user locks in smb.conf and remove those or something.
surely there is a way to do this. whatever it is.

I do not comprehend what you are trying to do either. Are you having a problem with permissions in Linux?

Probably the piece you are missing is:

I have a SAMBA server, which works as a file server so that users can share files, one of these files is an Access Database File, with many tables.

If I share a directory via Windows, the file does not get locked. There is only record locking (done manually)

If I share it via Samba, it get's locked. Leaving it as a single user program even though the users might be ussing different tables.

Permissions are open in Linux/Unix and in Samba for each user

I haven't touched the file locking parameters of samba as they seem to be general parameters, and it is not advised to.