Access 2003 Pass through Queries to SQL 2K

• jay.l.100

  Old Hand

  Points: 370

  More actions

  October 14, 2008 at 7:56 pm

  #71367

  I have an app written in access that moves data from one database to another via linked tables. The code is written in a VB module.

  Should I be using T-SQL standards or access standards?

  For example

  using AS when referencing a table name

  using # to delimit dates or

  using * with a LIKE

  -Thanks,

  -J

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  October 14, 2008 at 9:39 pm

  #885002

  Straight T-SQL will not fully run in Access directly so, program for Access.

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot