You need to set up another ASP page, and use the Database Results Wizard,
which will place a number of "placeholder" field names on the page, which
when the page is viewed in a browser will show each record.
Within the DB results wizard, you can also set up queries, and search form
so a user can search for certain things (based on keywords in a particular
field of your db) and that wil then return any results for that search to
the screen using the page generated by the Results Wizard.
If you're familiar with Access, and perhaps generate reports, then you
already have some of the knowledge to do the database results page, which in
one respect (from another point of view) could be regarded as an access
report of sorts.
The reports in Access are generated based on 'criteria' and you set up
queries to filter the data to get the results you want; for example want a
list of customers with post code (zip code) 90210; you'd specify the query
to generate all the records for field "postcode" with value "90210" then it
generates the report.
The FP database results wizard is a little the same, in that the page will
return either all the records, or those based on your queries/search. Also
rather than pre-setting the query and field values, you can have the user
search the database, based on a particular field or fields, and generate the
results dynamically.
It remains to be seen if you need that particular aspect (as opposed to
simply listing *all* records).
It may be a little trial and error at first, but once you get the hang of
it, it will be quite easy to implement.
Start the DBRW from Insert > Database > Results. Go through each screen of
the wizard. It is fairly straight forward; if you have questions about
each step, post back any questions.
islandlover said:
I am using Microsoft Access 2003 and Frontpage 2003. I have created a form
(saved as .asp) where people enter information and it goes to an access
database. This part is working great. Other people at a remote location
need to view the information so they can prepare badges and work with the
information; they have microsoft access but not frontpage. I have tried
opening access and entering the name of the website/file, entered the user
name and password but I receive an error that the file cannot be found or
I
do not have access permissions. How can we view the information over the
web
site?
Thanks for your help.
You can use the Database Results Wizard; this will create another ASP page,
and uses a "wizard" to step you through the process and generates the asp
page/code needed. It its basic form, it simply lists all records from the
database, or depending on your query criteria, the records returned based on
that criteria. This will be more than enough to suit your needs according
to the description above.
It may be a little trial and error at first, but once you get the hang of
it, it will be quite easy to implement.
Start the DBRW from Insert > Database > Results. Go through each screen of
the wizard. It is fairly straight forward; if you have questions about
each step, post back any questions.
