Need help to secure non secured mdbs using VB Code/Script

[Diwakar]

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

 

[Keith Wilby]

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

 

[Albert D. Kallal]

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/AlbertKallal/msaccess/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/AlbertKallal/msaccess/msaccess.html

 

[Diwakar]

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.

 

[Keith Wilby]

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

 

[Diwakar]

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