Password protecting database

26 Nov 2007 6:11 PM

Lorraine R

In Excel you can attach a password to the spreadsheet. How do I secure my
database in Access 2000? I have a "huge" database containing all the user
login information, etc. There are a select few who will be responsible for
updates, etc.
How do I put a password on the database?

Thanks,
Lorraine

--
Financial Analyst
Healthcare Industry

26 Nov 2007 7:30 PM

Jerry Whittle

You can password protect the database by first opening it exclusively. To do
this open up Access by itself then find the database that you want to
password protect. There should be a dropdown next to the Open button on the
Open dialog box. Exclusive should be an option.

Once open go to Tools, Security, Set Database Password. At least that's
where it's at in Access 2003.

However it sounds like you don't want password security for the entire
database. If different people can do different tasks, you need User Level
Security which is a major undertaking. If that's what you need, you might
want to check out:
http://support.microsoft.com/kb/254372/en-us

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Show quote

"Lorraine R" wrote:

> In Excel you can attach a password to the spreadsheet. How do I secure my
> database in Access 2000? I have a "huge" database containing all the user
> login information, etc. There are a select few who will be responsible for
> updates, etc.
> How do I put a password on the database?
>
> Thanks,
> Lorraine
> --
> Financial Analyst
> Healthcare Industry
>

26 Nov 2007 7:56 PM

Lorraine R

Jerry,
I got to the part where I'm supposed to see an "exclusive" drop down option.
Not there. I don't have a drop down associated to OPEN. What do I try next?

--
Financial Analyst
Healthcare Industry

Show quote

"Jerry Whittle" wrote:

> You can password protect the database by first opening it exclusively. To do
> this open up Access by itself then find the database that you want to
> password protect. There should be a dropdown next to the Open button on the
> Open dialog box. Exclusive should be an option.
>
> Once open go to Tools, Security, Set Database Password. At least that's
> where it's at in Access 2003.
>
> However it sounds like you don't want password security for the entire
> database. If different people can do different tasks, you need User Level
> Security which is a major undertaking. If that's what you need, you might
> want to check out:
> http://support.microsoft.com/kb/254372/en-us
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Lorraine R" wrote:
>
> > In Excel you can attach a password to the spreadsheet. How do I secure my
> > database in Access 2000? I have a "huge" database containing all the user
> > login information, etc. There are a select few who will be responsible for
> > updates, etc.
> > How do I put a password on the database?
> >
> > Thanks,
> > Lorraine
> > --
> > Financial Analyst
> > Healthcare Industry
> >

26 Nov 2007 8:25 PM

John Spencer

Did you open Access Application and NOT your database?
-- Select File: Open from the menu
-- Navigate to your database and select it
-- CLICK on the down arrow on the OPEN Button
-- Select Open Exclusive from the list of choices

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Show quote

"Lorraine R" <Lorrai***@discussions.microsoft.com> wrote in message
news:B1FA43C4-6F89-4E0A-98A8-67F737467369@microsoft.com...
> Jerry,
> I got to the part where I'm supposed to see an "exclusive" drop down
> option.
> Not there. I don't have a drop down associated to OPEN. What do I try
> next?
> --
> Financial Analyst
> Healthcare Industry
>
>
>
> "Jerry Whittle" wrote:
>
>> You can password protect the database by first opening it exclusively. To
>> do
>> this open up Access by itself then find the database that you want to
>> password protect. There should be a dropdown next to the Open button on
>> the
>> Open dialog box. Exclusive should be an option.
>>
>> Once open go to Tools, Security, Set Database Password. At least that's
>> where it's at in Access 2003.
>>
>> However it sounds like you don't want password security for the entire
>> database. If different people can do different tasks, you need User Level
>> Security which is a major undertaking. If that's what you need, you might
>> want to check out:
>> http://support.microsoft.com/kb/254372/en-us
>> --
>> Jerry Whittle, Microsoft Access MVP
>> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>>
>>
>> "Lorraine R" wrote:
>>
>> > In Excel you can attach a password to the spreadsheet. How do I secure
>> > my
>> > database in Access 2000? I have a "huge" database containing all the
>> > user
>> > login information, etc. There are a select few who will be responsible
>> > for
>> > updates, etc.
>> > How do I put a password on the database?
>> >
>> > Thanks,
>> > Lorraine
>> > --
>> > Financial Analyst
>> > Healthcare Industry
>> >

26 Nov 2007 9:09 PM

John W. Vinson

On Mon, 26 Nov 2007 10:11:00 -0800, Lorraine R
<Lorrai***@discussions.microsoft.com> wrote:

>In Excel you can attach a password to the spreadsheet. How do I secure my
>database in Access 2000? I have a "huge" database containing all the user
>login information, etc. There are a select few who will be responsible for
>updates, etc.
>How do I put a password on the database?

Tools... Security... Set Database Password.

*but*... this is about as secure as a $8.95 bicycle lock. There are hacks
readily available on the net to read the password.

If you want a higher level of security use Access workgroup security: download
the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

It applies to versions up through 2003; Microsoft chose to remove it from 2007

:-{(.

Print out the FAQ. Read it carefully. Get a good night's sleep. Read it again,
even more carefully! Follow the instructions scrupulously; it's complex and
easy to do wrong.

If there is a business-critical need for security and you need to protect the
data from skilled and determined people, no file server solution is very safe;
workgroup security can be cracked too. Putting the data in a client-server
database such as SQL/Server is much more robust; you can still use Access as
your frontend.

John W. Vinson [MVP]