RSCARLISLE said:
I read a message in the discussion group eluding to the fact that DAP's
were
going to be a thing of the past. At the very least, not edit supported in
Access 2007. What's the scoop? What are the alternatives? Any comments are
appreciated.
You can run existing DAPs in Access 2007. You cannot create a new DAP nor
maintain an existing one in Access 2007. Access itself provides no
alternative.
If you want to interface online with an Access database, there are a number
of alternatives, all somewhat to greatly more complex than creating DAPs
(and some with a great deal more flexibility than DAPs).
Microsoft Front Page 2002 or 2003 with the Database Interaction Wizard can
be used to create simple web-based interfaces to Access (Jet) databases.
Expression Web is Microsoft's more general-use successor to Front Page.
The current versions of Microsoft SharePoint and Microsoft Access can be
used together -- the data would be kept in SharePoint. The SharePoint
Designer is a successor to Front Page, which is no longer a current
Microsoft product.
Third-party products such as Adobe ColdFusion or DreamWeaver can be used
with Access databases.
A web-based application can be created with Active Server Pages, .asp, or
with ASP.NET. Some other languages can access an Access database online,
too.
In some cases, you can use Microsoft Terminal Services and/or Citrix
Metaframe to execute your Access application directly on the server.
Larry Linson
Microsoft Office Access MVP
