P
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
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