Greetings All,
I am having a problem with my Connection string and I am fresh out of ideas.
I have a front end and back end database.  My tables are linked in the front
end but when I execute my connection I get the following error:

[Microsoft][ODBC Driver Manager] Data source can not be found and no default
driver specified.

The back end is a MS Jet 4.0 database.  Originally the database was not
split and it was working fine.  Once I split it and enabled security, this
problem occurred.  

My connection proc looks like this:

Dim OConn As ADODB.Connection
Set OConn = New ADODB.Connection

OConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=C:\Documents and Settings\Owner\My
Documents\DTS\DPD\ClientDB\ClientDBBE.mdb;" & _
          "Jet OLEDB:System Database=C:\Documents and
Settings\Owner\Application Data\Microsoft\Access\ClientSharedSystem.mdw;" & _
          UserID = "Debbie", Password = "3119"

In the module, the Data Source Jet OLEDB statements fit all on one line.

I double checked both path statements, database name, workgroup file name,
libraries and permissions and ownership.  I cannot figure out if this is a
connection error or a security error.   Does anyone have any ideas?  Thank
you so much.
Debbie