DB to WWW

[Guest]

Hi all,

I've (finally) got things working fairly well with my DB and now I need to
think about taking the next step. I want to make it web accessible. That
might not even be the right word, but allow me to explain.

I have an Access 97 database. It has a FE/BE configuration, with users
using the .mde file to perform searches on the data. This system works well,
but users have to have Access 97 installed on their machine. What we'd like
is a FE that's actually a web page. Every user that wants to access the DB
would go to a web page and they could then access the DB through html files
using IE.

I know 'of' the web publishing wizard, but I wanted to know MVPs thoughts on
that. Will it still function as a FE/BE configuration? The users ONLY
perform searches, no adding/updating/deleting. Queries are also
created/deleted depending on the search criteria specified by the user. The
FE works fine with this, as the queries are created locally. I don't know if
that will remain the case if I go to web based.

The admin will have access to the BE and, using a form in the BE, will be
the only person adding data to the BE tables. There is no need for this
aspect to be web based.

This is a new step for me, so any comments are appreciated.

Thanks,
Jay

 

[Guest]

I maintain an application with over 50 users on the tables. Six use an Access
front-end running on a Terminal Server. Eight use an ASP front-end running on
a webserver. The rest access the data from within a LAN. The tables are in
Access 2000 and the front-ends a mixture of Access 2002 and 2003. All of the
applications are read/write/edit. It can be done.

I used the services of a web developer extensively while building the web
front-end. It is significantly more difficult/time consuming/expensive
(choose your favorite term) than working with Access front-ends.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access