Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Angry Unanswered: link sql server 7.0 table to Access2002

    I try to setup a linked table to SQL Server 7.0 and got an error message:
    "reserved error (-7716); there is no message for this error"

    If the SQL Server 7.0 database has 'guest' user, I don't have the problem.

    Do I have to have 'guest' user in order to use linked table for SQL Server 7.0? My SQL Server 2000 linked table works fine. Thanks -Frank

  2. #2
    Join Date
    Sep 2003
    Posts
    3

    problem solved: table with empty name

    I found the problem: on SQL Server side, there is a table with empty name, I have to drop it with command 'drop table [ ]'. Thanks -Frank

Posting Permissions

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