Unable to edit data in SQL backend table

  • Thread starter Thread starter amywolfie
  • Start date Start date
A

amywolfie

I am using Access as a frontend for several SQL tables linked in via
ODBC.

I am able to edit data in all tables except for one. A new field was
added as a bit, but will not permit editing either as a checkbox,
text, or number field in SQL.

I have these SQL bit fields on other Access forms and I am able to
check the checkbox.

Thanks.
===
 
Who added that field?

Were permissions granted in the SQL-source?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Some versions of Access and SQL Server had problems if a SQL bit field
allowed nulls. Try setting the field to no nulls and if possible assign a
default value. I've been able to use bit fields in all recent versions of
Access and SQL Server. Also make sure the table in question has a primary
key defined. Without that Access can't edit.
 
Back
Top