Smb settings - Database

[bockq]

Hi !

There are known issues for smb-share options, for filebased or sql etc. databases?
Eg. Access (filebased ) located on a smb share open-e.....

Best,
B.

[Gr-R]

as with any unix <-->windows file sharing, there are some caveats.....
as an example...

if using a file type database:

1. create a unix workgroup containing all users that will access the database,
2. granted rwx access for this unix work group to all directories and database files (including mdws), however setting the sticky bit on the directories, so as not to allow users accidentally delete the database files.
3 created the share, and granted rw access to it for the workgroup, also setting up the adequate file creation modes. Note: file creation modes are very important as ldb files are continuously created and deleted by msaccess, and while they exist, they should be writeable for all users, not for just the one who created them.