Connect w/ DSN to my password database?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello,

1. I have a set a password for my .mdb. Now how do 

I connect to the database? Can I use the same 

password as my Admin password? Or should I 

choose a different one? How secure is it? I just want 

to add extra security :)

Here is my connection config example:

'Physical path to database

strDbPathAndName = "d:html\users\

mydomain.com\database\mydatabase.mdb"

'Using DSN connection

strCon = "DSN=mydatabase"

2. Is there any security I can add so that if I get 

errors, my password won't be printed with the 

Microsoft errors? D'oh!

Thanks!  