L
Lez
Hi Guys,
Access 2007 FE, SQL2005 BE
Can anyone help me with this issue, I am sure I am making a simple mistake,
but cannot see were I am going wrong.
I have an invoice form with a sub form for the line items. The line items
form has 3 tables in the query for the form
SKU_Local
VAT_Local
dbo.View_LineItems
As can be seen the first 2 tables are local tables, created when a user logs
on first thing, as these only changed on a daily basis. The
dbo.View_LineItems is linked directly to the SQL database so the items are
saved live as the order is created.
Previously I used views from the server for SKU & VAT and everything worked
ok, so to improve performance I am now saving some tables locally the
relationships are still on the same fields yet the data is now not
updateable.
Can anyone advise please
Access 2007 FE, SQL2005 BE
Can anyone help me with this issue, I am sure I am making a simple mistake,
but cannot see were I am going wrong.
I have an invoice form with a sub form for the line items. The line items
form has 3 tables in the query for the form
SKU_Local
VAT_Local
dbo.View_LineItems
As can be seen the first 2 tables are local tables, created when a user logs
on first thing, as these only changed on a daily basis. The
dbo.View_LineItems is linked directly to the SQL database so the items are
saved live as the order is created.
Previously I used views from the server for SKU & VAT and everything worked
ok, so to improve performance I am now saving some tables locally the
relationships are still on the same fields yet the data is now not
updateable.
Can anyone advise please