Updating an access database ONLINE

(btw Sorry for making new thread, couldnt find any material which was specific enough)

scenrio

Ive made a questionaire in vb6 and once complleted the results get sent to a access database located in a network drive

example (from scenrio)

dim db as database

db = opendatabase("n:\........\database.mdb")

What i want to achieve instead

well instead of it being in a drive on the network , is it possible to store it on the internet and just specify its url to open it. Something like

db = opendatabase("http//:....../database.mdb")


id imagine this wouldnt be the way to go about it but how could i do it?

ty

I imagine you could just throw it onto a web server and users could access it, however, they would be required to access it with read/write and execute permissions.

Although I am probably wrong :/

another issue im thinking about is security. I want my vb app to be able to send some sort of key with the data so that the database reconnises it comes from a valid source. Not sure if this is how to go about it and not sure how to do it lol.

Just another question to throw in there but one which is less important for now. :wave:

This is from RhinoBull, I hope it may be of help...

Quote:

---

Originally Posted by dee-u

This is from RhinoBull, I hope it may be of help...

---

my web server is running under a linux OS

Your best path is to write the application in some language that would run on the web server. Then you'd let your users answer the questionaire and store the answers in the database on the server. ASP would make it pretty simple to access the database using most of the VB code you already have.