lol, Okay I just remembered something, do I have to link these two tables in say EM, do I have to assign a primary kay, secondary key and all that stuff. Because I can't get anything to work

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

This is all I get. When a record is inserted into Table2, EventId is updated in both tables. So I thought that is all I would need, but I get the error on this line
objAuthorsAndBooks.ActiveConnection = MyConnectionString

-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason

Design-wise it's a very good idea to enforce these relation ships in the database, for this example it's not required. If you add the relations in the database, you can be sure you'll never add an item in table 2 that doesn't have a match in table 1.

How does your table structure look like? And your current SQL statement? If you run the SQL in the database (query analyzer) directly, do you get any results?

Can you post relevant parts of your code?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Also, did you change MyConnectionString to a suitable connection string??

Imar

"out of exceptable range"? Did you try replacing "cn" with whatever variable your connection string is set to?

MsSql Example:
set cn = server.createobject("adodb.connection")
cn.connectionString = "provider=sqloledb.1; user id=YourUserName; password=YourPassword; data source=MachineName; initial catalog=DatabaseName"
cn.mode=1
cn.cursorlocation=3
cn.open

MsAccess Example:
set cn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\YourDatabase.mdb;User Id=YourUserName;Password=YourPassword;"

Okay here is my code with the SQL statment I was using. What do you mean by a suitable connection string? I just changed the name to somehting realated to the tables.
But it wont go past this line
  "objEvents.ActiveConnection = CSRaceResults"

<%
    SQLStr="SELECT * FROM ABNRaceResults inner join ABNYachtClub on ABNRaceResults.EventId = ABNYachtClub.EventId"
    Set RS=Server.CreateObject("ADODB.Recordset")
    RS.Open SQLStr,Application("DBConn"),adOpenKeyset,adLockPe ssimistic,adCmdText

  Dim objEvents
  Dim rsEvents

    Set objEvents = Server.CreateObject("ADODB.Command")
  objEvents.ActiveConnection = CSRaceResults
  objEvents.CommandType = &H0001
  objEvents.CommandText = "SELECT ABNYachtClub.Event, ABNRaceResults.BoatName, " & _
        "ABNRaceResults.SailNum FROM ABNYachtClub INNER JOIN ABNRaceResults on ABNYachtClub.EventId = ABNRaceResults.EventId ORDER BY ABNYachtClub.Event"
  Set rsEvents = objEvents.Execute()
  Set objEvents = Nothing
  With rsEvents
    Dim OldEventName
    If Not .EOF then
      ' Loop through entire recordset with duplicate author data and books
      Do While Not .EOF
        ' Are we displaying the same Event as the previous record?
        ' This will not be the case for the first record
        ' and also not when you "switch" Events.
        If .Fields("Event").Value <> OldEventName Then
          ' No, so display Event name, and update OldEventName variable
          OldEventName = .Fields("Event").Value
          Response.Write("<h2>" & .Fields("Event").Value & "</h2>")
        End If
        ' Now display the Placing stuff
        Response.Write(.Fields("BoatName").Value & "(" & _
               .Fields("SailNum").Value & ")<br />")
        .MoveNext()
      Loop
    End If
    .Close
    Set rsEvents = Nothing
  End With
%>

-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason

And how do you think your application knows where to look for the data? How do you think it finds your Access database or SQL Server database??

The ActiveConnection property needs an open connection object, or a connection string. Simply assigning a good sounding variable name isn't good enough..... ;)

For connection string examples, look here:

SQL Server
http://www.able-consulting.com/MDAC/...erForSQLServer

Access
http://www.able-consulting.com/MDAC/...orMicrosoftJet

CSRaceResults.Open "Provider=sqloledb;" & _
           "Data Source=myServerName;" & _
           "Initial Catalog=myDatabaseName;" & _
           "Integrated Security=SSPI"

Would I use it like this? Then fill in my DB and Server Name. I treid it and I get an

Object required: "

Error on the first line.

-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason

After reading this again, I see you're mixing up two things: you're using code that opens a Recordset directly, while I use an intermediate Command object to get the data. You can drop the command object and use your own Recordset stuff, like this:     assuming that I copied the right SQL statement.

Cheers,

Imar

Wow, I think that's right :-). That's why I was getting confused I knew I was already connected to the database. I think it's working now, but I am of for the day so I will check back tomorrow.

Thanks a lot for your help, you are the man!!!

-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason

Imar, who are you referring to?