Accessing Access .mdb

[torg]

I`ve got the following code:

Public Class frmBudsjett
    Inherits System.Windows.Forms.Form

Dim OleDbConnection As OleDb.OleDbConnection

#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        This call is required by the Windows Form Designer.
        InitializeComponent()

Dim strConn As String
        strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Password="";User 
ID=Admin;Data Source=C:\Program 
Files\Account\account.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:Dont Copy Locale on Compact=False;Jet OLEDB:Compact 
Without Replica Repair=False;Jet OLEDB:SFP=False"

        OleDbConnection = New OleDb.OleDbConnection(strConn)
        OleDbConnection.Open()

When I`m running the program, I receive the following errormessage:

An unhandled exception of type System.Data.OleDb.OleDbException occurred in system.data.dll

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

What am I doing wrong?

 

[Nerseus]

Wow, do you need all those options in your Connection String? Try it with something simple like:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program
Files\Account\account.mdb

The default userid for Access is Admin, so you shouldnt have to specify it.

Also make sure that the database is not currently open in Access. If you database is password protected (the Admin user that is), make sure you specify the password.

-ner

 

[torg]

Thank you. That helped