By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,767 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,767 IT Pros & Developers. It's quick & easy.

Access 2000 project

P: n/a
JA
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
May 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <ja*****@kc.rr.com> wrote in message
news:tL*******************@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

May 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.