Web Forms

E

ember

Hello,

i want to know if it is possible to create a web page wich is equal to
a database i've created, and by this I mean, where i'm able to insert
and query data in that that database the same way i do in MS Access (by
using combo boxes, buttons to print reports, macros, etc.) so that
instead of doing these operations on MS Access, other people in which
have access to my intranet can use the database without having Access
installed on their PC's.

Can anyone help me on this matter?


Thanks,

ember
 
L

Larry Linson

i want to know if it is possible to create
a web page wich is equal to a database
i've created, and by this I mean, where
i'm able to insert and query data in that
database the same way i do in MS Access
(by using combo boxes, buttons to print
reports, macros, etc.) so that instead of
doing these operations on MS Access,
other people in which have access to my
intranet can use the database without
having Access installed on their PC's.

You cannot create a web page that is fully equivalent to Access' Forms and
other objects, because of the inherent limitations of web browsers. But, in
an intranet environment, you can use Access Data Access Pages to create a
web interface to your Access database. The users must be using Internet
Explorer 5.5 or later, and must have the Office Web Extensions installed
(free download from Microsoft for Access 2003). And, the interface cannot be
as "rich" as provided by Access itself. Still, in such environmments, many
have made good use of DAP to fill their business application needs.

Another alternative, probably as easy or easier, and not requiring the
Office Web Extensions be installed, but with an even more limited user
interface can be created with Microsoft Front Page 2002 or 2003 and the
Database Interaction Wizard.

If you want to invest some time and effort in learning, you can create a
somewhat richer and more flexible interface using Microsoft's ActiveX Server
Pages .asp, or the more recent, and more enhanced, ASP.NET.

With even more investment of learning time and effort, you can create a .NET
"smart client" application that can be near the richness of the Access
interface.

If the learning time and effort seems to be a barrier, bear in mind that
these are skills that are much in demand in today's market, so there may be
"payback" beyond the application you want to implement. You will have
additionall marketable skills that are (more) in demand (than just Access
skills).

Larry Linson
Microsoft Access MVP
 
Top