B
Bob Quintal
Hi,
I wrote an Access '97 application in 2001 that creates a tab
delimited file on a network drive that is shared by the Windows users
and an Unix application, using SMB..
It worked fine, all users wre able to regenerate the file, and all
users of the Unix application could read the file from the Unix side.
Some changes were made to the system last week that have resulted in
the file having rights only to the Windows userID who runs the
session that creates the file.
Other users cannot read or delete the file unless the 'owner' right-
clicks the file name, selects properties, and assigns the rights to
members of 'everyone' (the only group available).
Unless the owner assigns the rights, a different user who tries to
overwrite the file gets an error message that the file cannot be
written.
Worse yet, the Unix system refuses to read the file except when the
Unix login ID matches the Windows login ID of the file's 'owner'
Does anyone have a code example of how to set file access rights via
VB code from an Access 97 mdb.
Off the top of my head:
Grant group:"Everyone" file:"X:/path/file.tab" rights:"RWED"
or something similar
I wrote an Access '97 application in 2001 that creates a tab
delimited file on a network drive that is shared by the Windows users
and an Unix application, using SMB..
It worked fine, all users wre able to regenerate the file, and all
users of the Unix application could read the file from the Unix side.
Some changes were made to the system last week that have resulted in
the file having rights only to the Windows userID who runs the
session that creates the file.
Other users cannot read or delete the file unless the 'owner' right-
clicks the file name, selects properties, and assigns the rights to
members of 'everyone' (the only group available).
Unless the owner assigns the rights, a different user who tries to
overwrite the file gets an error message that the file cannot be
written.
Worse yet, the Unix system refuses to read the file except when the
Unix login ID matches the Windows login ID of the file's 'owner'
Does anyone have a code example of how to set file access rights via
VB code from an Access 97 mdb.
Off the top of my head:
Grant group:"Everyone" file:"X:/path/file.tab" rights:"RWED"
or something similar