ASP+Access - Need sample code for 3 table Internet/Server based Data Base

[Will]

- I know enough ASP and Access to be dangerous :)
- I need to put up a data base on our web server with 3 related tables.
- They will be accessed by a limited number of people.
- Each user will have to "log on" with a username and password and only have
access to their records.

- Their will be a main table with two associated tables...
- This is not the application but it is simmilar in structure...

Example:
tblOrganization (Organization name, address, phone, fax, business type, etc)
tblOrg_People (people at the Organization... name, email, phone, title, etc)
tblContact_Log (contact history/log... date of last contact... what
happened)

So in practice a user could log on from home... add an orgaization to their
list... add people... and begin making entries in the log for that
orginaztion

Reports could be run by the office on this data for management... as
required.

Question 1 - Can anyone direct me to sample ASP code for a 3 table internet
based application?
Questionn 2 - Since these are going to be on the net do you have to set the
tables up as "related" in Access?
Question 3 - Or should you just create the Access database and create the 3
tables and them upload them... then create your raw sql statements in ASP
for working with the tables ???

Thanks for any help.

[Mike Brind]

"Will" <Wi**@somewhere.comwrote in message
news:45***********************@roadrunner.com...

>- I know enough ASP and Access to be dangerous :)
- I need to put up a data base on our web server with 3 related tables.
- They will be accessed by a limited number of people.
- Each user will have to "log on" with a username and password and only
have access to their records.

- Their will be a main table with two associated tables...
- This is not the application but it is simmilar in structure...

Example:
tblOrganization (Organization name, address, phone, fax, business type,
etc)
tblOrg_People (people at the Organization... name, email, phone, title,
etc)
tblContact_Log (contact history/log... date of last contact... what
happened)

So in practice a user could log on from home... add an orgaization to
their list... add people... and begin making entries in the log for that
orginaztion

Reports could be run by the office on this data for management... as
required.

Question 1 - Can anyone direct me to sample ASP code for a 3 table
internet based application?
Questionn 2 - Since these are going to be on the net do you have to set
the tables up as "related" in Access?
Question 3 - Or should you just create the Access database and create the
3 tables and them upload them... then create your raw sql statements in
ASP for working with the tables ???

Answer 1. What bit do you actually need help with? JOIN queries?
Answer 2. No.
Answer 3. Yes.

--
Mike Brind

[Bob Barrows [MVP]]

Will wrote:

- I know enough ASP and Access to be dangerous :)
- I need to put up a data base on our web server with 3 related
tables.
- They will be accessed by a limited number of people.

<snip>

Question 1 - Can anyone direct me to sample ASP code for a 3 table
internet based application?

Sorry, I can't. There is nothing special about 3 tables as opposed to
1,2,4, or 24 tables

Questionn 2 - Since these are going to be on the net do you have to
set the tables up as "related" in Access?

Whether or not it's on the "net" is irrelevant.
Only create Relationships (foreign keys) between related tables if
1. you want the queries that extract data from these tables to be
optimized
2. you want the database to enforce referential integrity

Question 3 - Or should you just create the Access database and create
the 3 tables and them upload them... then create your raw sql
statements in ASP for working with the tables ???

Huh? As Mike says ... Yes

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[MyEmailList]

I'm guessing here but I think he is asking for sample ASP code that
querries 3-tables using SQL

Something like (To see a Companies record with associated People and
assocated Contact Log records

Select tblMain.Company
where Company = Acme Inc

Select tblPeople
where id.tblCompany = id.tblPeople

Select tblContacts
where id.tblCompany = id.tblContacts

Or some such... but as written in ASP.

You can see I'm not the guy to answer this as I don't do SQL or ASP

And how do you write the username and password ASP so the user can only
see their records??

I wouldn't mind having reference sample code on this myself.

Mel

-----------------------
Bob Barrows [MVP] wrote:

Will wrote:

- I know enough ASP and Access to be dangerous :)
- I need to put up a data base on our web server with 3 related
tables.
- They will be accessed by a limited number of people.

<snip>

Question 1 - Can anyone direct me to sample ASP code for a 3 table
internet based application?

Sorry, I can't. There is nothing special about 3 tables as opposed to
1,2,4, or 24 tables

