how to set permissions on tables - SQL LINK

G

Gary

I have access tables which have been linked to my sql database. When i linked
the tables i seem to have lost my permissions on the databases. Now i can not
insert/update records in the access tables (which are linked to my sql
tables). Does anyone know how to give me back these permissions.

note: the sql tables that the access tables are linked to still have these
permissions but not when i go through access
 
J

John Vinson

I have access tables which have been linked to my sql database. When i linked
the tables i seem to have lost my permissions on the databases. Now i can not
insert/update records in the access tables (which are linked to my sql
tables). Does anyone know how to give me back these permissions.

note: the sql tables that the access tables are linked to still have these
permissions but not when i go through access
Click to expand...

One common reason that SQL tables cannot be updated from Access is
that you MUST have a primary key, and it must be defined to Access as
the primary key.

Do your SQL tables all have primary keys, and did you specify that the
field is a unique identifier in the link to Access?

John W. Vinson[MVP]
 
Top