Database connection error

[Nascimento, Daniel]

i tried to create a conecction to a database MSAccess 2002 with Microsoft JET
4.0 OLE Provider but it gives me the error:

'Teste connection failed because of an error in initializating provider.
cannot start your application.
the workgroup information file is missing or opened exclusively by another
user.'

how can i fix this problem???

[Peter van der Goes]

<Nascimento>; "Daniel" <Nascimento, Da****@discussions.microsoft.com> wrote
in message news:A5**********************************@microsof t.com...

i tried to create a conecction to a database MSAccess 2002 with Microsoft JET 4.0 OLE Provider but it gives me the error:

'Teste connection failed because of an error in initializating provider.
cannot start your application.
the workgroup information file is missing or opened exclusively by another
user.'

how can i fix this problem???

The Access database you are trying to connect to has been secured (user
level security) with a Workgroup Information File (WIF), which now
effectively "owns" the database. You'll need to get with the person who
created the WIF to see what user name and password you can use to connect.
You'll also need the name and location of the .mdw file.

--
Peter [MVP Visual Developer]
Jack of all trades, master of none.

[Nascimento, Daniel]

Thanks Peter van der Goes.

It was me who created the Access database.
The location is z:\bd.mdb.
i also associated the file Z:\bd-user.mdb to the database.
is the WIF the z:\bd-user.mdb file???
if not, where i can get it?

i tried to create a database conection:

Tools -> Connect to Datbase...

->...>>Provider (Microsoft JET 4.0 OLE Provider)
->...>>Connection
..........1.Databasename(Z:\bd-user.mdb)
..........2.Information to log on
............user(admin)
............password(pass)

when i test the connection it still gives me the same error...
what's wrong??

[Peter van der Goes]

<Nascimento>; "Daniel" <Na**************@discussions.microsoft.com> wrote in
message news:2C**********************************@microsof t.com...

Thanks Peter van der Goes.

It was me who created the Access database.
The location is z:\bd.mdb.
i also associated the file Z:\bd-user.mdb to the database.
is the WIF the z:\bd-user.mdb file???
if not, where i can get it?

i tried to create a database conection:

Tools -> Connect to Datbase...

->...>>Provider (Microsoft JET 4.0 OLE Provider)
->...>>Connection
.........1.Databasename(Z:\bd-user.mdb)
.........2.Information to log on
...........user(admin)
...........password(pass)

when i test the connection it still gives me the same error...
what's wrong??

When you used the Security Wizard, you created a file with the extension
..mdw. The default name would have been Security.mdw. You were given the
opportunity to designate the storage location for the file, so if you don't
know where it is, you'll need to search for it. This is the file that now
"owns" your database. When you set up user-level security, the wizard
created a report for you which included information on established user
groups, users and passwords and group membership. You were advised to both
print the report and to save a copy for future reference. You're going to
need the content to solve your issues.
I'd also suggest that you pursue resolution to your problem in the:

microsoft.public.access

newsgroup, as the problems you're now encountering have to do with Access
and user level security more than with .NET. You may end up having to create
a new version of your database *not* tied to user level security by logging
into the database as an admin, creating a second database object, then
copying all existing objects in the current database to the new database
object, thus creating a new version with no user-level security applied.

--
Peter [MVP Visual Developer]
Jack of all trades, master of none.