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

- 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.

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

"Will" wrote in message
news:45aceec1$0$27067$4c368faf@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

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

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.

> 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.

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

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.
>
> > 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.

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

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.

wrote in message
news:1168969421.437719.60570@v45g2000cwv.googlegroups.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.
>>
>> > 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.
>

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

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/tutorials/ASP/default.htm



"Will" wrote in message
news:45ad7eb4$0$16703$4c368faf@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.
>
> wrote in message
> news:1168969421.437719.60570@v45g2000cwv.googlegroups.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.
>>>
>>> > 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.
>>
>
>