Linking Tables From An ODBC Connection To Access video in the “Advanced Programming in Microsoft Access 2013” series hosted by Steve Bishop. In this free …
7. (Advanced Programming In Access 2013) Linking Tables From An ODBC Connection To Access Comments:
Mark Williams: I set the primary key for the Suppliers table in step 5, but I also changed the Identity Specification to Yes because the data type is Autonumber.
Mks Yadav: great video..thanks
nyaworld: I have been following everything you have done until this point….. now I have an issue. I am using a VBA code that writes changes made to my data. The code works beautifully (as long as it updates a local table). I can’t figure out how to refer to my linked table successfully. (ODBC error). So, I thought maybe I can take the local table and append it to a linked table (linked to my sharepoint azure SQL database). The information flows from my access web app to my local database just fine. I am creating forms and reports just fine, I can even update and add new records via a form, but I can’t append to linked table, nor do I know how to call that table in a VBA code.Any help you can provide will be appreciated!Here’s the code I’m using for auditing changes that users make locally…. .fontstuff/access/acctut21.htm
saeed: hi can i share access file to 20 computer without installing the form in each computer and link it to access table. plz help in this. what if i updated the form