Questionn 2 - Since these are going to be on the net do you have to
set the tables up as "related" in Access?

Whether or not it's on the "net" is irrelevant.
Only create Relationships (foreign keys) between related tables if
1. you want the queries that extract data from these tables to be
optimized
2. you want the database to enforce referential integrity

Question 3 - Or should you just create the Access database and create
the 3 tables and them upload them... then create your raw sql
statements in ASP for working with the tables ???

Huh? As Mike says ... Yes

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Will]

Thats right... I'm looking for sample ASP and SQL code for working with
multiple tables in an online Access data base... as was just described.

Any help would be good. Thanks.

<My*********@gmail.comwrote in message
news:11*********************@v45g2000cwv.googlegro ups.com...

I'm guessing here but I think he is asking for sample ASP code that
querries 3-tables using SQL

Something like (To see a Companies record with associated People and
assocated Contact Log records

Select tblMain.Company
where Company = Acme Inc

Select tblPeople
where id.tblCompany = id.tblPeople

Select tblContacts
where id.tblCompany = id.tblContacts

Or some such... but as written in ASP.

You can see I'm not the guy to answer this as I don't do SQL or ASP

And how do you write the username and password ASP so the user can only
see their records??

I wouldn't mind having reference sample code on this myself.

Mel

-----------------------
Bob Barrows [MVP] wrote:

>Will wrote:

- I know enough ASP and Access to be dangerous :)
- I need to put up a data base on our web server with 3 related
tables.
- They will be accessed by a limited number of people.

<snip>

Question 1 - Can anyone direct me to sample ASP code for a 3 table
internet based application?

Sorry, I can't. There is nothing special about 3 tables as opposed to
1,2,4, or 24 tables

Questionn 2 - Since these are going to be on the net do you have to
set the tables up as "related" in Access?

Whether or not it's on the "net" is irrelevant.
Only create Relationships (foreign keys) between related tables if
1. you want the queries that extract data from these tables to be
optimized
2. you want the database to enforce referential integrity

Question 3 - Or should you just create the Access database and create
the 3 tables and them upload them... then create your raw sql
statements in ASP for working with the tables ???

Huh? As Mike says ... Yes

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Mike Brind]

http://www.w3schools.com./sql/default.asp
http://www.w3schools.com./asp/default.asp
http://www.w3schools.com./ado/default.asp
http://msconline.maconstate.edu/tuto...SP/default.htm

"Will" <Wi**@somewhere.comwrote in message
news:45***********************@roadrunner.com...

Thats right... I'm looking for sample ASP and SQL code for working with
multiple tables in an online Access data base... as was just described.

Any help would be good. Thanks.

<My*********@gmail.comwrote in message
news:11*********************@v45g2000cwv.googlegro ups.com...

>I'm guessing here but I think he is asking for sample ASP code that
querries 3-tables using SQL

Something like (To see a Companies record with associated People and
assocated Contact Log records

Select tblMain.Company
where Company = Acme Inc

Select tblPeople
where id.tblCompany = id.tblPeople

Select tblContacts
where id.tblCompany = id.tblContacts

Or some such... but as written in ASP.

You can see I'm not the guy to answer this as I don't do SQL or ASP

And how do you write the username and password ASP so the user can only
see their records??

I wouldn't mind having reference sample code on this myself.

Mel

-----------------------
Bob Barrows [MVP] wrote:

>>Will wrote:
- I know enough ASP and Access to be dangerous :)
- I need to put up a data base on our web server with 3 related
tables.
- They will be accessed by a limited number of people.
<snip>
Question 1 - Can anyone direct me to sample ASP code for a 3 table
internet based application?

Sorry, I can't. There is nothing special about 3 tables as opposed to
1,2,4, or 24 tables

Questionn 2 - Since these are going to be on the net do you have to
set the tables up as "related" in Access?

Whether or not it's on the "net" is irrelevant.
Only create Relationships (foreign keys) between related tables if
1. you want the queries that extract data from these tables to be
optimized
2. you want the database to enforce referential integrity

Question 3 - Or should you just create the Access database and create
the 3 tables and them upload them... then create your raw sql
statements in ASP for working with the tables ???

Huh? As Mike says ... Yes

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.