Should I use an Access database within Front Page

M

musketman1962

WinXP Pro, FrontPage 2003.
I want to have a database within Front page 2003 that will for example, list
all the football teams in the Premier and League divisions.

Allow a visitor to select a team and find out what division that team is in,
or to select a division which will show all the teams in that division .
I am utterly new to this so would appreciate any advice.
TIA
 
C

Conrad

Set up a database under a folder in your website. Then on your default page
add the following code.

***code

Set conn = Server.CreateObject("ADODB.Connection")
Session("MyDatabaseVariable") = "Provider=Microsoft.JET.OLEDB.4.0;Data
Source=" & server.mappath("/Data/MyDatabase.mdb") & ";"

Set rst = CreateObject("ADODB.Recordset")
rst.Open strSQL, conn, 3, 3

***code

I hope this is not too confusing. It may seem extrenous now but it saves a
lot in the end. We this kind of connection you can do just about anything
with the data.
 
M

musketman1962

Conrad, thank you for your reply, I am sure that it will be helpful:)
When I said that I am utterley new to this, I meant that I am utterly new
to this :))

With a little patience, would you be kind enough to tell me how to set up a
Database . I have had a look at Microsoft Access but could not see where I
was going?

My wife tells me that I am too old to be messing about like this but I want
to make prove a point (or something like that).
TIA
 
C

Conrad

Look at Access Step by Step to set up the database. Then use the code
snippet I gave you on the original reply on you page. Just for the "Source =
" part substitute your file path to your database that you create.

Let me know how it goes. Guys got to stick together.
 
M

musketman1962

Thank you Conrad, I am going to persevere with this. and I will come back
later, probably a week or so..
thanks again.
 
Top