I am currently using a database to populate a calendar that I have created 

from ASP.  I am reading in holidays, birthdays, meetings, etc... to the 

asp 

page from an Access database.  All goes well except for some of the 

recordsets in the Access tables are not being read at all.  I have four 

recordsets in each table.  One for day, one for color (to color code the 

calendar), one for 2001 and one for 2002.  In two cases it only reads from 

the first fields in the recordsets then ignores the rest. I thought I 

might 

need to update my data source but that did not help.  I deleted out the 

fields for the recordsets that were not working and reentered but that did 

not help.  In one case it reads from the 2001 recordset just fine but only 

reads the first field in the 2002 recordset and ignores the rest.  Any 

suggestions would be appreciated.



Thank you

<sigh>



It's not working because something is wrong.



Cheers

Ken



PS If you take the time to provide us with information that can help us help

you, we might.

http://www.adopenstatic.com/personal/help.asp

what is your table structure? what is the relevant code that is not working?

under what conditions does the code work, and when doesn't it? what is your

server setup? etc.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Jonathan" <jnixon@c...>

Subject: [access_asp] Access database not sharing all information





: I am currently using a database to populate a calendar that I have created

: from ASP.  I am reading in holidays, birthdays, meetings, etc... to the

: asp

: page from an Access database.  All goes well except for some of the

: recordsets in the Access tables are not being read at all.  I have four

: recordsets in each table.  One for day, one for color (to color code the

: calendar), one for 2001 and one for 2002.  In two cases it only reads from

: the first fields in the recordsets then ignores the rest. I thought I

: might

: need to update my data source but that did not help.  I deleted out the

: fields for the recordsets that were not working and reentered but that did

: not help.  In one case it reads from the 2001 recordset just fine but only

: reads the first field in the 2002 recordset and ignores the rest.  Any

: suggestions would be appreciated.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Some of your code would help us help you identify the problem.



spence

----- Original Message -----

From: Jonathan <jnixon@c...>

To: Access ASP <access_asp@p...>

Sent: November 8, 2001 11:07 PM

Subject: [access_asp] Access database not sharing all information





> I am currently using a database to populate a calendar that I have created

> from ASP.  I am reading in holidays, birthdays, meetings, etc... to the

> asp

> page from an Access database.  All goes well except for some of the

> recordsets in the Access tables are not being read at all.  I have four

> recordsets in each table.  One for day, one for color (to color code the

> calendar), one for 2001 and one for 2002.  In two cases it only reads from

> the first fields in the recordsets then ignores the rest. I thought I

> might

> need to update my data source but that did not help.  I deleted out the

> fields for the recordsets that were not working and reentered but that did

> not help.  In one case it reads from the 2001 recordset just fine but only

> reads the first field in the 2002 recordset and ignores the rest.  Any

> suggestions would be appreciated.

>

> Thank you