Monday, March 19, 2012

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! JillJill,

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.68068$Tf1.27575@.tornado.rdc-kc.rr.com...
> 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

No comments:

Post a Comment