Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Glasgow, Scotland
    Posts
    107

    Unanswered: Linking SQL Server to Access MDB File

    Hi,

    I am using an MDB file to talk to a SQL Server. I would like to use pass-through queries to keep as much of the processing on the server as possible. However, I have been told that the results of such queries will be read-only. How do I keep the processing on the server but generate read-write answers to my queries?

    Thanks
    Matt

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Go thru this link : http://www.databasejournal.com/featu...le.php/3085211 about step by step for LS.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Location
    Glasgow, Scotland
    Posts
    107

    Re: Linking SQL Server to Access MDB File

    Thanks. I am starting afresh with new tables etc. built in SQl Server and then using an Access front end (MDB not ADP), I am not linking SQL Server to tables in Access.



    Originally posted by mmcdonald
    Hi,

    I am using an MDB file to talk to a SQL Server. I would like to use pass-through queries to keep as much of the processing on the server as possible. However, I have been told that the results of such queries will be read-only. How do I keep the processing on the server but generate read-write answers to my queries?

    Thanks
    Matt

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    This is the easiest way to run thru the queries between Ms access & SQL using distribued queries.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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