Folder Security/Permissions

[Guest]

I installed a database as machine administrator. It Works fine.
Another user open windows XP without administrator permissions and then open
the access database program and it open in mode read only.
At the moment i know if the user is not administrator, the access open in
mode read only.

Question.
How can I change programmatically (vba) the folder permissions for all users
open the access database in full mode (not read only)?

Thanks for every body

 

[Keith Wilby]

I installed a database as machine administrator. It Works fine.
Another user open windows XP without administrator permissions and then
open
the access database program and it open in mode read only.
At the moment i know if the user is not administrator, the access open in
mode read only.

Question.
How can I change programmatically (vba) the folder permissions for all
users
open the access database in full mode (not read only)?

You don't need to. Grant "change" permissions on the folder to the
"everyone" group but grant only "read" and "write" permissions to the mdb
file (ie remove "delete").

Keith.

 

[Guest]

Thanks Keith,
Probably you never see this issue.

If you create a folder as administrator, you don't have problems, always you
can open access database read and write mode.

If you close the windows and you open as not administrator user and if you
open the access database, you will open as read only.

If you check folder permissions the write permission is not checked.

My question is, how can I give permissions programmatically for everyone?
In this case I need at least write and read (read is checked) and also for
the others permissions:
Full control; Modify; Read and execute; read; Write; Special permissions.

Thanks
JCP

 

[Stefan Hoffmann]

hi JCP,

I installed a database as machine administrator.
How can I change programmatically (vba) the folder permissions for all users
open the access database in full mode (not read only)?

This is the wrong approach.

User data is installed under %USERPROFILE%, if it is for a single user
otherwise it is installed under %ALLUSERSPROFILE%.


mfG
--> stefan <--

 

[Guest]

I create a Install package and I would like to install it under Program Files.
I know if I install in my documents there is not this problem.
Manually, I can fix this problem, I go to folder permissions and I change
what i need, I would like programmatically.

Have you any idea?

Thanks

 

[Stefan Hoffmann]

hi,

I create a Install package and I would like to install it under Program Files.
I know if I install in my documents there is not this problem.
Manually, I can fix this problem, I go to folder permissions and I change
what i need, I would like programmatically.

Users have no full access in %PROGRAMFILES% by default, cause this is
for securities sake. Don't break that concept.

Have you any idea?

It is highly recommended that you store data in %USERPROFILE% or
%ALLUSERSPROFILE%.

Install your applications documentation there and create there a link to
your app in on of the above mentioned directories.


mfG
--> stefan <--

 

[Guest]

Thanks for your suggestions but I didn't like to use links. If there is
Program Files folder, I think that's the best location to install programs.
Normally, I don't see programs installed under %USERPROFILE% or
%ALLUSERSPROFILE%
I don't want to change permissions for Program Files Folder; I Want give
permissions only for the main folder of my application under Program Files.
There are many access database applications and many of them are installed
under Program Files and all users can open with full access.

Thanks

I believe, if we can change permissions manually, we can also do
programmatically.

 

[Stefan Hoffmann]

hi,

Thanks for your suggestions but I didn't like to use links. If there is
Program Files folder, I think that's the best location to install programs.
Normally, I don't see programs installed under %USERPROFILE% or
%ALLUSERSPROFILE%

The problem is, that an Access application is not a programm. It is data.

I don't want to change permissions for Program Files Folder; I Want give
permissions only for the main folder of my application under Program Files.
There are many access database applications and many of them are installed
under Program Files and all users can open with full access.

I know a bunch of admins which simply don't allow such applications to
be installed nor run.


mfG
--> stefan <--

 

[Guest]

I created an application based access 20003 with BE/FE and I build a package
etc. It is not a program? Which name we must call? I call a program, probably
is wrong. Could you tell me what is a program?

 

[Stefan Hoffmann]

hi,

I created an application based access 20003 with BE/FE and I build a package
etc. It is not a program? Which name we must call? I call a program, probably
is wrong. Could you tell me what is a program?

You may ignore my posts, cause it's just my opinion. Some others think
the same, some others don't, Windows XP works like that...


mfG
--> stefan <--