<ca******@yahoo.com> wrote
Besides ADPs, are there any programs I can
use for letting people use Forms of an Access
DB inside IE? I've been reading that ADPs can't
contain all the functionality of Access forms.
Do you perhaps mean DAP (Data Access Pages)? ADPs are a form of Access
application that connects directly to MS SQL Server over a LAN, and has
nothing to do with intranets or the Internet.
There is nothing, including DAPs that "allow use Forms of an Access DB
inside IE". It is possible, with enough time and effort, that you might use
"smart client" applications in the Dot Net environment to approach the
functionality of Access Forms. But, those will NOT be "inside Internet
Explorer" and the learning curve will be steep.
Are there options that are not server dependant i.e. ASP.
I'm not sure what you mean by "not server dependent". ASP does essentially
_all_ the work on the server, and the browser is used as a "dumb client" to
look at the information. ASP.NET is more recent technology, but works
similarly.
I do not normally recommend DAPs, because of their limitations, though some
have had good luck with business applications in intranets using them... you
could do almost as much by using Front Page 2003 with the Data Interaction
Wizard, and it would be both simpler and applicable to other browsers
besides IE (if that is a factor). I've seen some good applications created
using third-party tools with Access databases, but those tend not to be
inexpensive, usually requiring a server component. .ASP and ASP.NET are more
flexible, but none of these can provide the rich user interface of Access'
Forms.
Larry Linson
Microsoft Access MVP