Difficuly with database access using IIS

[AN]

I am using Access 2002, OWC 10. I have created a web application using
access. If I directly open the html file and NOT use IIS then I can set my
connection string to have Source=ngoaccess.mdb.

However when I use IIS then it needs the full path
Source=C:/NGO/ngoaccess.mdb. I get two pop-up errors one after the other.
First one 'Data provider could not be initialized' then second error 'Not a
valid file name'.

I want to get this to work using a relative path as I want 2 users to be
able to use this application without having to share application files on
server. Any help on this would be much appreciated.

 

[Antoine Prevot]

Hi "AN",

However when I use IIS then it needs the full path
Source=C:/NGO/ngoaccess.mdb. I get two pop-up errors one after the other.
First one 'Data provider could not be initialized' then second error 'Not a
valid file name'.

First of all, what is your OS ? XP ? 2000 ? 2003 ??

I dunno if it's your issue, but try to use a valid uri, ie :
"file:///C:/NGO/ngoaccess.mdb" instead of system path "C:/NGO/ngoaccess.mdb".
You can also try to enable a web sharing on your "C:\NGO" folder depending
on your OS (right click -> web sharing). Assuming that IIS permissions are
properly configured, your file will be available at this url :
"http://localhost/NGO/ngoaccess.mdb". Replace "localhost" by your real
machine name if you want to use it over a network. In the worst case, you can
create a virtual directory (IIS mcc -> machine name -> default web site ->
right click -> new -> virtual directory) and make it point to your "C:\NGO"
folder.

Hope this helps,

Tonio