Search results

Thanks pbaldy

When I connect using a DSN file the ODBC connection is the following without any reference to DSN on my machine: 1) ODBC;DRIVER=ODBC Driver 17 for SQL Server;SERVER=DESKTOP-5FFFFFF;Trusted_Connection=Yes;APP=Microsoft Office;DATABASE=NewBrunswick;;TABLE=dbo.Employees When I connect using User...

Hello MS Access Expert, If I have ODBC Driver 17 for SQL Server in the ODBC connection string I presume that would require me to install this driver on the client's machine? However, suppose the client gets a new computer later on and it has ODBC Driver 18 installed. Will that break my ODBC...

I just learned that creating the ODBC connection via a DSN file makes the links DSNless. Why the need for the DSNless code that I referenced?

Thank you so simple. :) For multiple ODBC links the code below works well but the code is basically deleting the table definition and recreating it without DSN in the connection string. I already have this code in the program so I will use it as a solution...

Hello MS Access Expert, I noticed that when I delete a field from the SQL Server table the ODBC connection subsequently breaks. Additionally, if I add fields to the SQL Server Table the ODBC connection does not break but the newly added fields do not show up. The only solution that I have...

Hi Minty, Eval () resolved the issue. Thank you. I am curious however, why is the Eval necessary?

Let me know if the video explains the issue clearly. I am very curious why this inconsistent behavior is occurring. The recording volume is very dim for some reason so please max out the volume. :)

Hi George, I am demonstrating that when I use a Form Parameter (forms]![frmA]![dtmBirthday]) in the Where Clause on Access Tables everything works as expected but when I migrate the two tables to SQL Server I get a different result. I'll try to make a video.

AccessBlaster if you mean the data within the two tables is not consistent that is by design to demonstrate the issue.

Hello MS Access Expert, I am experiencing different query results when linked to SQL Server Tables, specifically, when I hard code criteria vs. a Form Reference. Note I don't experience this discrepancy when using Local MS Access Tables. I have attached the example database as a Zip. I have...

Thanks amorosik, VCS and WinMerge work great together.

Amorosik, How do you use Vcs for the purpose of comparison between different versions? I used to compare databases using FMS detective but it is no longer being updated for the latest versions of MS Access. Thanks.

I like to put Error Handling even into very basic methods because we often use the Runtime Environment and I also want every error emailed to us. Thanks for recommending vbWatchdog. I am little surprised by the CAD $295 price compared to MZ Tools USD $79.95.

That's it! MZTools. I was looking up NZ tools and couldn't find it :) Thanks Moke. I noticed MZTools has "Insert Exception Handler" but it appears this is a manual process which you must select for each newly constructed method? FMS Tools had a feature where you could automatically add...

Hello MS Access Expert, Unfortunately, it appears the latest FMS release does not support a 64 Bit environment. I recall there was a free Tool that offered very similar features to FMS Visual Code Tools but I cannot recall the exact name. Can you provide the name and link for this free VBA...

Thank you TheDBGuy.

Thanks The_Doc_man. TheDBGuy are you comfortable sharing some code snippets demonstrating how you successfully implemented OAuth 2.0 or pointing to a source that helped you in your implementation. Thank you.

The_Doc_Man, I am running the Kyle Beachill code as you suggested. OAUTH2 and VBA When I attempt to get the AuthHeader the code opens an Internet Explorer window with a BING Search. (See below screenshot) I presume I am supposed to do some kind of user interaction based on the code...

Thank you for all the responses. They were helpful.