HELP: ADO Connection String - User Level Security...
Check out this link:
http://www.able-consulting.com/ADO_Conn.htm
HTH,
Bob Barrows
Quote:
> PLEASE, PLEASE HELP................
> I have a database which I now require security.... (Logon using User
Level
> Security)...
> I've gone through the process following the wizard instructions....
> I have now found that the problem is a MODULE containing an ADO
connection.
> Could someone please point me in the right direction
> Database = C:\Database\aar\aardata.mdb
> Workgroup = C:\Database\aar\wd-aar.mdw
> I've created an account in the workgroup for the connection (do i need
> o?) - User = ADOCon Password = ADOCon
> --------------------------------------------------------------------------
--
> --
> My original connection string was as follows:
> connection.ConnectionString = "provider=microsoft.jet.oledb.4.0;data
> source=" & CurrentProject.FullName
> connection.Open
> With the above connection I get the "You do not have the necessary
> permissions to use the.... *.mdb object...."
> --------------------------------------------------------------------------
--
> ---
> I modified my module to read:
> connection.Open "provider=microsoft.jet.oledb.4.0;data source=" &
> CurrentProject.FullName & "Jet OLE DB:System Database =
> C:\Database\aar\wd-aar.mdw", "ADO.Con", "ADO.Con"
> I get "Cannot start your application. the Workgroup information file is
> missing or opened exclusively by another user"....
> --------------------------------------------------------------------------
--
> ----
> I've also tried the following to have the workgroup but no password....
> connection.Open "provider=microsoft.jet.oledb.4.0;data source=" &
> CurrentProject.FullName & "Jet OLE DB:System Database =
> C:\Database\aar\wd-aar.mdw"
> Error: "Not a valid file name"
> --------------------------------------------------------------------------
--
> ----
