ODBC – insert on a linked table ’table_machine’ failed

[jubiiab via AccessMonster.com]

My Access .mdb file tables are linked to an SQL server. I can update all my
data in different tables but when I want to insert a new record I get this
message:

ODBC – insert on a linked table ’table_machine’ failed

What is wrong???

And when I want to delete a record I get this message:
The do MenuItem was canceled

 

[golfinray]

Does the linked table manager allow you to refresh the tables? Are the tables
all linked? Open a new Access database, go to file\new, and select ODBC
connection and see if it connects to your server and gives you your table
list. Are your tables editable (the arrow and asterisk at the bottom are not
grayed out?)

 

[jubiiab via AccessMonster.com]

Yes it allows refreshing tables and all my tables are linked. I also made a
new database and I got connection to those tables.

I have one form (named budget) where I can update, delete and insert records
with no problem. But I have two other forms (named Maintenance and
Registration form) where I can update data but can not insert a new record or
delete a record.

In the Maintenance form/table I have a note field (datatype memo in access).
In SQL this datatype is now “text†and the length is 16. Is this have
something to do with it???
The primary key in the Maintenance table is not auto numbering.... can that
have somethin to do with it???

In the registration form I do have a primary key with auto numbering. I also
have a note field (datatype memo in access) and few checkboxes (datatype:
yes/no in access). In SQL the datatype is bit and the length is set to 1. Is
this is the reason why I can’t add a new record or delete it??? Please I
really need some help thx.

Does the linked table manager allow you to refresh the tables? Are the tables
all linked? Open a new Access database, go to file\new, and select ODBC
connection and see if it connects to your server and gives you your table
list. Are your tables editable (the arrow and asterisk at the bottom are not
grayed out?)

My Access .mdb file tables are linked to an SQL server. I can update all my
data in different tables but when I want to insert a new record I get this

[quoted text clipped - 6 lines]

And when I want to delete a record I get this message:
The do MenuItem was canceled

 

[jubiiab via AccessMonster.com]

I have found out that the bug only occurs when I do not fill my comboboxes.
If I keep those comboboxes empty I can not save a new record in SQL. It
worked in MS Access???

My comboboxes are connected to tables. Is there a way where I can keep a Null
value in comboboxes? On the SQL server I have checked the Null value in the
checkbox.

Yes it allows refreshing tables and all my tables are linked. I also made a
new database and I got connection to those tables.

I have one form (named budget) where I can update, delete and insert records
with no problem. But I have two other forms (named Maintenance and
Registration form) where I can update data but can not insert a new record or
delete a record.

In the Maintenance form/table I have a note field (datatype memo in access).
In SQL this datatype is now “text†and the length is 16. Is this have
something to do with it???
The primary key in the Maintenance table is not auto numbering.... can that
have somethin to do with it???

In the registration form I do have a primary key with auto numbering. I also
have a note field (datatype memo in access) and few checkboxes (datatype:
yes/no in access). In SQL the datatype is bit and the length is set to 1. Is
this is the reason why I can’t add a new record or delete it??? Please I
really need some help thx.

Does the linked table manager allow you to refresh the tables? Are the tables
all linked? Open a new Access database, go to file\new, and select ODBC

[quoted text clipped - 6 lines]