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

Subform Problem After Converting Database Backend to SQL

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?

Thanks

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


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

This discussion thread is closed

Replies have been disabled for this discussion.