Web-Based Database

A

Anthony Viscomi

My client just informed me that they would like to move the Access database
that I've developed for them to their web-site. I know that they are running
SQL Server for some of their other apps, thus my back-end would be stored
there.My dillema is that I wouldn't know where to begin. Alot of my
front-end forms have tab controls and alot of other "bells & whistles". Is
there any program/utility out there that can help me convert the front-end
GUI into web-pages?

Thanks!
Anthony
 
N

Norman Yuan

If the website (whether it is run on the intranet or the internet) uses SQL
Server as data store, I am afraid that your front end Access app will be not
useful in that kind of environment, 'cause users usually access the website
through a web browser. Unless your Access app contains mostly Access data
pages, you may have some chances to re-use some of the pages. I do not know
whether there is tool to convert Access forms to web pages. Even there is
one, I doubt how good it can be. While Access app is usually a connected
app, web app is disconnected app. They just too different to convert to each
other reliably. No way. Even upsizing your Access back end to SQL Server may
need some manual fixing, re-design and extra work. For example, you may
definitely want to write some or lots of stored procedures to replace your
dynamic SQL queries or queries in Access, and so forth.
 
B

Brendan Reynolds

I haven't heard of any tool that would convert Access forms to web forms.
What makes sense in an Access form very often will not make sense in a
web-based form. You're likely to have to do some fundamental redesigning of
the UI, and that's not the kind of thing that automates well.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Top