How to determine if a database password exists

[BigJimSlade]

Hi, Big Jim here:

I was wondering if there was a way from code to determine if any given database file has a password on it.

Thanks in advance,

Big Jim

 

[BigJimSlade]

Perhaps I can rephrase this:

I have this application which goes into a server and compacts all 800 or so Access Databases (not all in one night of course). The problem is that when searching through the databases, when I come to one with a password on it, the program terminates as it cannot compact the database without the password.

Without having to know each password for the 40 or so databases that have them, is there a way to check to see if the password exists? If so, I can bypass that database and loop onto the next.

Thanks again!

Big Jim

 

[llkhoutx]

Trap the error and identify the error number. When that error number occurs, go to the next mdb.

 

[BigJimSlade]

Thanks llkhoutx!

It worked like a charm! Big Jim can move on now.

Thanks again!

Big Jim