Query Uneditable connected to SQL Backend

[pete.trudell]

To expand our Database we linked our Access 2007 frontend with an SQL
Server Express Tables backend. All seems to work fine, all menues
work and after renaming Tables in Queries all queries work! Except
one.

I have a table based on to joined tables Logins with the list of all
staff names, Login,teams, Status (Active/Inactive). The other table
posts Leave. Includes Request No,Login, Start Date, End Date, Type
leave, hours, etc.

The join is based on the unique login number assigned to each staff
member. Each table has this login field.

Everytime I run the query I get my complete list, but I can not add
records. I rebuilt the query still no go. This has become a very
painful process, appreciate any help here.

Pete

 

[Stefan Hoffmann]

hi Pete,

The join is based on the unique login number assigned to each staff
member. Each table has this login field.
Everytime I run the query I get my complete list, but I can not add
records. I rebuilt the query still no go. This has become a very
painful process, appreciate any help here.

Each table used for the join must have a primary key. The fields of the
primary keys must be part auf the SELECT <fieldlist>.

Check your linked tables in Access, switch to design view: the primary
key symbol must be shown for one or more columns in each table.

btw, you may consider adding a TIMESTAMP field to each SQL Server
located table as this may speed up querying against the server and avoid
some of the "someone has altered the data" messages.

mfG
--> stefan <--