"SammyBar" <sammy***@gmail.com> wrote in message
news:ul4sGg%23DHHA.4832@TK2MSFTNGP06.phx.gbl...
> 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
>
>