access connectionss

[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.

 

[MacDermott]

Are you using a login and password, or just a password?

 

[brenny]

I didn't enter any user ID,only I defined a password from access database.

I will be happy if you help me.

I want to make connection via wizard,not connection string.

 

[MacDermott]

Take a look at this site:
http://www.johnsmiley.com/cis18.notfree/smiley002/smiley002.htm.

I'm not sure what you're using to connect to this database, but the
information in this article should be enough to show you the syntax you'll
need.

HTH