Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    CT
    Posts
    8

    Unanswered: Reading SQL server via Access

    I am using Access 97 as a front end to a SQL server database.

    On a relatively simple SQL statement (only hitting one table, less than 4 conditions in the WHERE clause), Access gets a timeout error.

    The Access database is not on the same machine as the SQL database.

    Any thoughts?

    Thanks
    Tim

  2. #2
    Join Date
    Dec 2003
    Posts
    454

    network issue

    That may be related to the network issue since your both databases are not on the same server.

Posting Permissions

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