Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unanswered: Access Project with SQL Server backend

    In an Access Project with SQL Server backend, are program codes (ADO-based) written differently from MDB files ?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    program codes? I'm not sure what you're asking. You don't have to change the way you manipulate recordsets if that's what you mean. ADO is ADO is ADO, it's a unified specification. You will need to change the underlying SQL used to create your recordsets though. TSQL has some distinct differences compared to JET, luckily it's also far superior.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    the user language language behind Access remains constant irrespective of what data mechanism you use (whether it be JET, MS SQL Server, MySQL or whatever)

    the SQL may change, the way of accessing the information may (and should) change for server back ends. its a different design paradigm. do as much of the datamanipulation on the server, not the client PC, effectively use as few queries within access as possible, pass as manyt queires as possible as ADO recordsets not native JET queries.

    HTH
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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