Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I share Access database with my students over the internet

Discussion in 'Information Technology' started by mmurphy4tx, Jul 28, 2006.

  1. mmurphy4tx

    mmurphy4tx
    Expand Collapse
    Guest

    I want to share an Access database with my students. They may add
    information to some areas and may only read other areas. I want to do this
    on the schools web site.

    Does anyone know how to do this the best way?

    Thanks
     
  2. Loading...


  3. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    I posted this earlier. It still applies ...

    Dan:

    There is some question about whether or not this is a good practice, but you can create
    ASP pages to view, add and edit data in an Access mdb from the web. I've written a
    couple of articles for DBJ and they come with code downloads that might help. There's
    also several commercial products out there for creating ASP pages for Access tables,
    but off the top of my head, I can't remember their names.

    http://www.databasejournal.com/features/msaccess/article.php/3487741
    http://www.databasejournal.com/features/msaccess/article.php/3613386
    http://amazecreations.com/showmethetable/ShowMeTheTable.asp

    The problem is consistency. If multiple users edit the same row at the same time, one
    of them lose their changes. If users seldom work on the same data at the same time,
    then it's just a question of performance. You won't want to return thousands of rows
    at a time (it takes forever to create the web page) and you won't have the ease of data
    validation from web controls, unless you write good client side code. What I show in
    these articles is simple and not terribly robust, but for some applications, it's enough.
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "mmurphy4tx" <mmurphy4tx@discussions.microsoft.com> wrote ...
    >I want to share an Access database with my students. They may add
    > information to some areas and may only read other areas. I want to do this
    > on the schools web site.
    >
    > Does anyone know how to do this the best way?
    >
    > Thanks
     

Share This Page