I mostly agree with Scott, and you'll have to weigh the pros and cons
for yourself. We do some things here with Access db's on a website
that, and the data entry and reporting are just clumsy to work with,
and the output is inflexible. On the other hand, there's a huge
benefit to some of the info being available to us regardless of where
we are (the web is published to the internet, not the company
intranet). Another factor in favor of the web approach, at least for
us, is the painfully long loading time to call up the database using
Access, if you're on a server other than where the db is. In favor of
the database approach is the ease of modifying the structure, reports,
etc. When publishing to the web, you have to regenerate the asp script
after modifying the database. Of course, if you're better at that than
I am, maybe that's not such a big deal. If you're not heavy into this,
there's a nifty program called Aspmaker. I'm sure someone on this
newsgroup can remcommend a better or more robust program, depending on
your needs.
"Scott McDaniel" <sc***@no.spam.thedatabaseplace.net> wrote in message news:<n4********************@comcast.com>...
Echo what Tom says ... the interfaces you end up with in a web app are
nowhere near as feature-rich as a Windows-based interface. There are
compromises regarding interface consideration ... subforms (one of the
greatest things about Access) cannot be used, combos and listboxes are
harder to deal with, you have to handle data access manually (nothing is
bound), etc etc ... IMO, unless your users really need web based, they're
better off with PC based.
We've done some "hybrid" stuff, where users had PC based apps and we
exported data to a web-based server for a reporting interface. That way
remote offices could at least keep up with the progress of projects, albiet
not in real time (we uploaded data a couple of times throughout the day). It
worked out fine, a few folks grumbled but these were the same people who
grumble about everything <grin>.
"Cham" <ch********@yahoo.com> wrote in message
news:20**************************@posting.google.c om... Hi
I have a complex Ms Access application with lots of forms and queries
that needs to be moved on to the web. Is there an easy way to do this
without re coding in ASP?