Hi All,
I need your suggestion in the following problem:
We have some non-secured access 97 MDB files. It is circulated over remote
locations so we can not replace it going physically everywhere. So solutions
is to create a small utility to secure all non secured files. We are using
system.mda file as a workgroup security file. Please suggest how can we use
VB or any other tool to secure the access 97 non-secure files.

Waiting for positive reply and suggestions.

Thanks & Regards,
Diwakar

"Diwakar" <(E-Mail Removed)> wrote in message
news:FE28681F-91F8-47E5-9EB7-(E-Mail Removed)...
> Hi All,
> I need your suggestion in the following problem:
> We have some non-secured access 97 MDB files. It is circulated over remote
> locations so we can not replace it going physically everywhere. So
> solutions
> is to create a small utility to secure all non secured files. We are using
> system.mda file as a workgroup security file. Please suggest how can we
> use
> VB or any other tool to secure the access 97 non-secure files.
>

I'm not aware of any method to batch secure Access files using code. It can
be a fraught enough process to do it manually. Even if you could do it by
code I'm not sure how you'd achieve it because the different files would
contain different objects.

Regards,
Keith.
www.keithwilby.com

Do you actually need security, or is just hiding the access interface
sufficient?
(in other words, do you just want to keep users out of the design parts???).

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:
http://www.members.shaw.ca/AlbertKal.../msaccess.html


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

Thanks Albert for your suggestions.
I need to secure MDBs by setting up workgroup security which is missing for
some files.Disabling only the interface will not work.
Please suggest if you have some ideas for the same.

"Albert D. Kallal" wrote:

> Do you actually need security, or is just hiding the access interface
> sufficient?
> (in other words, do you just want to keep users out of the design parts???).
>
> You most certainly can, and should hide all of the ms-access interface. The
> options to complete hide and keep people out of the ms-access interface can
> easily be done using the tools->start-up options. Using those options allows
> you to complete hide the ms-access interface (tool bars, database window
> etc). Also, using these options means you
> do not have to bother setting up security.
>
> Try downloading and running the 3rd example at my following web site that
> shows a hidden ms-access interface, and NO CODE is required to do
> this....but just some settings in the start-up.
>
> Check out:
>
> http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm
>
> After you try the application, you can exit, and then re-load the
> application, but hold down the shift key to by-pass the start-up options. If
> want, you can even disable the shift key by pass. I have a sample mdb file
> that will let you "set" the shift key bypass on any application you want.
> You can get this at:
> http://www.members.shaw.ca/AlbertKal.../msaccess.html
>
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> (E-Mail Removed)
>
>
>

"Diwakar" <(E-Mail Removed)> wrote in message
news:3F8E9313-140A-401E-A67D-(E-Mail Removed)...
>
> I need to secure MDBs by setting up workgroup security which is missing
> for
> some files.

If setting up user-level security is you aim then the FAQ is your friend.
There's a link to it on my web site but be aware that there's no filler in
the document and that you need to follow all of the steps in the order
stated.

Regards,
Keith.
www.keithwilby.com

Hi Keith,

The suggestion was good. but still we have not found any direct method for
securing MDBs which are left out.

Could someoneyou guide me to some code snippet to secure an MDB in
workgoroup security environment supposing 10 files out of 15 are secured and
working fine and we need to secured rest 5 files only within the same
environment .

Thanks & Regards,
Diwakar

"Keith Wilby" wrote:

> "Diwakar" <(E-Mail Removed)> wrote in message
> news:3F8E9313-140A-401E-A67D-(E-Mail Removed)...
> >
> > I need to secure MDBs by setting up workgroup security which is missing
> > for
> > some files.
>
> If setting up user-level security is you aim then the FAQ is your friend.
> There's a link to it on my web site but be aware that there's no filler in
> the document and that you need to follow all of the steps in the order
> stated.
>
> Regards,
> Keith.
> www.keithwilby.com
>
>