How to establish connection to Access DB ??

[Mischamel]

Moin,

I created an Asp Project, to show some rows in a datagrid or datalist.I Set the connection, oledbadapter and dataset in(from) the wizard or properties window. When I try to fill the ds, err msg occurs with: Db already exclusively opened or u need access key....

Do I have to set parameters in IIs config or set the Db in another path(now it´s in the inetpub folder) or are there any other recommendations in the connection settings or adapters config ???

 

[Robby]

While in Windows Explorer right-click on the mdb file and add ASPNET as a user in the security tab.

 

[Mischamel]

It doesn´t work. User ASPNET isn´t in Networkusergroup. Don´t know how to chose out of NW-Usergroup.

 

[Mischamel]

It doesn´t work. User ASPNET isn´t in Networkusergroup. Don´t know how to chose out of NW-Usergroup.

Wait. I could set ASPNet as user. Further results woll follow ........

 

[Mischamel]

Hou !!! Still the same errmsg, when I try to fill the DataSet of my DB. Can u give another advice ??

 

[Mischamel]

Another one out now ::

 

[Mischamel]

Another one out now ::
File Couldn´t be locked.

Err occurs when I try to fill my Dataset.

Getingnnuts.

 

[Robby]

Can you post your code. Also, are you using any wizards to setup your DB stuff?

 

[Mischamel]

Wizards as they are offered from developSoftw Vb.Net. Connection is set by wizard nad dataset, dataAdapter as well. Options like Datasource of the datagrid are set in property fields on the right side of vb.net. There´s no code to post, only :

Sub PageLoad() REM Or ButtonClick
OleDbDataAdapter1.Fill(DS,"TABLE") REM Here it offers errmsg.
DATABIND()