Microsoft Access - web-browser based form for Access

Hello there,

Wondering if anyone could suggest a solution that could allow end-users to enter data in a web-browser based form for Access 2003 database. I want to  be able to create this form for LAN environment user. Unfortunately, we don't have Sharepoint server for Infopath forms to work. Is there a way to create a form in XML as a webpage? Any ideas would be much appreciated.
Thanks. Shoro

Not automatically.  You'd have to write your own server side code in something like php, asp, java, or asp.net and host the web site on a web server.

That said, Access 2003 is one of those applications Microsoft tells you is not suitable for a multi-user environment like the web.

Thanks for your reply, Robbe.

If everyone is on your LAN, you don't need a browser based form, they can all use Access.  If you don't want to distribute the entire app to everyone, you can create a scaled down app with just the form they need.  The small version links to the same shared database as the main app so everyone will see the data immediately.

The runtime version of Access was not free for A2003 so each user would need the full version of Access installed.  If not all users have Access, you can try downloading the free runtime for A2013 and distributing that.  It will work with .mdb files.

Browser based forms are only necessary if you want anonymous users to connect to your application from outside your network (very dangerous).  If everyone is on your network, then Access works just fine.  If you need to support occasional remote users, the simplest solution is Citrix or Remote Desktop.  Again, this keeps your Access FE investment intact.  If you need to create an outward facing application, you will need to give up Access both as a FE and Jet/ACE as the BE.  Neither Access nor Jet/ACE is suitable for outward facing apps.