Gmail to stop using SMTP for authentication (1 Viewer)

KACJR

Registered User.
Local time
Today, 10:45
Joined
Jul 26, 2012
Messages
81
Greetings to the well of knowledge...

As some of you may know, Google will be dropping support for SMTP as an account authentication methodology, replacing this with OAuth.. I have several snippets of code that uses the native CDO library to handle email within my VBA code. Has anyone been able to upgrade their VBA apps to use OAuth? I'd be interested in learning any programming approaches.

Thanks,
Ken
 

Gasman

Enthusiastic Amateur
Local time
Today, 15:45
Joined
Sep 21, 2011
Messages
14,288
Do you have a link please?
 

KACJR

Registered User.
Local time
Today, 10:45
Joined
Jul 26, 2012
Messages
81
Do you have a link please?

Interestingly, I can't find any public references on Google's website, however we did get this:

Dear Administrator,

We’re constantly working to improve the security of your organization’s Google accounts. As part of this effort, and in consideration of the current threat landscape, we’ll be turning off access to less secure apps (LSA) — non-Google apps that can access your Google account with only a username and password, without requiring any additional verification steps. Access through only a username and password makes your account more vulnerable to hijacking attempts. Moving forward, only apps that support a more modern and secure access method called OAuth will be able to access your G Suite account.

Access to LSAs will be turned off in two stages:

  1. June 15, 2020 - Users who try to connect to an LSA for the first time will no longer be able to do so. This includes third-party apps that allow password-only access to Google calendars, contacts, and email via protocols such as CalDAV, CardDAV and IMAP. Users who have connected to LSAs prior to this date will be able to continue using them until usage of all LSAs is turned off.
  2. February 15, 2021 - Access to LSAs will be turned off for all G Suite accounts.
What do I need to do?
To continue using a specific app with your G Suite accounts, users in your organization must switch to a more secure type of access called OAuth (a list of affected users is attached). This connection method allows apps to access accounts with a digital key instead of requiring a user to reveal their username and password. We recommend that you share the user instructions (included below) with individuals in your organization to help them make the necessary changes. Alternatively, if your organization is using custom tools, you can ask the developer of the tool to update it to use OAuth. Developer instructions are also included below.

MDM configuration
If your organization uses a mobile device management (MDM) provider to configure CalDAV, CardDAV, and Exchange ActiveSync (Google Sync) profiles, these services will be phased out according to the timeline below:

  1. June 15, 2020 - MDM push of IMAP, CalDAV, CardDAV, and Exchange ActiveSync (Google Sync) will no longer work for new users.
  2. February 15, 2021 - MDM push of IMAP, CalDAV, CardDAV, and Exchange ActiveSync (Google Sync) will no longer work for existing users. Admins will need to push a Google Account using their MDM provider, which will re-add their Google accounts to iOS devices using OAuth.
Other less secure apps
  • For any other LSA, ask the developer of the app you are using to start supporting OAuth.
  • If you use other apps on iOS or MacOS that access your G Suite account information through only a password, most access issues can be resolved by removing then re-adding your account. When you add it back, make sure to select Google as the account type to automatically use OAuth.
Scanners and other devices
No change is required for scanners or other devices using simple mail transfer protocol (SMTP) or LSAs to send emails. If you replace your device, look for one that sends email using OAuth.

User instructions
If you are using an app that accesses your Google account with only a username and password, take one of the following actions to switch to a more secure method and continue to access your email, calendar, or contacts. If you do not take one of the following actions, when LSA access is discontinued after February 15, 2021, you will begin receiving an error message that your username-password combination is incorrect.

Email
  • If you are using stand-alone Outlook 2016 or earlier, move to Office 365 (a web-based version of Outlook) or Outlook 2019, both of which support OAuth access. Alternatively you can use G Suite Sync for Microsoft Outlook.
  • If you are using Thunderbird or another email client, re-add your Google Account and configure it to use IMAP with OAuth.
  • If you are using the mail app on iOS or MacOS, or Outlook for Mac, and use only a password to login, you’ll need to remove and re-add your account. When you add it back, select “sign in with Google” to automatically use OAuth.
Mac OS
iOS
Calendar
  • If you use CalDAV to give an app or device access to your calendar, switch to a method that supports OAuth. We recommend the Google Calendar app [Web/iOS/Android] as the most secure app to use with your G Suite account.
  • If your G Suite account is linked to the calendar app in iOS or MacOS and uses only a password to login, you’ll need to remove and re-add your account to your device. When you add it back, select “sign in with Google” to automatically use OAuth. Read more
Contacts
  • If your G Suite account is syncing contacts to iOS or MacOS via CardDAV and uses only a password to login, you’ll need to remove your account. When you add it back, select “sign in with Google” to automatically use OAuth. Read More
  • If your G Suite account is syncing contacts to any other platform or app via CardDAV and uses only a password to login, switch to a method that supports OAuth.
Note: If the app you are using does not support OAuth, you will need to switch to an app that offers OAuth, or ask your admin to contact the supplier of your app and request that they add OAuth as a way of connecting your Google account.

