Search results

I am looking at your code (which is a bit complex to me) and it still appears you are updating a local table; which I noted earlier I can do. The issues is I am trying to update the external table (with an insert) with data from the local table. An initial dump of records and then moving...

I am using ODBC connection with a DSN file the IT department setup for me. On the original issue, I was just using a query in access. I tried a pass through query today and it will not recognize the local table (which I am using to update the external SQL table). I found documents online...

I posted the issue below to a SQL forum and was informed I have to set the ARITHABORT setting to ON in the connection string. I have no idea how to alter the connection string of an ODBC via Access. Can someone help? Original email - I am very frustrated and could really use some help. I have...

I am trying to build a form with checkboxes to select which records will pull to an external spreadsheet. There needs to be a separate spreadsheet for each item selected. For example, checking which hospitals I want to include (ie...AMC, BMC, BCS, etc...). The user would check which hospital...