By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,438 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Cannot update Subform after converting to an SQL backend.

P: n/a
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?

May 18 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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?
May 18 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.