MS Access Connection Error

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hi,

I am getting the following connection error when trying to
retrieve data from the Northwind Access database:

"No error information available: DB_SEC_E_AUTH_FAILED
(0x80040E4D)."

I am logged in as Administrator in Windows XP and have
successfully tested the connection to the database when I
set its properties to use the MS Jet 4.0 OLE DB provider.
Any help? Thanks.

Paul
 
Connection string:
Dim strConnCustomer As String
= "Provider=Microsoft.Jet.OLEDB.4.0;Password=""; " & _
"User ID=Admin;Data Source=C:\Documents and
Settings\Paul\Desktop\My Folder\Visual
Studio .NET\Northwind\NorthWind.mdb; " & _
"Mode=Share Deny None;Extended Properties="";Jet
OLEDB:System database=""; " & _
"Jet OLEDB:Registry Path="";Jet OLEDB:Database
Password="";Jet OLEDB:Engine Type=5; " & _
"Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global
Partial Bulk Ops=2; " & _
"Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New
Database Password=""; " & _
"Jet OLEDB:Create System Database=False;Jet
OLEDB:Encrypt Database=False; " & _
"Jet OLEDB:Don't Copy Locale on Compact=False; " & _
"Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False"

I then set the connection object's connection string
property to my strConnCustomer and then try to open the
connection.
 
Hi,

I think your problem is with empty strings.
You set them as double quotation marks which VB interprets as single
quotation mark, example:
Password="";
VB sees like Password=";

Aynway, where there are empty strings just leave it empy and it should work:
Password=;
 
Back
Top