I'm new at this and so just testing a very simple access Append query to add an account. I have the tables linked from QBES , copied the structure of the table to another table, tblAcct, input one record into that table and am trying to append that record to QBES. The query looks like this :
INSERT INTO Account ( ListID, Name, IsActive, FullName, AccountType, AccountNumber ) SELECT tblAcct.ListID, tblAcct.Name, tblAcct.IsActive, tblAcct.FullName, tblAcct.AccountType, tblAcct.AccountNumber FROM tblAcct;
I get the error ODBC - Insert on a linked table 'Account' failed.
[ODBC]Field not allowed in insert. (#10046).
Is there a book or other resources that goes over any of this that you recommend?
|