access connection

[brenny]

Hello
I was using access 2000 database and it hasn't password protection.Now I'm
using access
2003 database and password(123456) in the same application.

I want to create dataadapter via wizard but after determining database jet
4.0 oledb and typing
password,I presses test connection,I'm getting an error message as "Test
connection failed because of
and error in initializing provider.Cannot start your application.The
workgroup information
file is missing or opened exclusively by another user"

I'm sure that Database is not opened by another user.



I try to make connection using connection string

connstr = "Data
Source=\"C:\\DB\\DB.mdb\";Provider=\"Microsoft.Jet.OLEDB.4.0\";User
ID=Admin;Password=\"123456\"";

This time,I'm getting an error message as "It isn't installable ISAM"

How can I solve this problem.


Thanks.

 

[Robert Bruce]

I try to make connection using connection string

connstr = "Data
Source=\"C:\\DB\\DB.mdb\";Provider=\"Microsoft.Jet.OLEDB.4.0\";User
ID=Admin;Password=\"123456\"";

Try a connectionstring where the password is passed in the extended Jet
info:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%path%;Persist Security
Info=False;Jet OLEDBatabase Password=%pwd%"


--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.

 

[brenny]

I tried you said but it doesn't accomplish connection.

I want to make connection via wizard.

I will be happy you help me.

 

[Robert Bruce]

I tried you said but it doesn't accomplish connection.

I want to make connection via wizard.

I will be happy you help me.

OK. First verify that you have an Access 2000 format database and that you
know the correct password.

Now, in the wizard, click the New Connection button. The standard data link
dialog will appear. Click the Providor tab and choose Microsoft Jet 4.0.

Click the connection tab. Select the access database disk file and delete
the Admin string from the User Name field. Don't uncheck the Blank Password
checkbox.

Click the All tab. Double-click the list item JetOleDBatabase Password and
enter the password. Go back to the connection tab to test the connection.

This works for me.