Database connection error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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???
Click to expand...
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.
 
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??
 
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??
Click to expand...

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.
 
Back
Top