how to Update ODBC linked tables on ms access

[vince1818]

Hi All -

Does anyone know how to Update ODBC linked tables on ms access? Really appreciate any insights. Thanks in advance!

 

[JHB]

What problem do you have?
Read post #10 in the below link:
http://www.dbforums.com/showthread.php?1666675-How-to-Update-ODBC-linked-tables-on-Access

 

[vince1818]

Thanks JHB.

Im not an expert with access. Im not sure where to copy the code in ms access. I tried to find the tabledefs but couldnt locate it. When you get a chance, will you let me know? Thanks!

 

[JHB]

Maybe I misunderstood your question, do you want to change/update data in your table(s) or what do you want?

 

[vince1818]

Hi,

Im trying to update the tables from the ODBC so it will have realtime data. Sorry for the confusion. Hope to hear back from you. Thanks!

 

[JHB]

Do you not get that if you create a form and set the recordsource to the table, like it was written in the link?

1. If you want to update the contents of a table from a form, the simplest way consist in binding the form to the table (or to a query based on the table) - property: RecordSource, then to bind the controls of that form (TextBox controls, etc.) to the columns (fields) of the bound table or query - property: ControlSource.