We have been trying to display our Access Database
information on our Intranet, and enable users to search by
different fields. We do not want anyone to update through
the Intranet. The updating is done directly by one person
into the Access file. Something seemingly easy has been a
nightmare. This is what we have been trying:
1. Using Front Page's Database Results Wizard, we have had
to first import our database into our Intranet web, and
then we can see records, and search etc. However since
this database is updated elsewhere, we can't keep
reimporting the file to keep the info dynamic, and it will
not open the imported Access file in its web location for
editing.
2. Using Access's data access page feature, we have been
able to get our records to show up on the Intranet and be
connected to the underlying file. In addition we have been
able to seal records from user editing, but the problem is
that only search capabilities are a weak filter by
selection that does not do wildcard searches (such as one
word in a description field).
3. In our Access database we have a perfect setup of
parameter queries so that the user inputs all or part of a
reference and gets a nice report. When we get this into
our web thru a data access page, the parameter form does
come up, but after filling it in, records never show in
the report.
It seems we have come up against specific stumbling
blocks. For instance, does anyone know how to set up a
hyperlink on a page created in Front Page that would just
bring up and transfer control to the Access file? Right
now, "Quick View" gibberish comes up.
Does anyone know how can I reference an Access database
outside of the Intranet in a file such as global.asa? It
only appears to recognize http:// and not network letters?
Any help would be appreciated since we have been pulling
our hair out!