Determine folder access rights

Before starting a procedure I need to know if the user has at least READ
permissions on a certain folder. I found several ideas on Google but none of
them are suitable. The point is that I don't know beforehand if and which
files are in the folder. Also, when a user has only READ permissions, it is
no use to check if he can write to the folder.

I'm looking for something like Function canRead(strFolder as string) as
Boolean.

How could I achieve this or is it just not possible?

Thank you.
John

I can usually do things like this via XP_CMDSHELL 'DIR C:\Windows'






+ On Mar 2, 7:01*am, "John J." wrote:
Before starting a procedure I need to know if the user has at least READ
permissions on a certain folder. I found several ideas on Google but none of
them are suitable. The point is that I don't know beforehand if and which
files are in the folder. Also, when a user has only READ permissions, it is
no use to check if he can write to the folder.

I'm looking for something like Function canRead(strFolder as string) as
Boolean.

How could I achieve this or is it just not possible?

Thank you.
John

John,

Might help to tell us a little bit more about your set-up and what you are
tyring to accomplish...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

wrote in message
...
I can usually do things like this via XP_CMDSHELL 'DIR C:\Windows'






+ On Mar 2, 7:01 am, "John J." wrote:
Before starting a procedure I need to know if the user has at least READ
permissions on a certain folder. I found several ideas on Google but none
of
them are suitable. The point is that I don't know beforehand if and which
files are in the folder. Also, when a user has only READ permissions, it
is
no use to check if he can write to the folder.

I'm looking for something like Function canRead(strFolder as string) as
Boolean.

How could I achieve this or is it just not possible?

Thank you.
John

I would ignore Gina, her answer is to use Jet, no matter how
applicable.

I'd just move to SQL Server and learn a really practical database.
Jet is obsolete and it has been for a decade.

-Aaron



On Mar 2, 9:40*pm, "Gina Whipp" wrote:
John,

Might help to tell us a little bit more about your set-up and what you are
tyring to accomplish...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

wrote in message

...
I can usually do things like this via XP_CMDSHELL 'DIR C:\Windows'

*+ On Mar 2, 7:01 am, "John J." wrote:

Before starting a procedure I need to know if the user has at least READ
permissions on a certain folder. I found several ideas on Google but none
of
them are suitable. The point is that I don't know beforehand if and which
files are in the folder. Also, when a user has only READ permissions, it
is
no use to check if he can write to the folder.

I'm looking for something like Function canRead(strFolder as string) as
Boolean.

How could I achieve this or is it just not possible?

Thank you.
John

I have an app that imports Excel files from different read-only folders (one
folder per department). Some users have read access to every folder, some
only for one. Users have their own app. In the app the user can select one
or more departments. Before the import starts I need to check if the user
has read rights to the specific departement(s) (folder(s)) he has selected.
If he doesn't have the rights, he should be notified and the import is
canceled.
Hope this makes things clearer.
John


"Gina Whipp" schreef in bericht
...
John,

Might help to tell us a little bit more about your set-up and what you are
tyring to accomplish...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

wrote in message
...
I can usually do things like this via XP_CMDSHELL 'DIR C:\Windows'






+ On Mar 2, 7:01 am, "John J." wrote:
Before starting a procedure I need to know if the user has at least READ
permissions on a certain folder. I found several ideas on Google but none
of
them are suitable. The point is that I don't know beforehand if and which
files are in the folder. Also, when a user has only READ permissions, it
is
no use to check if he can write to the folder.

I'm looking for something like Function canRead(strFolder as string) as
Boolean.

How could I achieve this or is it just not possible?

Thank you.
John

John,

I have not seen anything that checks the folders permissions from within
Access. I did find a module that will notify you of any chages to a
folder... http://www.mvps.org/access/modules/mdl0053.htm This MIGHT work or
point you in the right direction, if a change is not made that might be all
the notification you need to send a message.

You can check out the entire site http://www.mvps.org/access/ as there might
be something you could use other then the module I found. I looked but who
knows I might have issed it because there is alot of information there.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"John J." wrote in message
...
I have an app that imports Excel files from different read-only folders
(one folder per department). Some users have read access to every folder,
some only for one. Users have their own app. In the app the user can select
one or more departments. Before the import starts I need to check if the
user has read rights to the specific departement(s) (folder(s)) he has
selected. If he doesn't have the rights, he should be notified and the
import is canceled.
Hope this makes things clearer.
John


