Access tables transferred to SQL Server are set to "read only." How do I correc

I created an Access project and transferred some tables from my .mdb Access
database into an existing SQL Server database. Now, the tables are "read
only" meaning that I can't add/modify/delete data in the tables. But, when
I open the same SQL Server database, from the same desktop, using EM I can
add/modify/delete data in the SAME table.
Where should I look?
TIA,
Larry Woods
Create a primary key/unique index on the tables in question. Access
refuses to update SQLS tables otherwise.
--Mary
On Wed, 28 Jul 2004 07:18:35 -0700, "Larry Woods"
<larry@.NOSPAMlwoods.com> wrote:

>I created an Access project and transferred some tables from my .mdb Access
>database into an existing SQL Server database. Now, the tables are "read
>only" meaning that I can't add/modify/delete data in the tables. But, when
>I open the same SQL Server database, from the same desktop, using EM I can
>add/modify/delete data in the SAME table.
>Where should I look?
>TIA,
>Larry Woods
>

Access tables transferred to SQL Server are set to "read only." How do I co

I created an Access project and transferred some tables from my .mdb Access
database into an existing SQL Server database. Now, the tables are "read
only" meaning that I can't add/modify/delete data in the tables. But, when
I open the same SQL Server database, from the same desktop, using EM I can
add/modify/delete data in the SAME table.
Where should I look?
TIA,
Larry WoodsCreate a primary key/unique index on the tables in question. Access
refuses to update SQLS tables otherwise.
--Mary
On Wed, 28 Jul 2004 07:18:35 -0700, "Larry Woods"
<larry@.NOSPAMlwoods.com> wrote:

>I created an Access project and transferred some tables from my .mdb Access
>database into an existing SQL Server database. Now, the tables are "read
>only" meaning that I can't add/modify/delete data in the tables. But, when
>I open the same SQL Server database, from the same desktop, using EM I can
>add/modify/delete data in the SAME table.
>Where should I look?
>TIA,
>Larry Woods
>