Search results

As a follow-up to this issue...I was able to fix this problem by manually forcing the Office Updates to download and run. Even though their IT said that they run all updates automatically, I searched for the latest updates for Office 2016 and ran them. After the updates, all views linked normally.

I believe it has the correct permissions because I can access the data via a pass-through query but I will double check. We normally give 'owner' permissions to our standard login credentials. These same login credentials are used for the pass-through as are used in the DSN.

Sorry, I noticed that I misspelled your name. Thanks, Minty.

Thanks, Mindy. I checked the ODBC Driver version and both locations are using the default v6.01.7601.17514 SQL Driver. I also installed the latest Microsoft driver v13 on the client PC and it gave the save error. I also installed Access 2016 in my test environment and it worked fine in...

I have a procedure that runs to update the links to SQL Server tables and views that uses the RefreshLink method in Access VBA. I am now getting an error (Error: 3001 Invalid Argument) when some of the views in SQL Server attempt to relink. I tried to use the 'linked Table manager' to relink it...

Thanks, Banana for your quick response. So if I understand you correctly, if I add the conditional compilation code, the app can be compiled for both 32 bit and 64 bit Access versions. I assume that means that I would need to make the .MDE file for Access 64 bit on that machine and for 32 bit...

I have an app the was written in Access 2003 and is used by customers using various versions of Access and various OS versions. Recently, one customer installed a new PC with Office 2010 64 bit and the Access application does not run on it. Everything I have found seems to suggest that...