Cannot update Subform after converting to an SQL backend.

[Lynx101]

Hi, Hope you can help?

Senario: I have an access frontend and backend database. All is
working fine when using MS Access for both.
Problem: I have created a backend SQL database in preparation to
replace the Access backend database. After I link (via ODBC) to the
new SQL tables one of my subforms no longer allows me to add records.
For example, the main form stores equipment. I have a subform
(datasheet) that allows me to assign stock used for that peice of
equipment. 3 Tables manage the assignments:
Equipment_Table
Stock_Table
StockAssignments_Table
The Subform(database) uses the StockAssignments_Table to record the
stock I am allocating to the equipment. I can see no errors or
warnings on the status bar so I am at a total loss as to why this
will
not work anymore using a SQL backend. I have checked the data types
on
the SQL tables and everything looks ok.
Have anyone seen this before?

[Tom van Stiphout]

On 18 May 2007 03:02:36 -0700, Lynx101 <ma**********@gmail.comwrote:

Ensure the SQL database has a primary key on each table.
-Tom.

>Hi, Hope you can help?

Senario: I have an access frontend and backend database. All is
working fine when using MS Access for both.
Problem: I have created a backend SQL database in preparation to
replace the Access backend database. After I link (via ODBC) to the
new SQL tables one of my subforms no longer allows me to add records.
For example, the main form stores equipment. I have a subform
(datasheet) that allows me to assign stock used for that peice of
equipment. 3 Tables manage the assignments:
Equipment_Table
Stock_Table
StockAssignments_Table
The Subform(database) uses the StockAssignments_Table to record the
stock I am allocating to the equipment. I can see no errors or
warnings on the status bar so I am at a total loss as to why this
will
not work anymore using a SQL backend. I have checked the data types
on
the SQL tables and everything looks ok.
Have anyone seen this before?