Add a database as a table of information

[fateman@hotmail.com]

I have an Access database that I would like to simply add to a table so the
content of the database can be listed, while exluding some of the columns
of the table. How would I do this?

Thanks

--
Using M2, Opera's revolutionary e-mail client: [url]http://www.opera.com/m2/[/url]

[leggyredhead]

Hiyas fateman,
I'm going to assume that you haven't worked with an access database on a
webpage before, so if i'm covering things you already know I apologize.
1. Are you on a Windows server? If so then using access is fairly
straightforward. You'll need to upload the database, then use dw to create
a recordset(query) for the database. Use DW's "Application" window to set up
the database, dsn, test site and recordset. Create a new page using aspVB
instead of a standard html page. From there it's a step by step process
using the Application window. Setting up the dsn connection is the toughest
part. After that, you'll create the recorset, then use it to drop the
fields you're using into the table cells on your page. The dynamic table
for the recordsets can go anywhere on the page, and you can include any html
you want on the rest of the page. Be sure to add a repeating region to the
cells after you insert the fields and then test it in "live view" to see how
it will look. When you're happy with the look, you're done!
2. If you're not on a windows server you'll need to look at other options,
such as using msSQL to create the dynamic pages.
Hope this helps,
Leggy

<fateman@hotmail.com> wrote in message news:oprr9p2ib2oh3lwx@localhost...
I have an Access database that I would like to simply add to a table so the
content of the database can be listed, while exluding some of the columns
of the table. How would I do this?

Thanks

--
Using M2, Opera's revolutionary e-mail client: [url]http://www.opera.com/m2/[/url]

[Julian Roberts]

Use the 'dynamic table' behaviour in MX

--

Jules
[url]http://www.charon.co.uk[/url]

Charon Cart 3
[url]http://www.charon.co.uk/charoncart[/url]

ICQ 51328805



[email]fateman@hotmail.com[/email] wrote:

> I have an Access database that I would like to simply add to a table
> so the content of the database can be listed, while exluding some of
> the columns of the table. How would I do this?
>
> Thanks

[Dwayne Epps]

You can use ASP/ADO to create a connection to your database and then display
the recordsets onto a HTML page. Displaying only the fields of the
recordset you wish is just a matter of listing the desired fields within the
ASP code. If you have never worked with ASP code before you can find some
pretty good online tutorials by doing a search for ASP database tutorials on
google or something similar. There will be lots of listings for tutorials
that can show you how to create the connection and display the information
on your page. A book that helped me when I first was learning to code in
ASP was "Beginning Active Server Pages 3.0" by wrox press. Hope this
information helps you out.
-D-


<fateman@hotmail.com> wrote in message news:oprr9p2ib2oh3lwx@localhost...

> I have an Access database that I would like to simply add to a table so

the

> content of the database can be listed, while exluding some of the columns
> of the table. How would I do this?
>
> Thanks
>
> --
> Using M2, Opera's revolutionary e-mail client: [url]http://www.opera.com/m2/[/url]