Frontend Database

[islandlover]

I have designed a web site using Frontpage 2003. It includes a secure form
that sends data to an access database in fpdb. I have read on here there is
a way to make the database "results" available to other members of our
organization through a frontend and backend database. I would appreciate it
if someone would explain to me how this is done. Thanks for your assistance.

 

[Ian Haynes]

I have designed a web site using Frontpage 2003. It includes a secure form

that sends data to an access database in fpdb. I have read on here there
is
a way to make the database "results" available to other members of our
organization through a frontend and backend database. I would appreciate
it
if someone would explain to me how this is done. Thanks for your
assistance.

The terms 'frontend' and 'backend' typically refer to the scenario where you
have a main database, maybe in SQL Server, which consists only of the db
tables, and an Access frontend which has forms displaying the table data.

In web terms you might also build a set of pages that display data from the
database.

In your situation you could create pages that display data from your Access
db for members of your organisation to see. FP has the database wizards
which may help you achieve this.

HTH

 

[Mike Mueller]

I have designed a web site using Frontpage 2003. It includes a secure form
that sends data to an access database in fpdb. I have read on here there
is
a way to make the database "results" available to other members of our
organization through a frontend and backend database. I would appreciate
it
if someone would explain to me how this is done. Thanks for your
assistance.

If I am reading this correctly:
* Your website has a form that is connected to an Access Database
* You have other users who need access to this information
* You have heard of splitting databases into a front-end and a backend, but
don't quite understand

Question: Regarding the people who are going to view the information; will
they be viewing this through the web or through Access?

If webpage, then you don't need to worry about front-ends and backends. In
FrontPage you can use the Database Results/ Database Interface wizards to
create a report on a webpage using your existing db as the backend. The
database wizard webpage would be the front-end

If via Access, then you would be best served with a front-end/back-end
combination.
The back-end would be where the data is stored in the tables
The front-end would be where users could work with the data; and this db
would also have any queries, forms, reports, modules, macros and other
coding in it.

How to do it?
The fpdb database would be the backend, you would just need to create a new
database for the front-end. Once the database is created; you would do an
import from the back-end, choosing to use 'Linked Tables'.

More info on the Access side of this would be best sourced from the
microsoft.public.access newsgroup