Error 0x80040E4D when tryng to open an password protected Access database programmatically

[SammyBar]

Hi,

I'm trying the most basic visual basic 6 - access testing:
I protected the Access 2003 created database with a password. The password
was created at database level. I mean I don't use workgroup security nor
created users with different passwords. The only I made was at the menu
Tools/Security/Set database password establish a password.
I closed Access program. Now I try to open this database with a Visual Basic
6 program (Microsoft ActiveX Data Objects 2.8 Library) but I got the
following error:

Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing or
opened exclusively by another user.

My connection string is the following:
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Archivos
de programa\Access Manager\DB\prueba.mdb;"
conn.Open connectionString, "Admin", "password"

I assume the password set in Access is the Admin password.
Why the errors mentions a "workgroup information file" if I'm not using
workgroup level authentication?
Where is the error?

Thanks in advance
Sammy

 

[Dmitriy Antonov]

Hi,

I'm trying the most basic visual basic 6 - access testing:
I protected the Access 2003 created database with a password. The password
was created at database level. I mean I don't use workgroup security nor
created users with different passwords. The only I made was at the menu
Tools/Security/Set database password establish a password.
I closed Access program. Now I try to open this database with a Visual
Basic 6 program (Microsoft ActiveX Data Objects 2.8 Library) but I got the
following error:

Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing
or opened exclusively by another user.

My connection string is the following:
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Archivos de programa\Access Manager\DB\prueba.mdb;"
conn.Open connectionString, "Admin", "password"

I assume the password set in Access is the Admin password.
Why the errors mentions a "workgroup information file" if I'm not using
workgroup level authentication?
Where is the error?

Thanks in advance
Sammy

This is example from http://www.connectionstrings.com/ (in this case don't
use uid and pwd arguments of Open method):

....="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet
OLEDBatabase Password=MyDbPassword;"


Dmitriy.