Has anyone ever looked at an MDB using MS Word?

[ronh]

Normally you don't see jack, but I have coded DB
information for use with ADO calls and you can see them
plain as day. All you need to do is do a find on "pwd="
and you can find the "provider=" string really easy. Does
anyone know how I could get aroound this?

 

[Wayne Morgan]

Yes, I can get around it. No, don't open your database in Word. There is a know bug that
can trash your database if you do that. I don't remember all the details such as version
the problem was in, etc.

Now, for your problem. Depending on your version of Access you have one or two options
that are fairly easy.

1) Tools|Security|Encrypt Database

2) Create an mde file, this will remove the text code and just leave the compiled code.
You can't go back if you need to make changes, so keep a copy of the mdb file for your
use. To what extent this will hide what you're after, I don't know. As you may know, if
you've opened and exe file in a text editor, some things remain as plain text after
running through the compiler.

 

[ronh]

Method 2 still allows some of the coded password streams
to show up. However, method number 1 works like a champ.
Thanks a bunch for the tip and also for the heads up on
the bug.

-----Original Message-----
Yes, I can get around it. No, don't open your database in Word. There is a know bug that
can trash your database if you do that. I don't remember

all the details such as version

the problem was in, etc.

Now, for your problem. Depending on your version of

Access you have one or two options

that are fairly easy.

1) Tools|Security|Encrypt Database

2) Create an mde file, this will remove the text code and just leave the compiled code.
You can't go back if you need to make changes, so keep a copy of the mdb file for your
use. To what extent this will hide what you're after, I

don't know. As you may know, if

 

[Douglas J. Steele]

Rather than having something like:

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\myDb.mdb;" & _
"User Id=admin;" & _
"Password=xyzabc"

do

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
strConnect = strConnect & "Data Source=c:\some"
strConnect = strConnect & "path\myDb.mdb;"
strConnect = strConnect & "User Id=adm"
strConnect = strConnect & "in;"
strConnect = strConnect & "Password=xyz"
strConnect = strConnect & "abc"

so that the literal constant doesn't exist in a single place.