Hello everyone,
I'm trying to create something that automatically writes the username and password to my databases when I open them.
I found this piece of code:
Open() method of the ADODB.Connection object:
Provider=SQLOLEDB.1;Data Source=SqlServerComputerName;Initial
Catalog=DatabaseName;User ID=MyAccount;Password=MyPassword
The issue is; I have no idea how or where to implement this. My initial idea was to create an "opening form" which has a "when this form opens"- function that runs the code.
I have been looking around the net and now I'm even more confused after researching. I've tried going through; https://learn.microsoft.com/en-us/tr...ordset-objects, but I'm still not sure where I need to write the code. The article refers to something called Northwind, which is not something I'm familiar with.
Do I need some software to use the code? Maybe there is a file in Windows where I can edit this in? Or is there a simpler and easier method to achieve the same? (I want to note that I don't have the luxury of recreating every single database and check "save password").
Thanks.