I know that is a lot of code to throw at you for DSN-Less connections. If I am too busy, there are others in the VBA section that do exactly the same thing that can help.
Basically, set up a logn in with an actual User Name and Password.
SQL has two kind's of logins - Network ID login and a specific Username / password
Set that user up as Read/Write (but not able to make design changes)
If you don't know how, that is a easy question for the SQL Server thread.
The other advantage of SQL Server Native Client is how well the data types should work.
Basically, set up a logn in with an actual User Name and Password.
SQL has two kind's of logins - Network ID login and a specific Username / password
Set that user up as Read/Write (but not able to make design changes)
If you don't know how, that is a easy question for the SQL Server thread.
The other advantage of SQL Server Native Client is how well the data types should work.