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

From: http://www.visual-basic-data-mining.net/forum (simiking_at_gmail.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 04:32:53 -0700

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

Relevant Pages

  • Multiple Connection Strings for Multiple Dlls
    ... I am facing a small problem. ... Actually i have a solution having around 5 Dll Projects. ... i have to add all the COnnection string into the exeprojects app.config. ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Access database wont open
    ... >I have created a database connection to an access database in my web ... or you need permission to view its data. ... > System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ... >Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.faqs)
  • Re: Complicated Connection Problems bewteen ADP and SQL Server
    ... front end on the 5-8 workstations where the users happen to sit. ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... thought that I should instead change my connection string to something ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Fujitsu NetCobol 8.0
    ... You cannot use a connection string in the way you have shown and expect it ... Any Fujitsu NetCobol / PowerCobol users here? ... Use the ADO control provided in PowerCOBOL, ...
    (comp.lang.cobol)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... Also see http://www.connectionstrings.com/ and try other providers ... > Here is some of my connection code: ... >> And are you sure your connection string is ok. ... >>> Oracle error occurred, but error message could not be retrieved from ...
    (microsoft.public.dotnet.framework.aspnet)