Power Tip: Improve the security of database connections

re: Power Tip: Improve the security of database connections

Chris Downs — Fri, 15 Apr 2011 20:00:05 GMT

Thanks for the comment, Albert! I've passed it along to Ben.

re: Power Tip: Improve the security of database connections

Albert D. Kallal — Fri, 15 Apr 2011 17:30:17 GMT

Wow, just flat out 100% useful and amazing at the same time. +1 for this.

Great article, now if I could just come up with a way to close or reset that cached connection….

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

re: Power Tip: Improve the security of database connections

Chris Downs — Tue, 12 Apr 2011 16:41:31 GMT

Thanks for the comment, Juan!

@tsmith60: Ben has provided the following response, which we hope answers your question:

"Normally, one would bind the report to a passthrough query. As mentioned, you only need to store the minimum 3 parameters (driver, server and database) in a passthrough query's connection string. This typically will be enough for Access to match it to the cached connection that you create at the startup."

re: Power Tip: Improve the security of database connections

tsmith60 — Tue, 12 Apr 2011 16:03:23 GMT

With DSNless, how do you handle reports on the ODBC tables?

re: Power Tip: Improve the security of database connections

Juan Soto — Mon, 11 Apr 2011 15:39:57 GMT

Great article Ben! It was a real eye opener for me to learn DSN passwords may be saved in the registry. Every developer worth their salt should use DSNless connections.

Juan