Password on front end prevents writing to back end mdb

W

Winshent

I have got both front and back end mdb's.

the backend is password protected and the linked tables have the
password set.

when i remove the password from the Front End... i have no problems
adding records to the Back End mdb. However, when i add a password to
the Front End, i get a 'password not valid error'.

This occurs when creating a new connection in my code:

############################################################
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
With cnn
.ConnectionString = CurrentProject.AccessConnection
.Open
End With
############################################################

Any ideas?
 
Top