Access Webpages

[Linuxjunkie85]

Hello,

I have a database used to submit online forms to from a webpage. I also
manage the database from a webpage. The online form that submits to the
database works fine, I used dreamweaver and made a dsn-less connection. The
management page however doesnt work. I created the page in Access so that I
could view and alter the entries in the database. To connect to the database
the page needs a specific network path (\\server\share\file), I cannot do
this because the page will be accessed outside of my LAN. It wont connect by
just using the file name, the database is in the same directory as the
webpage on the server. How do I connect to the database?

 

[Doug VanOrnum]

I have had similar problems accessing a database on a web server. Did you
find a way to connect? In particular, I would like to be able to edit the
database as well...

 

[Guest]

uh, you guys need to give about 4x more detail before we can help you.

Do you mean using an Access database?

-aaron

 

[Linuxjunkie85]

I have an Access Database located in a folder on the webserver. The pages
accessing this database are in the same folder. I have an online form that
can submit data to the database just fine. My issue is that I cannot create
a page to retrieve or edit the data without putting a specific network path.

 

[Guest]

you're supposed to use a DSN... I think that is the _FASTEST_ when using
MDB.

if you don't want to, i believe that you have to put the full path in the
connection string (not possible to use the relative path)

I'm sure that you could do something like this:

SERVER.mapPath should return 'C:\inetpub\wwwroot\happySite\'

That should make it a lil bit easier, then you can make the ado connection
string look to:

server.mappath + 'happy.mdb'

what are you using to write this, dreamweaver??

-aaron

I have an Access Database located in a folder on the webserver. The pages
accessing this database are in the same folder. I have an online form that
can submit data to the database just fine. My issue is that I cannot create
a page to retrieve or edit the data without putting a specific network

path.