ADP project is ReadOnly after using Upsizing Wizard

[RNA]

I have upsized an access 2000 db file on my development
ws (using the Access 2003 upsizing wizard) to an instance
of SQL Server 2000 on a Windows 2003 Business Server.
When I open the .adp file in Access 2003, all of the
tables are ReadOnly. When I use the enterprise manager
(on the same ws) the tables are ReadWrite enabled. Is
there some permission setting that needs to be set in the
adp file or on the SQL Server to make the tables Readable
and Writeable?

 

[Mary Chipman]

You need to have a primary key or unique index defined on tables you
wish to update through Access.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

 

[Guest]

That was it. The database I upsized was from a client and
I never looked to see if the tables had primary key or
guid fields. I added a primary key to one table in the
SQL version, opened the ADP project, opened the edited
table and viola...it was readwrite.

Thank You...