Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    2

    Angry Unanswered: New to SQL Server

    Can somebody please help me. I've got a SQL Server database, with an Access front end. Some of the linked tables can be edited and some not. Yeah....I know they are read only, but how do I get rid of the read only property?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    How about the permissons for those linked tables?
    How does this read-only property set?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    2

    Red face Read only problems

    I have created the table on the server so that everybody has permission to read and write to this table, but when you open the table as a linked table in Access you cannot add anything to the table. According to Access the table is read only(I have restarted SQL server as well, and relinked the table...nothing helps)

Posting Permissions

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