Developer instructions
To maintain compatibility with G Suite accounts, update your app to use OAuth 2.0 as a connection method. To get started, follow our developer guide on using OAuth 2.0 to access Google APIs. You can also refer to our guide on OAuth 2.0 for mobile & desktop apps.

How can I get help?
If you have additional questions or need assistance, please contact G Suite support. When you call or submit your support case, reference issue number 145694552.
 

Gasman

Enthusiastic Amateur
Local time
Today, 15:45
Joined
Sep 21, 2011
Messages
14,288
Marvellous :(
A friend was notified that Sky were doing that, so we moved his Sky mail to be accessed from Gmail. Now they are doing the same. :(
 
Last edited:

Micron

AWF VIP
Local time
Today, 10:45
Joined
Oct 20, 2018
Messages
3,478
I've only used CDO to send email from Access in a network environment wherein I had an email account on the server so maybe I'm not fully conversant on the subject. However, it was my impression that as long as you had an account, you could use the server directly to send formatted email without having to log on to it or provide a password. Does using CDO to access GMail require you to provide usernames and passwords in order to use their server?
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 09:45
Joined
Feb 28, 2001
Messages
27,182
I got something from AT&T about a similar move. They allowed me to create essentially a super-long password to be used for Outlook 2010 since it does not support OAuth. So I got to the web site and built a new password according to their methods. I think what happens is that they keep TWO passwords - the OAuth one and the "other" one.
 

Micron

AWF VIP
Local time
Today, 10:45
Joined
Oct 20, 2018
Messages
3,478

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 09:45
Joined
Feb 28, 2001
Messages
27,182
Yes, Gasman. I'm still using PW rather than OAuth for Outlook 2010.
 

Gasman

Enthusiastic Amateur
Local time
Today, 15:45
Joined
Sep 21, 2011
Messages
14,288
Yes, Gasman. I'm still using PW rather than OAuth for Outlook 2010.
What I meant The_Doc_Man, was that it appears that once you generate an App password in your Gmail account, you can use that instead of your normal pasword, thereby meaning I can still use Outllook 2007 and my VBA with it, even after next February.?

So if you want to use LSA, now would be the time, tout de suite. :)
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 15:45
Joined
Jul 9, 2003
Messages
16,282
Subscribing to this interesting thread
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 15:45
Joined
Jul 9, 2003
Messages
16,282
Bruce McPherson is an expert on both Google app scripts and VBA.

Hence when I saw this thread I wondered if Bruce had anything to say about it. I did a Google search and found the following link:-


It's from 2013 so I don't know if it's still relevant, but I thought it was somewhere to start.

It's Excel VBA, but I would imagine it is is transferable to MS Access.
 

Gasman

Enthusiastic Amateur
Local time
Today, 15:45
Joined
Sep 21, 2011
Messages
14,288
Well fortunately for me, I just use Outlook from Access/Excel, so as long as this App Password process works I'll be OK.? At least I hope so. :)
 

YYYY

Member
Local time
Today, 10:45
Joined
Apr 21, 2020
Messages
39
today is 6/15/20
I tried using a new email account, and it didnt work
 

YYYY

Member
Local time
Today, 10:45
Joined
Apr 21, 2020
Messages
39
My old email works but the new one dosen't.
can anyone try to see if configuring anew email account with the 16 digit password works for them?
 

shadow9449

Registered User.
Local time
Today, 10:45
Joined
Mar 5, 2004
Messages
1,037
I've just sent an email to my GMail account using my CDO EMail Tester app: http://www.mendipdatasystems.co.uk/email-tester/4594365455
Note the comments on that page about managing GMail security settings. These are fully explained in the accompanying help file

Colin:

I looked in your help doc. The two methods listed are: using less secure apps and App Passwords. As discussed in previous posts, using less secure apps doesn't work anymore for accounts that didn't turn it on prior to June 15 and will be discontinued in February anyway.

However, do you (or anyone else) know if the method of using App Passwords is being discontinued as well? If Google will still permit it after February, then it seems like a much better alternative to having to implement Oauth in Access.

Thank you
 

YYYY

Member
Local time
Today, 10:45
Joined
Apr 21, 2020
Messages
39
my experience after June 15 2020 was that the g-suite email accounts don't let you use the 16 digit pass. even so it lets you create a password.
but the regular gmail accounts still work.
 

isladogs

MVP / VIP
Local time
Today, 15:45
Joined
Jan 14, 2017
Messages
18,219
Colin:

I looked in your help doc. The two methods listed are: using less secure apps and App Passwords. As discussed in previous posts, using less secure apps doesn't work anymore for accounts that didn't turn it on prior to June 15 and will be discontinued in February anyway.

However, do you (or anyone else) know if the method of using App Passwords is being discontinued as well? If Google will still permit it after February, then it seems like a much better alternative to having to implement Oauth in Access.

Thank you

Sorry. I haven't looked into this as yet
 

Users who are viewing this thread

Top Bottom