By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,218 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,218 IT Pros & Developers. It's quick & easy.

How To Create Login Password Protected Database

P: n/a
Hello again,

I have to go home and read up on Access.

But, I have read else-where in this newsgroup that I can just save the
password in the database under scrutiny.

Wouldn't it be wasteful to create a password column for all database
entries?

E.G.:

Entry 1: password field1 ... fieldn
....
Entry M:password field1 ... fieldn

Note: For security reasons (unless I have to), I do not want to
hardcode passwords in VB 8, or save encryted passwords in a text file..

Thanks,
Christopher Lusardi

May 2 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Access supports workgroup security files. This allows you to create users,
groups and assign security to the database objects even at the field level.
Once the workgroup file is setup, you can then provide a simple interface in
your application to prompt the user for the login information. The security
will be much like that of SQL or Oracle once implemented.

Have a look at
http://office.microsoft.com/en-us/as...704101033.aspx
<cl********@aol.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...
Hello again,

I have to go home and read up on Access.

But, I have read else-where in this newsgroup that I can just save the
password in the database under scrutiny.

Wouldn't it be wasteful to create a password column for all database
entries?

E.G.:

Entry 1: password field1 ... fieldn
...
Entry M:password field1 ... fieldn

Note: For security reasons (unless I have to), I do not want to
hardcode passwords in VB 8, or save encryted passwords in a text file..

Thanks,
Christopher Lusardi

May 2 '06 #2

P: n/a
IMHO, the security on Access is very weak because the security file can be
deleted and the database can be exposed to anyone.

"AMDRIT" wrote:
Access supports workgroup security files. This allows you to create users,
groups and assign security to the database objects even at the field level.
Once the workgroup file is setup, you can then provide a simple interface in
your application to prompt the user for the login information. The security
will be much like that of SQL or Oracle once implemented.

Have a look at
http://office.microsoft.com/en-us/as...704101033.aspx
<cl********@aol.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...
Hello again,

I have to go home and read up on Access.

But, I have read else-where in this newsgroup that I can just save the
password in the database under scrutiny.

Wouldn't it be wasteful to create a password column for all database
entries?

E.G.:

Entry 1: password field1 ... fieldn
...
Entry M:password field1 ... fieldn

Note: For security reasons (unless I have to), I do not want to
hardcode passwords in VB 8, or save encryted passwords in a text file..

Thanks,
Christopher Lusardi


May 2 '06 #3

P: n/a

AverageUser wrote:
IMHO, the security on Access is very weak because the security file can be
deleted and the database can be exposed to anyone.


What can I do about this? If I throw away VB and use Access directly
would that be better, or should I use something such as Oracle?

Thank you,
Christopher Lusardi

May 3 '06 #4

P: n/a
Every lock has a lockpick. Access' security file is good enough. LAN
deployments are reasonably safe, just like pending deposits your accountants
manage. It would be more secure than a CSV file. If you are that concerned
about the security, create a webservice or remoting service and put the
server in a NOC, or move to a major RDBMS.

I don't think that security should be the main focus with Access. Rather,
file locks on Novell servers, or data contention and disaster recovery
should be the main focus.

More about that security file. If you attempt to open the MDB without the
security file, you will recieve an error. The only way I suppose you could
bypass the security file, is to modify the header of the database itself.
Absense of the security file is the same as absense of your key on the way
back from vacation; there may be another way in, most people wont try it.

"AverageUser" <Av*********@discussions.microsoft.com> wrote in message
news:29**********************************@microsof t.com...
IMHO, the security on Access is very weak because the security file can be
deleted and the database can be exposed to anyone.

"AMDRIT" wrote:
Access supports workgroup security files. This allows you to create
users,
groups and assign security to the database objects even at the field
level.
Once the workgroup file is setup, you can then provide a simple interface
in
your application to prompt the user for the login information. The
security
will be much like that of SQL or Oracle once implemented.

Have a look at
http://office.microsoft.com/en-us/as...704101033.aspx
<cl********@aol.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...
> Hello again,
>
> I have to go home and read up on Access.
>
> But, I have read else-where in this newsgroup that I can just save the
> password in the database under scrutiny.
>
> Wouldn't it be wasteful to create a password column for all database
> entries?
>
> E.G.:
>
> Entry 1: password field1 ... fieldn
> ...
> Entry M:password field1 ... fieldn
>
> Note: For security reasons (unless I have to), I do not want to
> hardcode passwords in VB 8, or save encryted passwords in a text file..
>
> Thanks,
> Christopher Lusardi
>


May 3 '06 #5

P: n/a
I think I'll store hashed passwords in a database and keep a backup of
the database.

Chris

May 3 '06 #6

P: n/a
What is it that you want to protect, really, and from whom?

cl********@aol.com wrote:
Hello again,

I have to go home and read up on Access.

But, I have read else-where in this newsgroup that I can just save the
password in the database under scrutiny.

Wouldn't it be wasteful to create a password column for all database
entries?

E.G.:

Entry 1: password field1 ... fieldn
...
Entry M:password field1 ... fieldn

Note: For security reasons (unless I have to), I do not want to
hardcode passwords in VB 8, or save encryted passwords in a text file..

Thanks,
Christopher Lusardi

May 3 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.