var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ODBC linked tables & RECORDSET Method
I have a problem with a MS Access 2003 database.
There are ODBC linked tables in my database, there is no problem to use/update theses tables with a form or directly in the table.
But I would like to add reccord in my tables with the recordset method .. .but it doesn't work .. I have the following error : "error 3146 ODBC--Call Failed" on the update command
This is my code :
set db = DBEngine.Workspaces(0).Databases(0)
set rs = db.OpenRecordet("INVENTORY")
Could you please let me know what's wrong or witch procedure do I have to use to add reccord in this table?
Thank you so much for your help!!!
set db = CurrentdB
set rs = db.OpenRecordet("INVENTORY",dbOpenDynamic)