"Gina Whipp" schreef in bericht
...
John,

Might help to tell us a little bit more about your set-up and what you
are tyring to accomplish...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

wrote in message
...
I can usually do things like this via XP_CMDSHELL 'DIR C:\Windows'






+ On Mar 2, 7:01 am, "John J." wrote:
Before starting a procedure I need to know if the user has at least READ
permissions on a certain folder. I found several ideas on Google but
none of
them are suitable. The point is that I don't know beforehand if and
which
files are in the folder. Also, when a user has only READ permissions, it
is
no use to check if he can write to the folder.

I'm looking for something like Function canRead(strFolder as string) as
Boolean.

How could I achieve this or is it just not possible?

Thank you.
John

Thanks Gina. I'll check it out.
John

"Gina Whipp" schreef in bericht
...
John,

I have not seen anything that checks the folders permissions from within
Access. I did find a module that will notify you of any chages to a
folder... http://www.mvps.org/access/modules/mdl0053.htm This MIGHT work
or point you in the right direction, if a change is not made that might be
all the notification you need to send a message.

You can check out the entire site http://www.mvps.org/access/ as there
might be something you could use other then the module I found. I looked
but who knows I might have issed it because there is alot of information
there.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"John J." wrote in message
...
I have an app that imports Excel files from different read-only folders
(one folder per department). Some users have read access to every folder,
some only for one. Users have their own app. In the app the user can
select one or more departments. Before the import starts I need to check
if the user has read rights to the specific departement(s) (folder(s)) he
has selected. If he doesn't have the rights, he should be notified and the
import is canceled.
Hope this makes things clearer.
John


"Gina Whipp" schreef in bericht
...
John,

Might help to tell us a little bit more about your set-up and what you
are tyring to accomplish...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

wrote in message
...
I can usually do things like this via XP_CMDSHELL 'DIR C:\Windows'






+ On Mar 2, 7:01 am, "John J." wrote:
Before starting a procedure I need to know if the user has at least
READ
permissions on a certain folder. I found several ideas on Google but
none of
them are suitable. The point is that I don't know beforehand if and
which
files are in the folder. Also, when a user has only READ permissions,
it is
no use to check if he can write to the folder.

I'm looking for something like Function canRead(strFolder as string) as
Boolean.

How could I achieve this or is it just not possible?

Thank you.
John

" wrote in

m:

I would ignore Gina, her answer is to use Jet, no matter how
applicable.

I'd just move to SQL Server and learn a really practical database.
Jet is obsolete and it has been for a decade.

-Aaron


PLEASE MOVE TO SQL SERVER AND LEAVE THE ACCESS NEWSGROUPS.

Jet is nowhere near obsolete, only an aaron would say so..


wrote in message


--
Bob Quintal

PA is y I've altered my email address.
strThisMessage = replace(strThisMessage,"aa","mo")

"John J." wrote in
:

I have an app that imports Excel files from different read-only
folders (one folder per department). Some users have read access
to every folder, some only for one. Users have their own app. In
the app the user can select one or more departments. Before the
import starts I need to check if the user has read rights to the
specific departement(s) (folder(s)) he has selected. If he doesn't
have the rights, he should be notified and the import is canceled.
Hope this makes things clearer.
John

If you try to open a spreadsheet but do not have read rights to the
folder, Access throws an error message,

All you need is to handle the error and exit the sub.

--
Bob Quintal

PA is y I've altered my email address.

I do check that. But it could be that the file actually doesn't exists, for
instance because the third party export to the folders went wrong. How would
I know the difference?
John

"Bob Quintal" schreef in bericht
...
"John J." wrote in
:

I have an app that imports Excel files from different read-only
folders (one folder per department). Some users have read access
to every folder, some only for one. Users have their own app. In
the app the user can select one or more departments. Before the
import starts I need to check if the user has read rights to the
specific departement(s) (folder(s)) he has selected. If he doesn't
have the rights, he should be notified and the import is canceled.
Hope this makes things clearer.
John

If you try to open a spreadsheet but do not have read rights to the
folder, Access throws an error message,

All you need is to handle the error and exit the sub.

--
Bob Quintal

PA is y I've altered my email address.