By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,633 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,633 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.