To prevent copying the objects of the access database

[Nandini]

I have created one bibliographic database using Access 2003 in support of my
Ph D thesis. I have to send this for evluation during submission of the
thesis. So I need to provide ultimate security to the database. For this
purpose I want to prevent any mode of copying the objects of the database.
Even I dont want to show the database window as I designed start up form.
What should I do.
With best regards,

 

[Tom van Stiphout]

On Sat, 6 Dec 2008 04:31:00 -0800, Nandini

Workgroup security is one of the very few options. It is one of the
most advanced topics of Access programming, and you should first
download, study, and fully understand the Security FAQ from
microsoft.com.
Or you should decide you can afford to freely share your wisdom with
the world. Isn't that the point of science?

-Tom.
Microsoft Access MVP

 

[CorporateQAinTX]

What about using /runtime access?
Check out this link: http://msdn.microsoft.com/en-us/library/aa167800.aspx

I've even setup a combination runtime and workgroup line in a shortcut to my
dbase to allow for security and to prevent people from doing anything except
what I show/allow them to.

By the way, I agree on the freedom of wisdom, but I also understand the PhD
Thesis part as well. Unfortunately, we do have people in this world who don't
know how to give credit when using someone else's wisdom. Good luck on the
thesis.

 

[CorporateQAinTX]

I almost forgot. Definately make sure you keep a copy of your db somewhere
safe without any of the securities on it. I thought I could get away without
doing that and it cost me over a 3 month's worth of work when I couldn't
access the db because I forgot my password a month later.

 

[Douglas J. Steele]

SInce that makes no change whatsoever to the database itself, using /runtime
in the shortcut really does nothing, since they can always open the
application without your shortcut.

Any protection you're getting is due only to your use of a workgroup, which
implies that you have implemented User-Level Security.