Re: Query tables in two access databases with password

What I would recommend (since the client is clearly
computer-illiterate) is that you create your own custom database
password scheme, which is likely to be just as effective as the
wretched database password that is built-in (meaning, not very, but
good for deterrence). If you have a forms-based app, this shouldn't be
hard. If you don't want to go that route, you can open the database by
supplying the password in the connection string. However, this makes
your code and your entire app very fragile because anyone at all can
go in at any time and change the password, causing your code to no
longer work. If you create your own database password scheme, then at
least you can ensure that it doesn't get changed by anyone who can
open the database with exclusive access.

--Mary

On Fri, 9 Sep 2005 03:24:02 -0700, "Nakio"
<Nakio@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Yes, they do.
>
>It's not my pleasure. I told the client about that, but he wants his
>databases protected with password. I must do this job.
>
>
>"Mary Chipman [MSFT]" wrote:
>
>> Remove the database password. It's totally useless as protection and
>> only gives you headaches. Anyone interested in your data only has to
>> do a simple internet search and they're in.
>>
>> --Mary
>>
>> On Thu, 8 Sep 2005 08:26:09 -0700, "Nakio"
>> <Nakio@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>> >I am working with ado with two database, both with password. I am connected
>> >to database db1 with Ole Db (i open the conection with password)
>> >
>> >When I execute this query (it works when there is no password in the
>> >database):
>> >
>> >dim strSql as string
>> >strSql = "INSERT INTO [Table1] SELECT * From [c:\Test\db2.mdb][Table1]"
>> >cnn.Execute strSql
>> >
>> >an error occurs because dabase db2.mdb has a password.
>> >
>> >Do you know how can i do that?
>> >I dont want to link Table2 in database db1
>>
.

Relevant Pages