Home All Groups Group Topic Archive Search About

To prevent copying the objects of the access database

Author
6 Dec 2008 12:31 PM
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,
--
nandini

Author
6 Dec 2008 5:02 PM
Tom van Stiphout
On Sat, 6 Dec 2008 04:31:00 -0800, Nandini
<Nand***@discussions.microsoft.com> wrote:

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


Show quoteHide quote
>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,
Author
10 Dec 2008 5:15 PM
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.

Show quoteHide quote
"Tom van Stiphout" wrote:

> On Sat, 6 Dec 2008 04:31:00 -0800, Nandini
> <Nand***@discussions.microsoft.com> wrote:
>
> 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
>
>
> >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,
>
Author
11 Dec 2008 1:35 AM
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


Show quoteHide quote
"CorporateQAinTX" <CorporateQAi***@discussions.microsoft.com> wrote in
message news:FFD98A20-8CDC-4455-B19C-7CB8F9F1DF99@microsoft.com...
> 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.
>
> "Tom van Stiphout" wrote:
>
>> On Sat, 6 Dec 2008 04:31:00 -0800, Nandini
>> <Nand***@discussions.microsoft.com> wrote:
>>
>> 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
>>
>>
>> >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,
>>
Author
10 Dec 2008 5:19 PM
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.

Show quoteHide quote
"Nandini" wrote:

> 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,
> --
> nandini