Dear Sir

I am trying to conenct sql 2000 database to access project. I could able to
connect , all the tables are visible in the adp file
But I am unable to make any design changes, editing table values etc.
All tables are read only.

All other database files, I can connect and edit data exept one database
file. I could not figure out what is the reason. How I can set the
connection to read and write the data , and able to change the data base
designs.

Please help


Rgds

Ramesh Shetty

"Shetty" <rameshmshetty (AT) gmail (DOT) com> wrote

Access can only edit tables that have a primary key defined, so first check
that all tables you are testing have a primary key defined in SQL Server.
Then you could verify that your user account, assuming you are using Windows
authentication, or your SQL Server account if using SQL authentication,
exists as a user with appropriate permissions for that database.

Being able to make design changes depends on the sql and Access versions. An
Access project can generally make design changes in any version of SQL
Server that existed before the Access version was released, but not in any
later SQL Server version. So for SQL 2000 you would need at least Access XP
or maybe Access 2003.