Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    13

    Unanswered: .mdb Front -----> SQL Back End

    I would like to do the following:

    1) Create an .MDB (not .ADP) front end using Access 2k.
    2) Use SQL 2k as the back end.
    3) Data access using ADO.
    4) Not use linked tables.
    5) Use either SQL tables or Stored Procedures.

    I'm ok running Stored Procedures or opening recordsets to read, add or delete records. No problem.

    What I would like to do is create Access Reports that use either SQL tables or the output from Stored Procedures as the Record Source.

    Remember. No linked tables.

    Is this possible? Can somebody explain how to do this?

    Thanks.

  2. #2
    Join Date
    Apr 2004
    Posts
    73
    I use Stored Procedures to gather the data for my reports and then use a pass thru query in Access. I use that pass thru query in Access as the datasource for the report.

    I have a much more stable system when I let SQL Server handle everything and then just pass it to Access.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I run a ship very similar to one which you are describing.

    I would heartily recommend looking into using an adp as opposed to an mdb. For starters, as I'm sure you've noticed T-SQL is much easier to work with then JET. Also, you may still use all of the features available in MSSQL Server (security schema, UDF's, triggers etc).

    The report design itself is the same. Which is why we still use access.
    oh yeah... documentation... I have heard of that.

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

  4. #4
    Join Date
    Oct 2003
    Posts
    13
    Teddy,

    I agree with you except I'm having a problem (in my head) giving up the option of creating temporary tables in my Access application.

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You're not giving up temp tables silly!

    You can create temporary tables server-side by prefixing your table name with a '#'

    Depending on what you need the temp tables for, you may even have server side options that will get you around the issue entirely.
    oh yeah... documentation... I have heard of that.

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

Posting Permissions

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