|
-
May 17th, 2006, 10:25 AM
#1
Thread Starter
Junior Member
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
-
May 17th, 2006, 11:50 AM
#2
Re: Updating an access database ONLINE
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 :/
-
May 17th, 2006, 11:53 AM
#3
Thread Starter
Junior Member
Re: Updating an access database ONLINE
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.
-
May 17th, 2006, 08:01 PM
#4
Re: Updating an access database ONLINE
This is from RhinoBull, I hope it may be of help...
-
Jun 9th, 2006, 06:36 AM
#5
Thread Starter
Junior Member
Re: Updating an access database ONLINE
 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
-
Jun 9th, 2006, 03:36 PM
#6
Re: Updating an access database ONLINE
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.
The most difficult part of developing a program is understanding the problem.
The second most difficult part is deciding how you're going to solve the problem.
Actually writing the program (translating your solution into some computer language) is the easiest part.
Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.
Please Help Us To Save Ana
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|