Hello,

Could someone help me with this?
I am developing an online calendar. The calendar has 5 fields. The 5 
fields are:
Date Topic Speaker Credits    View Detail     Register. All these fields 
are populated using MS access.  The Topic field has the name of the topic. 
The View Detail field should provide a link a user to download a word 
document. The word document will provide more detail to the user. All 
these fields should be populated fro the database. The view details field 
should contain the location of the Word document so once it is clicked the 
files automatically gets downloaded.

Since they are numerous Topics I?II have to store all the documents in a 
directory so they can be downloaded when appropriate. Is this possible?
This is my code:

'Create and open the Connection object. 
Set OBJdbConn = Server.CreateObject("ADODB.Connection") OBJdbConn.Open 
sConnStr SQLQuery = "SELECT * FROM Speakers" 'First Recordset 
RsSpeakersInfo Set RsSpeakersInfo = OBJdbConn.Execute(SQLQuery) %>

Do While Not RSSpeakersInfo.EOF
<TR CLASS=tbody align = center>
<%= RSSpeakersInfo("Seminar Date")%>
<%= RSSpeakersInfo("SeminarTopic")%>
<%= RSSpeakersInfo("SpeakerLast")%>
<%= RSSpeakersInfo("Credits")%>
<%= RSSpeakersInfo("Location")%>
</tr>