How do I publish a Microsoft Access Database to the web?

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

Guest

I have a lady within my company that would like to publish a Microsoft Access
Database to our internal intranet web site. She would like this database to
be active and up for use within our company. Is their a way that I can put
this database on our website for people to use? Ideally, I would like for
everyone to be able to use this database and if changes were to take place it
would save the changes.
 
Access requires a fast, stable network connection. Internet is neither,
even at T1 or better. You should look at an alternative database engine or
remote access technology like Terminal Server, Remote Desktop, pcAnywhere,
etc..
 
We do have a T1 coming into the building. I guess my question is, how do I
put this database on our intranet home page in order for employees within the
company to access. How can I set this up? If I need one of these other remote
access technology services that you have listed, what is the best way of
going about that? I am not familiar with this, so any help would be
appreciated. Thanks!
 
If "Publish" mean for other users to use Forms, Reports, Qeries contained in
*.mdb file, no, you cannot. If you use Access 2K or later, and the user
interface in that Access application (*.mdb) is Access Data Page, then
MAYBE. Anything you do inside Access is desktop technology (except for
Access Data Page), and what you want is web app technology. They are
different from concept as to how user uses the application. If your Access
application designed properly (that is, splitted into front end and back
end - not HAVE TO, but highly RECOMMENDED), then the data portion - the back
end could be used as web app's data source without changes, but the user
infterface must be re-written for the web app, using appropriate web
technology, whether it is inernal website or public website.
 
Per Slezak:
I have a lady within my company that would like to publish a Microsoft Access
Database to our internal intranet web site.
Click to expand...

Distinguish between front end (the screens and so-forth) and back end (the data
in the tables).

Front end? Not via Access, but maybe via some kind of terminal server like
Citrix or PC Anywhere.

Back end? Somebody would need to write a new front end using something more
web-friendly that goes and gets data from the back end.
 
Back
Top