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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13036
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/featu...le.php/3487741 http://www.databasejournal.com/featu...le.php/3613386 http://amazecreations.com/showmethet...MeTheTable.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"
wrote ...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13036
>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