Database Password

[scasystems]

Problem I have is I wish to secure both the frontend/backend databases with a database password.
This enables me to open them using VB6 and not let the users mess around with the tables queries.
Problem I have is that all reports are done via activex access. i.e
access.opencurrentdatabase xxxx
access.openreport xxxx

there is no way of passing the database password, so the login box comes up defeating the main reason for protecting the database by password.
Any suggestions (do not really want to use userlevel security)

Also I have designed an ado class which when passed database location/dsn name will open a connection.
So that I can use the same connection to open diffrent recordsets.
One problem I do get is when I pass a database location I use dataprovider jet.4.
But when I try to open another connection using the database location I get workgroup file is missing or opened exlusively. Any suggestions.

 

[scasystems]

Sorted the ado class out. When testing database passwords,
I had left in username, password defaults of the database password and not admin.