Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page