Access 2000 project

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • JA
    #1

    Access 2000 project

    Hi,

    I am using Access 2000 to access a SQL Server 2000 database. The records are
    read only, and I can't make any changes to them. How can I change this? I've
    checked Help, but don't seem to be able to find what I need to know.

    Thanks! Jill


    Tags: None
    • Oscar Santiesteban
      #2
      Re: Access 2000 project

      Jill,

      Make sure the tables in SQL Server had a "primary key". If it does not,
      Access can not modify the records. I hope this solves your problem.

      Oscar...

      "JA" <jarmour@kc.rr. com> wrote in message
      news:tLF8g.6806 8$Tf1.27575@tor nado.rdc-kc.rr.com...[color=blue]
      > Hi,
      >
      > I am using Access 2000 to access a SQL Server 2000 database. The records[/color]
      are[color=blue]
      > read only, and I can't make any changes to them. How can I change this?[/color]
      I've[color=blue]
      > checked Help, but don't seem to be able to find what I need to know.
      >
      > Thanks! Jill
      >
      >[/color]


        Comment

        Previous template Next
        Working...