Recordset question

Results 1 to 2 of 2

Thread: Recordset question

  1. #1
    Join Date
    Dec 1969

    Default Recordset question

    This question may seem somewhat easy, but it is causing me problems and I can&#039t seem to find a solution. My table in my database is called &#039Mypage Members&#039. I have been trying to connect to it using the code below.<BR><BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Op en "SELECT * FROM Mypage Members", objDC, 0, 1<BR><BR>My question is, how do I phrase this code to take into account the space between Mypage and members? I am assuming this is the cause of my connection problem.<BR><BR>Thanks for your help,<BR>Frank.

  2. #2
    Steve Cimino Guest

    Default RE: Recordset question

    You shouldn&#039t include spaces in ANY of your names...<BR><BR>Having said that, that&#039s not what you asked. Do this:<BR><BR>SELECT * FROM [Mypage Members]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts