Access help files?

[Phil]

Hello-
I am in the works of trying to add a search feature into
my website. I am trying to use Access to create a .mdb
file which will then be used as an ODBC source.

I have never used Access, and it seems like it could be
easy. The help feature that comes with Access is not
great. Is there a better tutorial for getting started?
I am not sure I understand how Access works.


Also, when I do try to create a new page, do i have to
connect this new file to the SQL source?

Thanks in advance
Phil

 

[Chris]

Phil,

Yes, Access can do this. Create the tables/queries in
Access and populate it. Then, using ASP and ADO, open a
connection to the database (either using the native driver
or ODBC driver). Open a recordset on that connection.

See:

dim conn
dim rst

set conn = server.createobject("ADODB.Connection")
set rst = server.createobject("ADODB.Recordset")
conn.open "DSNName"
rst.open "Select Field1,Field2 from TableName",conn
response.write "<Table>"
response.write"<tr><th>Field1</th><th>Field2</th></tr>"
do until rst.eof
response.write "<tr>"
response.write "<td>" & rst("Field1") & "</td>"
response.write "<td>" & rst("Field2") & "</td>"
response.write "</tr>"
rst.movenext
loop
response.write "</table>"

rst.close
conn.close


References:
http://www.asp101.com
http://www.mvps.org/access


HTH

Chris

 

[Guest]

Thanks Chris-
I have figured out how to insert it into my site using
Dreamweaver, but as far as designing the database, I am
quite lost. Is there a good help file somewhere for how
to create it?
For instance, I am trying to create a search feature, so
that when a product brand or type is entered, a list is
populated. When I build a table, I am unsure of what is
supposed to be entered. Do i need to create a separate
table for each category?
DO i even need a table, or can i just create a query?

Thanks