How do I use OpenCurrentDatabase with a secured database?

[Diarmuid]

Hi
I understand how to use an unsecured one, see below, but do I do for
secured dbs? The access database is in Office 2000 format

Dim acAccess As New Access.Application

acAccess.OpenCurrentDatabase ("S:\Testing\ViewExch.mdb")

thanks
Diarmuid

 

['69 Camaro]

Hi, Diarmuid.

If by "secured" you mean user-level security, then you'll probably want to
shell out to do the login with the UserID and workgroup information file.
You can find sample code on this Web page:

http://support.microsoft.com/default.aspx?scid=210111

If by "secured" you mean shared-level security, and if by "Office 2000
format" you mean that you're using Access 2K, then you're having difficulty
because Access 2K's OpenCurrentDatabase( ) function doesn't have a parameter
for the database password. However, there's a work-around. You can find
sample code on this Web page:

http://support.microsoft.com/default.aspx?scid=235422

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)

 

[Diarmuid]

Access 2k, with user level security. Thanks very much, what you've sent
should sort it out.
Diarmuid

 

['69 Camaro]

You're welcome!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)