Re: Cannot Open Access File

"Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> wrote in message news:O%23m1DEzwHHA.3684@xxxxxxxxxxxxxxxxxxxxxxx

!> DBConnection = New OledbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=Acc.mdb"

That connection assumes the mdb file is located in the c:\windows\system32\inetsrv directory.

Indeed.

An OledbConnection expects a complete physical directory path,
if the path is ,ocated outside the website's directory path :

Quite so.

Btw, Acc.mdb should *never* be placed anywhere but in the App_Data directory.
As long as the mdb is in the App_Data dir, it cannot be downloaded via a direct link.

Definitely.


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

.

Relevant Pages

  • Perplexing connection problem - Win2K ASP/Jet DB
    ... I am experiencing a problem with connecting to a MS Jet database (Access 97 ... The connection cannot be used to perform this operation. ... the asp page page will do its data processing successfully, ... with each accessing their own respective mdb file. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Client PC losing database connection - problem with mdb files
    ... I'd upgrade the Access MDB file to SQL Server 2005 Express so you can take ... network connection icon in XP still shows everything as connected. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server BE behind firewall
    ... a MDB file with VBA code and ADO objects or an ADP ... ADO is not able to open an ODBC ... > connection directly and you will have to use the Microsoft OLEDB Provider ... > simply to use the native OLEDB provider for SQL-Server instead. ...
    (microsoft.public.access.formscoding)
  • Re: Append Query Question
    ... connection to the current database with CurrentProject.Connection. ... Check Access VB Help on the Connection Property of CurrentProject. ... > never done it within an Access module. ... > data to the MDB file from within a module of the MDB file, ...
    (microsoft.public.access.gettingstarted)
  • Accessing .mdb data from a remote computer on a non asp application
    ... have fount which fits to my application is changing the connection ... ("noa-second" is the machine where the MDB file is located) ... when I use the second one (with the remote) I get the error: ... adding http:// to the Remote Server sends error "count not connect to ...
    (comp.databases.ms-access)
Loading