MS Access need to be installed on Remote server? When connect through VB.Net

[http://www.visual-basic-data-mining.net/forum]

Hi, I am new here. I am facing a problem that I can't connect to MS Access
with my Web application written in VB.Net.

It gives me this kind of error:
The Microsoft Jet database engine cannot open the file 'E:\DATA1.mdb'. It is
already opened exclusively by another user, or you need permission to view
its data.

I try to connect to the DATA1.mdb through server pool, the connection is
tested successfully, but I can't connect to it through the connection
string. I am currently using Win2k, the folder that contain DATA1.mdb is
already assigned Everyone "Full" permission.

My Connection String is such as below:
("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\DATA1.mdb;User
ID=Admin;Password=;")

Any helps will be much much more appreciated. :))

--
dragonist - forum member
http://www.visual-basic-data-mining.net/forum

[Ken Tucker [MVP]]

Hi,

It is a security issue. The framework has differnent security
settings for each zone. If you are in the internet zone you have less
access to the computers file system. Use code to open the database the
controls give you that error.

Ken
--------------
"http://www.visual-basic-data-mining.net/forum" <si******@gmail.com> wrote
in message news:%2****************@TK2MSFTNGP12.phx.gbl...
Hi, I am new here. I am facing a problem that I can't connect to MS Access
with my Web application written in VB.Net.

It gives me this kind of error:
The Microsoft Jet database engine cannot open the file 'E:\DATA1.mdb'. It is
already opened exclusively by another user, or you need permission to view
its data.

I try to connect to the DATA1.mdb through server pool, the connection is
tested successfully, but I can't connect to it through the connection
string. I am currently using Win2k, the folder that contain DATA1.mdb is
already assigned Everyone "Full" permission.

My Connection String is such as below:
("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\DATA1.mdb;User
ID=Admin;Password=;")

Any helps will be much much more appreciated. :))

--
dragonist - forum member
http://www.visual-basic-data-mining.net/forum