Run time engine for Access?

[DougKalish]

I want to creat a database in Access so that others (who may not own Access)
can enter info and get reports from my website. Is this possible? What do I
need to do to make this happen?

Thanks,
Dou, a neophyte

 

[Albert D. Kallal]

There is a free edition of ms-access called the "runtime". This will not
allow users to modify your appcation, but if you looking to build and deploy
your application then that should do the trick for you. The runtime is free
for access 2007, for previous versions, it was quite pricey.

a> can enter info and get reports from my website.

Website???? ms-access has no relationship to the web in any way. You can
place your application on your web site, an have users download it. You can
also use the free edition of SharePoint, and have multiple users in
different locations run the application on EACH computer, but the data
tables can be on SharePoint. So, you can have a multi-user system, and the
free on-line edition of SharePoint does allow 5 users. Your "free"
SharePoint can be found here:

www.officelive.com

Note that the linked tables to SharePoint really only works well with access
2007.
However, none of this is web based at all, and ms-access has nothing to do
with the web....

 

[Larry Linson]

I want to creat a database in Access so that others (who may not own
Access)
can enter info and get reports from my website. Is this possible? What
do I
need to do to make this happen?

you can create a database using Access, with one of the database engines it
can support (the default is the Jet database engine for Access 2003 and
earlier, and the ACE engine for Access 2007), place it on a website and
create an application one of several ways to allow your users web access to
that database. Some options are:

A VPN and Windows Terminal Server, with Access installed on the Server
Microsoft Front Page 2002 or 2003, for very simple interfaces
ActiveX Server Pages, .asp, or ASP.NET server pages, .aspx
SharePoint, as Albert has described
Many third-party web application programming languages

The only attempt at web applications in Access, Data Access Pages, was
rather limited, and, thus, never well-accepted. It has been "deprecated" in
Microsoft-speak, and, in Access 2007, you can run existing DAPs, but you
can't create a new DAP nor maintain an old one -- to do that, you'll have to
have a copy of Access 2003 or earlier installed somewhere.

Larry Linson
Microsoft Office Access MVP