Web Front End for Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a functioning system that is split between a FE and BE. I'd
like to make the FE web based.

What is an efficient method for generating the web forms that link an ODBC
connected database?

Any guidance is appreciated
 
Zanstemic said:
I currently have a functioning system that is split between a FE and
BE. I'd like to make the FE web based.

What is an efficient method for generating the web forms that link an
ODBC connected database?

Any guidance is appreciated
Click to expand...

Efficient method? If you're looking for some sort of conversion tool there
isn't one. You basically have to build a web interface from scratch using tools
for building web pages. The only work you have done up to now that you get to
utilize in the web app is the tables.

For a small targeted set of users you might look into using Terminal Services
over a VPN. That would allow users to remotely run your existing Access app
over an Internet connection. If you need this available to a wide audience (or
the general public) then you nmeed to build a proper web application.
 
Rick,

Could you expand on what it takes to run Terminal Services and what it takes
to set up a VPN.

Thanks!

Steve
 
That's really another group but here's the "quick and dirty": Windows Server
(2000 or 2003) can act as a Terminal Services server. For more than one
user, you need to buy licenses. A VPN is a "virtual private network" that
uses an internet connection. Both of these are best left to professionals -
get a consultant to help you.

Bob
 
That's really another group but here's the "quick and dirty": Windows Server
(2000 or 2003) can act as a Terminal Services server. For more than one
user, you need to buy licenses. A VPN is a "virtual private network" that
uses an internet connection. Both of these are best left to professionals -
get a consultant to help you.
Click to expand...

Actually, if you setup a 2000 TS, and if your users are all running Windows 2000 Pro or Windows XP Pro, then you don't
need to buy additional TS licenses - each of those OS's have "builtin" licenses (note that each user would still need a
server license, however).

This went away in 2003; every user connecting to the TS box needs both a server license, as well as a TS license.

I agree with Bob re: have a professional set these up (especially the VPN) ...
Bob
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Hi Zanstemic,

I'm interested in hearing about your scenario. Can you describe in a little
more detail what you hope to accomplish? Can you describe your application a
little bit? Size, complexity, business need, etc?

In what way would you like Access to help you here? How do you envision your
users using this application? How many users?

Thanks,
--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
Back
Top