Security

My tables are in a folder on the G drive on a local area network.
The users have to have permission to go to this folder in order to use
the
application. Can I make it so they can only use the tables from the
code in
the application, without giving them permission to go directly to the
folder
and then get to the tables?

re: Security

gn wrote:[color=blue]
> My tables are in a folder on the G drive on a local area network.
> The users have to have permission to go to this folder in order to use
> the
> application. Can I make it so they can only use the tables from the
> code in
> the application, without giving them permission to go directly to the
> folder
> and then get to the tables?[/color]

Nope.

You can hide the share on the LAN and then connect to the tables in code using
an MDE so the code cannot be examined. The users would be hard pressed to even
know where to look for the back end in that scenario. However; if someone
figured it out they would have full access to the tables.

If that is not acceptable then your data should not be stored in an MDB file.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

re: Security

If you implement user-level security, then you can deny users
permission to open the tables directly. Instead, you can force them to
use queries that you provide and designate as "Read with owners
permission" (RWOP)

Explained in the Security FAQ -- find a link on the website in my
signature.


On Fri, 07 Jan 2005 17:38:37 -0600, gn <gngiugh@hotmail.com> wrote:
[color=blue]
>My tables are in a folder on the G drive on a local area network.
>The users have to have permission to go to this folder in order to use
>the
>application. Can I make it so they can only use the tables from the
>code in
>the application, without giving them permission to go directly to the
>folder
>and then get to the tables?
>[/color]


**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

re: Security

On Fri, 7 Jan 2005 18:31:29 -0600, "Rick Brandt"
<rickbrandt2@hotmail.com> wrote:
[color=blue]
>gn wrote:[color=green]
>> My tables are in a folder on the G drive on a local area network.
>> The users have to have permission to go to this folder in order to use
>> the
>> application. Can I make it so they can only use the tables from the
>> code in
>> the application, without giving them permission to go directly to the
>> folder
>> and then get to the tables?[/color]
>
>Nope.
>
>You can hide the share on the LAN and then connect to the tables in code using
>an MDE so the code cannot be examined. The users would be hard pressed to even
>know where to look for the back end in that scenario. However; if someone
>figured it out they would have full access to the tables.
>
>If that is not acceptable then your data should not be stored in an MDB file.[/color]

Thank you. It is an MDE. I could give the folder a name that gives
them no clue what is in it.

re: Security

gn wrote:[color=blue]
> On Fri, 7 Jan 2005 18:31:29 -0600, "Rick Brandt"
> <rickbrandt2@hotmail.com> wrote:
>[color=green]
>> gn wrote:[color=darkred]
>>> My tables are in a folder on the G drive on a local area network.
>>> The users have to have permission to go to this folder in order to
>>> use the
>>> application. Can I make it so they can only use the tables from the
>>> code in
>>> the application, without giving them permission to go directly to
>>> the folder
>>> and then get to the tables?[/color]
>>
>> Nope.
>>
>> You can hide the share on the LAN and then connect to the tables in
>> code using an MDE so the code cannot be examined. The users would
>> be hard pressed to even know where to look for the back end in that
>> scenario. However; if someone figured it out they would have full
>> access to the tables.
>>
>> If that is not acceptable then your data should not be stored in an
>> MDB file.[/color]
>
> Thank you. It is an MDE. I could give the folder a name that gives
> them no clue what is in it.[/color]

And as stated previously a network share can be hidden so that those who are
just "browsing around" won't even see it even though they have persmission to
use it.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

re: Security

On Sat, 8 Jan 2005 11:29:45 -0600, "Rick Brandt"
<rickbrandt2@hotmail.com> wrote:
[color=blue]
>gn wrote:[color=green]
>> On Fri, 7 Jan 2005 18:31:29 -0600, "Rick Brandt"
>> <rickbrandt2@hotmail.com> wrote:
>>[color=darkred]
>>> gn wrote:
>>>> My tables are in a folder on the G drive on a local area network.
>>>> The users have to have permission to go to this folder in order to
>>>> use the
>>>> application. Can I make it so they can only use the tables from the
>>>> code in
>>>> the application, without giving them permission to go directly to
>>>> the folder
>>>> and then get to the tables?
>>>
>>> Nope.
>>>
>>> You can hide the share on the LAN and then connect to the tables in
>>> code using an MDE so the code cannot be examined. The users would
>>> be hard pressed to even know where to look for the back end in that
>>> scenario. However; if someone figured it out they would have full
>>> access to the tables.
>>>
>>> If that is not acceptable then your data should not be stored in an
>>> MDB file.[/color]
>>
>> Thank you. It is an MDE. I could give the folder a name that gives
>> them no clue what is in it.[/color]
>
>And as stated previously a network share can be hidden so that those who are
>just "browsing around" won't even see it even though they have persmission to
>use it.[/color]

Great!