database security

Please help with Database connection. I am OK with VB but rather new to access database

I have an access2000 database Customer.mdb
I have set up a data environment as follows:
cn.ConnectionString = "Provider =Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\Customer.mdb"
I have set up a data environment as follows:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Sales\Customer.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False

Problem I want to protect the database with password protection but became unstuck.

I have added password raysales to the database and changed rhe connection string and do not have a problem with that
cn.ConnectionString = "Provider =Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\Customer.mdb;Password=raysales"

I need to changed the data environment but have no clue: Got as far as Connection1 data link properties adding
Username: Admin and Password: raysales with result =
test connection failed because of an error initializing provider. Cannot start your application. The workgroup file is missing is missing or opened exclusively by another user.

I have played around with users and groups but managed only to mess up the whole database. Lucky I made a backup first

I have only my project open. Database closed.

Hi RayComp, welcome to VBForums!

I think the problem may actually be the connection string, as Access actually adds a username of "admin" along with the database password. I think your connection string should be like this:

VB Code:

cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
     & "Data Source=" & App.Path & "\Customer.mdb;User Id=admin;Password=raysales;"

thanks will try

You could try something like this...

VB Code:

DataEnvironment1.Connection1.ConnectionString = "Your connection string"