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?
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?