Kevin Spencer
4/2/2004 1:44:00 PM
> - My Access DB is divided into backend and front end portions. I've moved
a
> copy of the backend portions (just the tables) into the fpdb directory in
my
> website tree. Was that the right part to copy there or should it have
been
> both front-end and backend?
The "front end" portion, as you refer to it, is code that is used by the
Access program to display a user interface in Access. The tables, or "back
end" as you call them, are the part that ASP and ADO need to get the data
(that is where the data is stored, and the "front end" gets it from there as
well). The ASP Page serves as the interface.
> - When I setup to display data on a web page, I can choose which single
> Access table I want to source from but I haven't figured out yet how to
> display data drawn from multiple tables. Is it possible?
Of course. However, there are many configurations which might require data
from more than one table, so that's as much as I can tell you based upon
your question.
> - One of my tables has 800 records sorted alphabetically. Since I only
> show the user records in groups of 10 at a time, it takes them awhile to
> step into the middle of the 800 records. Can I set up something like an
> Editbox that they can enter a string into and then I can use that for a
> filter to control which records are displayed?
A FrontPage Database Results Page can do this.
> That's a good start. Is this the right place to post this? Should I
begin
> reading ASP books? Any help would be much appreciated.
The more you know about these technologies (HTML, ASP, ADO), the better off
you'll be.
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Dennis" <junk@galron.com> wrote in message
news:uJxue5FGEHA.1128@TK2MSFTNGP11.phx.gbl...
> I've just gotten FrontPage 2002 to link to my Access 2002 database and
> display data from the database on my website. That's cool but I've
> immediately come to a number of questions I can't answer:
>
> - My Access DB is divided into backend and front end portions. I've moved
a
> copy of the backend portions (just the tables) into the fpdb directory in
my
> website tree. Was that the right part to copy there or should it have
been
> both front-end and backend?
>
> - When I setup to display data on a web page, I can choose which single
> Access table I want to source from but I haven't figured out yet how to
> display data drawn from multiple tables. Is it possible?
>
> - One of my tables has 800 records sorted alphabetically. Since I only
> show the user records in groups of 10 at a time, it takes them awhile to
> step into the middle of the 800 records. Can I set up something like an
> Editbox that they can enter a string into and then I can use that for a
> filter to control which records are displayed?
>
> That's a good start. Is this the right place to post this? Should I
begin
> reading ASP books? Any help would be much appreciated.
>
> --
> Dennis Gallagher
> Monroe, WA, USA
>
>