Results 1 to 8 of 8

Thread: SQL and Adp

  1. #1
    Join Date
    Sep 2002
    Posts
    4

    Unanswered: SQL and Adp

    I have a Microsoft Access ADP database linked to my SQL 2000 server.

    I am trying to create a View based on an input from I have in the ADP database. The form has a FromDate and a ToDate.

    How do I create a view that pulls the dates from my input table?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Step 1. Unlink SQL from ADP
    Step 2. Delete ADP database
    Step 3. Use real tools (VB, C#, Delphi, etc.) with SQL

  3. #3
    Join Date
    Sep 2002
    Posts
    4
    Originally posted by rdjabarov
    Step 1. Unlink SQL from ADP
    Step 2. Delete ADP database
    Step 3. Use real tools (VB, C#, Delphi, etc.) with SQL
    How very kind of you. I have certain tools available, and no formal training in anything you are speaking of. I have to make do with what I have. However. your sarcasm is very helpful. Ass.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Sorry, I REALLY couldn't resist

    Create a pass-through query and pass values of those 2 fields to it.

  5. #5
    Join Date
    Sep 2002
    Posts
    4
    Originally posted by rdjabarov
    Sorry, I REALLY couldn't resist

    Create a pass-through query and pass values of those 2 fields to it.
    Well, I am glad to see you know even less about the Access ADP then I do. The ADP links into the SQL server and uses SQL coding, not Access VBA. It uses the same language as SQL for Views, Stored Procedures, etc.

    Allegedly, one of the strongpoints, is that you get the power of SQL with the ease of Access.

    So, I am hoping to create a view, which is SQL, that uses an Access form as the date criteria.

    Can anyone help?

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Instead of creating a view, look into table-valued functions, and see if passing parameters to them would be easier.

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    ...Oh, and I'm glad I know less of ADP, it actually pays to know less of it

  8. #8
    Join Date
    Nov 2003
    Location
    Romania
    Posts
    70
    My be help you

    SQLString="SELECT * FROM YourTable" & _
    "WHERE ([Data] BETWEEN CONVERT(DATETIME," & _
    "'" & Format(BeginDate, "yyyy-mm-dd") & "'" & ", 120) AND CONVERT(DATETIME," & _
    "'" & Format(EndDate, "yyyy-mm-dd") & "'" & ", 120))"

Posting Permissions

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