local ACCESS db connection

From: JerryScott (JerryScott_at_discussions.microsoft.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 08:25:05 -0700

I posted this elsewhere but this seems to be more approapriate.
I have a webserver running 2000 Advanced Server and SQL 7 Server. These work
fine, but I need to connect to an ACCESS database on my desktop using an ASP
page. The path to the local database is: "C:\Program
Files\NEAT\Data\dbSPAM3000.mdb".
I put that in:
  dbPath = "C:\Program Files\NEAT\data\dbSPAM3000.mdb"
  Set cnl = Server.CreateObject("ADODB.Connection")
  cnl.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath

but it tells me that path doesn't exist. I have added the "\\" to the front
of the path like we "used" to have to do for local paths, still doesn't work.

It seems it is opening that path on the Server, NOT on my local desktop.
This database was created with a Visual Basic application and works fine,
BUT, I need this functionallity from an ASP page on my webserver and NOT
having any luck.
Thanks.

Relevant Pages

  • Re: Remote data entry solution needed for Access 2007
    ... Users open the database remotely and use its forms to enter data. ... Why it doesn't work: network lag time. ... our network admin says our Citrix server is 2000 and ... HTML-based form working with an ASP file to send data to the database. ...
    (microsoft.public.access.externaldata)
  • Re: Using Access 2000 w/FP2003 w/XP Home Edition
    ... > via my IE browser to add test data to a database, ... That's because ASP pages/code need to 'served" from a server to work. ... >> Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.programming)
  • Re: ASP and Access Database queries
    ... http://www.bellfield-barna.com/ is running on an Apache server running ... which doesn't support ASP and Access. ... My Access database is situated in my office. ... I have an Access database where I would like ...
    (microsoft.public.frontpage.programming)
  • Re: Database Connection/ Results not working
    ... After you have created your database connection and renamed your page to .asp, ... You can not test any thing under Windows XP Home ... that requires a MS Web server, ...
    (microsoft.public.frontpage.client)
  • Re: how to solve this?
    ... >Each procedure needs to access the database with parameters (e.g. ... >What i miss is a way to switch between ASP with the database and VB with the ... It is processed on the server. ... and processed on the client. ...
    (microsoft.public.inetserver.asp.db)