Results 1 to 6 of 6

Thread: Updating an access database ONLINE

  1. #1

    Thread Starter
    Junior Member
    Join Date
    May 2006
    Posts
    31

    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

  2. #2
    PowerPoster kfcSmitty's Avatar
    Join Date
    May 2005
    Posts
    2,248

    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 :/

  3. #3

    Thread Starter
    Junior Member
    Join Date
    May 2006
    Posts
    31

    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.

  4. #4
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Updating an access database ONLINE

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


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  5. #5

    Thread Starter
    Junior Member
    Join Date
    May 2006
    Posts
    31

    Re: Updating an access database ONLINE

    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

  6. #6
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    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
  •  



Click Here to Expand Forum to Full Width