How can I open two tables at once,
I tried this code but it didn't worked for me:

vb Code:
  1. Dim rs As ADODB.Recordset

  2.     Set rs = New ADODB.Recordset

  3.     rs.CursorLocation = adUseClient

  4.     rs.CursorType = adOpenStatic

  5.     rs.LockType = adLockReadOnly

  6.     rs.Open "SELECT * FROM avatar,singleplayername", conn, adOpenStatic, adLockOptimistic

  7.     

  8.     swfUserProfile.SetVariable "txtPlayerName", rs!playerName

  9.     swfPictureAvatar.LoadMovie 1, rs!avatarFile

  10.     swfPictureAvatar.Movie = rs!avatarFile

  11.     

  12.     rs.Close

  13.     Set rs = Nothing

Need Help