Re: Accessing mdb file via VB code

Tech-Archive recommends: Fix windows errors by optimizing your registry


"Jeff Johnson" <i.get@xxxxxxxxxxx> wrote in message
news:%23vots6rnGHA.1664@xxxxxxxxxxxxxxxxxxxxxxx
"AK" <nospam@xxxxxxxxxxx> wrote in message
news:%23AWrUArnGHA.5056@xxxxxxxxxxxxxxxxxxxxxxx

I started by adding a password to my test DB by setting it by using
Tools|Security

Then I changed my Connection.Open Method statements to add the UserID
and
Passwords.

If all you did was add a "database password" then "User ID" (note the
space)
and "Password" are not the keywords you want; you want "JetOLEDB:Database
Password".


Doh!

By using UserID and Password in the connection string one is telling Jet
that you intend to invoke User-Level security, not Database security, but
the 'current' mdw doesn't support that request.

-ralph
[sometimes one can have too much coffee! <g>]


.

Relevant Pages

  • Re: VBA in Excel & ADO: some problems
    ... "Santiago" wrote: ... but what I mean is the userid and pass used in the Connection string ... Bregards ...
    (microsoft.public.excel.programming)
  • Dynamic loading of password in connection strings?
    ... and so far have used the wizard to generate ... connection strings to an Oracle database. ... In the wizard, the userid ... and password are hard coded into the connection string. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQL connection works in forms application, but not asp.net_
    ... It's the same connection string that worked for the windows forms. ... I tried entering the password and userid, which actually I don't have one ... because SQL Server is using Windows Authentication, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Force to provide db login even though already supplied
    ... I created a PivotChart that connects to an ODBC database using the ... following connection string: ... Even though I supply both the USERID and PASSWORD I still receive a ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SQL server does not exist or Access Denied
    ... actually this connection string dow not provide the UserId nor the ... pasword... ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)