Determine folder access rights

by using a real ETL process.

where you get notified (via email) when you have failures.


On Mar 3, 9:24*pm, "John J." wrote:
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 ...

"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.

"John J." wrote in
:

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

Based on your original definition of the problem and explanation of
what you wanted to do, (see below), knowing the difference would be
irrelevant.


"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.





--
Bob Quintal

PA is y I've altered my email address.

It is relevant. When the user has no access rights he should get a message
that that is the problem. When the export went wrong and no files exists in
a folder the user has access to, the user should be notified about that.

John

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

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

Based on your original definition of the problem and explanation of
what you wanted to do, (see below), knowing the difference would be
irrelevant.


"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.





--
Bob Quintal

PA is y I've altered my email address.