Dcbrown428 said:
I have a database that I would like to post on my company's website. I
need
for the various users to be able to complete a form daily and also be able
to
retrieve reports based on the data they have entered. My database is
complete, but the person responsible for maintaining our company website
is
not familiar with access. Where does he begin? Also, will the database
appear the same one posted - with the switchboard menu, form formats and
reports?
An Access database is just a file, so the answer to your subject question
is, "You can use FTP to copy the file -- that is not an Access issue."
However, reading the details, it appears you are hoping that you can just
place the Access database on the webserver and have it work as though it
were local but that cannot be done.
The simplest approach to doing what you want will require that your system
adminstrator install and enable Microsoft Terminal Services to allow the
uses to execute the DB remotely on the server. Other alternatives are more
complicated, and you or the System Administrator would need more than a
newsgroup post to become sufficiently well-versed to implement them.
If the user interface for what remote users need to accomplish is
sufficiently simple, then Access 2000 - 2003 (and I'd recommend the most
recent) has a feature called Data Access Pages. It's not been overly
popular, has some significant limitations, and is being "deprecated" in the
next release. All that said, however, if you invest time and effort in the
learning curve, and purchase self-study books that cover it well (some do,
some don't), it might serve your needs. (In answer to the obvious question:
no, I do not personally use DAPs, so someone else would have to answer
detailed questions.)
Larry Linson
Microsoft Access MVP
