Hi all

Rephrasing a previous question, given an Access database's full path,
how do I programmatically ascertain whether it has any password
protection on the VB Project?  (Sorry about the multiple posts - not
sure which is the appropriate group to submit to).

Thanks in advance

Paul Martin
Melbourne, Australia

I would think you should know about the database you intend to connect to, and
therefore you would know whether it's password protected or not before you
attempt to.

Is this a trick question? Are you writing a "utility" to connect to any
database? Otherwise, you would surely already know the answer to this
question, for any given database.

Ascertaining password protection on the VB Project, I cannot take other than
that you are asking a question of how to hack. Which is unacceptable. You must
therefore go on my watch-list; and the newsgroup can attest that I have a long
memory in such things.

Chris

<pmartin1***@hotmail.com> wrote in message
Show quoteHide quote

Hi Chris

I am building  a utility in VB6 that scans a user-selected folder and
looks for Access databases, opens a file, looks for certain things then
loops for the next file.  If a file's VB Project won't open for any
reason, it will ignore that file, logging that it is probably password
protected.  Not interested in hacking at all.

Paul


Chris Mills wrote:
Show quoteHide quote

For anyone else listening, just bear in mind that Aussies and Kiwis are
neighbours; Like England and Ireland though we never went to war!

Thanks for the explanation. Hacking obviously worries me.

To your original two posts, I do not know how to determine programmatically
whether an Access file's VBA project is password protected. I do not recall
any post saying how since A2k came out. And I could get upset if I saw such a
thing posted here, if it can be determined. I'm sure you understand my
reasons.

Assuming one is limited (for some reason) to mdb rather than mde, then since
A2k code has been protected by a "simple password". According to Peter Miller
(PK Solutions) this is less secure than it ought to be or was previously for
code. I hope I don't take his name in vain.

With not necessarily any reflection on pmartin, I don't appreciate any
discussion at all in this newsgroup on how to circumvent security, whether
published elsewhere or not. With the possible exception of "being aware",
itself a difficult subject because those "aware" can break anything! (hence
such companies)

So far as I'm aware, such companies as know how to do these things, don't ask
in a public security newsgroup, which was presumably established to implement
security.

Chris

<pmartin1***@hotmail.com> wrote in message
Show quoteHide quote

Then WHY do you want to do that?

The only other reason I can think of, is "automatic conversion". I have never
attempted automatic conversion of multiple files myself, and no-one else has
successfully done so according to the number of questions and lack of success
stories I've read in this and related newsgroups. Certainly (conversion, not
password) question has been posed often. If I missed some answers, then quote
them (you would have already).

Your purpose has not yet been given for wanting to do this. I have never heard
of anyone posting that they were successful at auto-conversions. There are
just too many other "picky" things. So, you have a third reason for wanting to
do this. What is it?

Chris

ActiveX component can't create object.
Moving to network drive
can access file be 'encrypted' or 'locked'?
MS Access, tracking data and other changes?
limiting access
Strange CN (Common Name) format with \x00 ...
Copy linked tables
change the mouse arrow image to a hand
Permissions - how to get into a database that has them set
can use code to reference mde file?