Security Question?

[Andrew]

I have a vb6 app that I use for a client to connect to a 2002 Access
Database. The Database only consists of tables, nothing more. I use this
string to connect using an Adodc1 control:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DP & ";Persist Security
Info=False"

I wanted to know how can I use that string above and connect to a database
that is using a group password with no user. The problem what I have trying
to connect is that it will not connect; the only thing I can think of is that
the string is trying to use a user.

Will that limit the number of connection using a group password? My app
connects to the database on multiple connections at once from server
workstations.

my other question is Can I encrypt the database and still be able to connect
with my vb6 app and work from the database like I would normally do when not
encrypted?

I just need to make the database as secure as possible It holds patient
records, but the database is never moved or transmitted anywhere, If I need
to transfer records, the vb6 app does that for me.

 

[Mike Labosh]

I have a vb6 app that I use for a client to connect to a 2002 Access

Database. The Database only consists of tables, nothing more. I use this
string to connect using an Adodc1 control:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DP & ";Persist Security
Info=False"

I wanted to know how can I use that string above and connect to a database
that is using a group password with no user.

This might work, but I think the OLEDB Provider might try to login to Access
"workgroup style" as if the database was secured using the "Users / Groups
security". I'm not sure how this will react if the database is just secured
with a simple "Database Password"

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DP & ";Persist Security
Info=False;User Id=Admin;Password=" & strPassword

Will that limit the number of connection using a group password? My app
connects to the database on multiple connections at once from server
workstations.

I don't think this will limit the number of connections.

my other question is Can I encrypt the database and still be able to
connect
with my vb6 app and work from the database like I would normally do when
not
encrypted?

Your VB 6 App will work just fine on an encrypted database. The OLEDB
Provider handles the encryption voodoo.