Protect Access database in a Network

6 Dec 2006 3:43 PM

JKumar

Hello,

In my vb6 program client computer need to map the C: drive of the server
with a drive letter to get connected to an "Access DB" in the server(Created
with Visdata) and that way run the client version of the program in client
computers.And It is running fine.But this way anyone sitting in a client
machine has easy access to the program's database(an Access DB) in the server
and can easily delete the

database.So how can I be able to protect the databse in the server please
advice.

6 Dec 2006 6:29 PM

Joan Wild

You do not need to use a mapped drive to connect to the mdb on the server -
use UNC instead.

e.g. \\servername\share\path\something.mdb

You can put the mdb in a hidden share on the server - that way users can't
get to it (easily) via Windows Explorer.

To hide a share:
\\servername\share$ rather than \\servername\share

You can put additional roadblocks in the backend, in case they find it. For
example create an autoexec macro that throws up a message (Msgbox action),
followed by the Quit action.

You could also disable the shiftkey bypass in the backend to prevent
bypassing the autoexec macro.

--
Joan Wild
Microsoft Access MVP

JKumar wrote:

Show quoteHide quote

> Hello,
>
> In my vb6 program client computer need to map the C: drive of the
> server with a drive letter to get connected to an "Access DB" in the
> server(Created with Visdata) and that way run the client version of
> the program in client computers.And It is running fine.But this way
> anyone sitting in a client machine has easy access to the program's
> database(an Access DB) in the server and can easily delete the
>
> database.So how can I be able to protect the databse in the server
> please advice.

20 Dec 2006 7:15 AM

JKumar

Thank you Joan.
Your suggestion had solved my problem.Thank you once again.
JKumar

Show quoteHide quote

"Joan Wild" wrote:

> You do not need to use a mapped drive to connect to the mdb on the server -
> use UNC instead.
>
> e.g. \\servername\share\path\something.mdb
>
> You can put the mdb in a hidden share on the server - that way users can't
> get to it (easily) via Windows Explorer.
>
> To hide a share:
> \\servername\share$ rather than \\servername\share
>
> You can put additional roadblocks in the backend, in case they find it. For
> example create an autoexec macro that throws up a message (Msgbox action),
> followed by the Quit action.
>
> You could also disable the shiftkey bypass in the backend to prevent
> bypassing the autoexec macro.
>
> --
> Joan Wild
> Microsoft Access MVP
>
> JKumar wrote:
> > Hello,
> >
> > In my vb6 program client computer need to map the C: drive of the
> > server with a drive letter to get connected to an "Access DB" in the
> > server(Created with Visdata) and that way run the client version of
> > the program in client computers.And It is running fine.But this way
> > anyone sitting in a client machine has easy access to the program's
> > database(an Access DB) in the server and can easily delete the
> >
> > database.So how can I be able to protect the databse in the server
> > please advice.
>
>
>

10 Mar 2007 6:35 PM

CarlG

Sorry,
it seems you have done something I am asking help for. I would like to run
my vb5 programme on a network.

I am just wondering whether you be so nice to tell me how to do that?

I know you did it on vb6 but that should be the same.

The programme now run separately on each client. I don't know anything so I
would be grateful if you could tell me what to do, every single step.

The proglem is: I have this programme and I want to run it on a network.
Which are my moves?