Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Access FE SQL Server BE (Access 2003 sp2)

    When you use Acess as a FE to SqL Server how important is it to know and use T-SQL and Stored Procedures?

    Typically what are they (T_SQL and stored procedures) used for in this kind of environment?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access FE SQL Server BE (Access 2003 sp2)

    T-SQL is an extension to SQL that lets you "program" in SQL.
    A stored procedure is a saved T-SQL "program".

    In a straightforward migration from Access where you store the data in SQL Server and link your Access frontend to the SQL Server backend, there is no need to use T-SQL and stored procedures. You can use VBA as usual.

    If you want to manipulate the data directly on the server instead of through the Access frontend, you could learn T-SQL.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access FE SQL Server BE (Access 2003 sp2)

    It is not necessary.

    I use pass-through queries, as I can create them on-the-fly on the Access side, so I can easily change parameters.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access FE SQL Server BE (Access 2003 sp2)

    Thank you Hans and Mark.

Posting Permissions

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