Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Location
    Westfield, NJ, USA
    Posts
    23

    Unanswered: Access 2002 (or 97 or 2000) and SQL Server 2000

    Situation :
    SQL Server 2000 Ent. (SP2) - where the data is intended to be - as a back-end - on NT4 Server (SP6).
    Access 2002 as a front-end.
    Windows (Server) authentication is used.

    One of the Access tables is a table linked to an SQL Server table.
    SOL Server table is "read", "write" and everything in between.
    Users are authorised do do everything and yet, table on the Access side of the works is READ ONLY.

    Does anyone (PLEASE!) know why?

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    Is it indexed?

  3. #3
    Join Date
    Mar 2002
    Location
    Westfield, NJ, USA
    Posts
    23
    Thanks!
    Now it is and now it works!

Posting Permissions

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