Connection Open Error 0x80040e4d when UID/PWD added?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Adding user level security to a working C++ db app. Added OK to Access. When
I add the user id and password to the connect string or to the connection
Open I get a 0x80040e4d (Security rights error).

_bstr_t bstConnect "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\Data.mdb;"
_bstr_t bstUID = L"Develop";
_bstr_t bstPWD = L"Test";
pConnection.CreateInstance(__uuidof(Connection));
pConnection->Open( bstConnect, bstUID, bstPWD,adOpenUnspecified));
All help appreciated.
.

Relevant Pages

  • Re: Different switchboards for different users?
    ... grabbing the Windows username. ... pulling data from, and it does indeed have a "Database" string in it, but I ... > Hi Chris, ... > assuming you are using Access user level security. ...
    (microsoft.public.access.setupconfig)
  • Re: Record level access
    ... Enable User Level Security, add appropriate users and groups, allow access to the data only through your forms (i.e. ... Function faq_IsUserInGroup (strGroup As String, ... Dim ws As WorkSpace ... Dim strUserName as string ...
    (microsoft.public.access.security)
  • RE: Connection Open Error 0x80040e4d when UID/PWD added?
    ... in it I noticed they were passing the path ... I think that while Access new of the System file, ... I composed the following connect string: ... > Adding user level security to a working C++ db app. ...
    (microsoft.public.data.ado)
  • RE: ADO Connection Open Err 0x80040e4d
    ... in it I noticed they were passing the path ... I think that while Access new of the System file, ... I composed the following connect string: ... > Adding user level security to a working C++ db app. ...
    (microsoft.public.vc.database)
  • ADO Connection Open Err 0x80040e4d
    ... Adding user level security to a working C++ db app. ... I add the user id and password to the connect string or to the connection ... pConnection->Open(bstConnect, bstUID, bstPWD,adOpenUnspecified)); ...
    (microsoft.public.vc.database)