My friends, a client gave me the email and password for azure to connect to a SQL Server database on Azure using Access. I've tried connecting in several ways but the only one that works is 'active directory interactive'. However, this method doesn't save the email and password. Every time I open Access, it asks for the email and password again.
What can I do to save the email and password so that the user isn't prompted for them each time I open the program?
Is Azure the reason for this?
Or should I change something in Access?