Access 2000 project

#1

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

#2

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 (AT) kc (DOT) rr.com> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access 2000 project

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Access 2000 project - 05-11-2006 , 07:04 AM

Re: Access 2000 project - 05-13-2006 , 08:16 PM