Subform Problem After Converting Database Backend to SQL

[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?

Thanks

[Rick Brandt]

Lynx101 wrote:

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?

Thanks

Did you create primary keys in all the tables on SQL Server?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com