Newbie Question - Database Connection

[Wizard]

Hi,

Hope your all well?

I have the following Connection String in my app:

Con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=J:\Excellence.Net\Passwords.mdb;Jet OLEDBatabase Password=280181;"

This works Fine, However when i try to create a data adapter in the
designer and select my Database in the Data Adapter Configuration Wizard, I
enter the Username and Password as Admin and 280181 it comes back and says
"Unable to connect to the Database. The Workgroup information file is
missing or opened Exclusivly by another user"

Its not in use tho.

I`ve also tryed with no Username and just the password in as 280181 but to
no avail.

Could somebody possibly shed any light on this?

Many Thanks
Wizard

 

[Darious Snell]

This might help

http://office.microsoft.com/en-us/assistance/HA010546941033.aspx

 

[Wizard]

Hi,

Many Thanks for the help, but unfortunatly it didn`t work

Any other Ideas?

Cheers
Si

 

[Darious Snell]

PS - I think the file is an MDW.
Put a copy of it out with your database.

Check this out too...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/odatanet2.asp

 

[Wizard]

Hi,

I`ve tryed putting my system.mwd in the same directory as my Database as
well but still to now avail, same error message, reading the link you sent
all i should have to do it run throught the wizard which should do it all.

Any Ideas?

Many Many Thanks
MCN

 

[Darious Snell]

In the second link, please note the change to the connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data " & _
"Source=C:\Databases\mymusic.mdb; " & _
"Jet OLEDB:System database=" & _
"C:\Databases\system.mdw; " & _
"User ID=UserX;Password=UserXPassword"I will caution you that working with access security
in a multi-user environment is not as easy as it may appear.You will have to
test,test,test to make sure that changing people's MDW doesn't lock them out of their
existingAccess databases. At this point, I have run out of suggestions other than to say