"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
Go Back  Xtreme Visual Basic Talk > > > "The Microsoft Jet database engine cannot open the file .mdb"


Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2013, 04:11 PM
bonedoc bonedoc is offline
Junior Contributor
 
Join Date: Mar 2006
Posts: 376
Default "The Microsoft Jet database engine cannot open the file .mdb"


Im having a heck of a problem figuring this one out.

9 years ago, I wrote some software for an XP computer and the software was linked to an access database. I recently re-wrote the program for use on my windows 7 computer. It is working great, but I have an issue....

I want to run the software on my network and have access to the database on my main computer at my front desk. This worked flawlessly on the previous XP network. However, I tried to do this today, and I am getting an error. When I try to connect to the access database I get the error:

"The Microsoft Jet database engine cannot open the file '\\Cube-pc\pmt\Data\PMT.mdb'. It is already opened exclusively by another user, or you need permission to view its data."

I dont understand why I could connect just fine on the old XP system, but I cant now. Here is my connection string:

Code:
  Dim NewConnectionString As String

        NewConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=""pmtchiro"";User ID=Admin;Data Source="
        NewConnectionString += m_TextBoxDatabasePath.Text.ToString()
        NewConnectionString += ";Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="
        NewConnectionString += """"";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password=""pmtchiro"";"
        NewConnectionString += "Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;"
        NewConnectionString += "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;"
        NewConnectionString += "Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;"
        NewConnectionString += "Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;"
        NewConnectionString += "Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False"

        Try
            Dim DatabaseConnection As New OleDb.OleDbConnection
            Dim OfficeCommandBuilder As New OleDb.OleDbCommandBuilder

            DatabaseConnection.ConnectionString = NewConnectionString
            DatabaseConnection.Open()
One thing I can tell, when I opened the database on the xp system, a .LDB would appear on the main computer. I dont know why, but this is not happening now.

Any heap appreciated! I need this up an running asap!
Reply With Quote
  #2  
Old 06-15-2013, 11:14 AM
OPPB OPPB is offline
Newcomer
 
Join Date: Jan 2013
Posts: 3
Default

Hi benedoc,
this way you just need if you use an access file up to 2007.
change your string to "Provider=Microsoft.ACE.OLEDB.12.0;" &
'"Data Source=D:\Database.accdb;""

but watch that perhaps your win7 does not have "wdac"(thats what has came after mdac)

If its still xp or 2003, it shall be enought to make a change within your "konfiguration manager" to x86.
I just have a german enviroment,so I can not give a descrption with same words as you have.
Open VS
call the fourth menueicon (beside project)
the last option shal be "konfiguration manager"
there you will find the option to change
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb" "The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
 
"The Microsoft Jet database engine cannot open the file .mdb"
"The Microsoft Jet database engine cannot open the file .mdb"
 
-->