What I want to do is that 1 user has his application open, but is able to open another
instance of Acces from a different user ( also different WG).

How to code this in VBA that this new instance of Acces is loggedin as that other user?

Pieter.

Hi, Pieter.

Two ways:

1.) Use the DAO library to create a new Workspace object. In that
workspace, use VBA to login as the other user with the appropriate password
and workgroup information file.

2.) Shell out to DOS and use the command line switches for the other
UserID, password, and workgroup information file.

HTH.

Gunny

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

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Pieter" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> What I want to do is that 1 user has his application open, but is able to
open another
> instance of Acces from a different user ( also different WG).
>
> How to code this in VBA that this new instance of Acces is loggedin as
that other user?
>
> Pieter.

A littlebit late, but thanks for the information that you gave.
I going to try also you solution.

On Sun, 5 Sep 2004 06:55:38 -0700, "'69 Camaro" <(E-Mail Removed)_SPAM> wrote in 34 Lines :

>Hi, Pieter.
>
>Two ways:
>
>1.) Use the DAO library to create a new Workspace object. In that
>workspace, use VBA to login as the other user with the appropriate password
>and workgroup information file.
>
>2.) Shell out to DOS and use the command line switches for the other
>UserID, password, and workgroup information file.
>
>HTH.
>
>Gunny
>
>See http://www.QBuilt.com for all your database needs.
>See http://www.Access.QBuilt.com for Microsoft Access tips.
>
>(Please remove ZERO_SPAM from my reply E-mail address, so that a message
>will be forwarded to me.)
>
>
>"Pieter" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> What I want to do is that 1 user has his application open, but is able to
>open another
>> instance of Acces from a different user ( also different WG).
>>
>> How to code this in VBA that this new instance of Acces is loggedin as
>that other user?
>>
>> Pieter.
>

Free Server Software:
www.MySql.com

Snel weten welke applicaties er op de achtergrond
opgestart worden, gebruik 'Starter'.
Download: http://CodeStuff.mirrorz.com.
Geeft virussen geen kans om op de achtergrond mee
te draaien en andere mensen te infecteren.

Microsoft never, repeat NEVER, sends updates, fixes, patches, etc., as
attachments to emails.


Access user level security info (m.d.a Goos Van Beek):

http://members.chello.nl/goosvanbeek...cSecDemo2K.pdf
http://members.chello.nl/goosvanbeek...ity_FAQ_NL.pdf
http://members.chello.nl/goosvanbeek/Files/Security.zip

Pieter (NL)

You're welcome. Hope it helps.

Gunny

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

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"Pieter" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> A littlebit late, but thanks for the information that you gave.
> I going to try also you solution.
>
> On Sun, 5 Sep 2004 06:55:38 -0700, "'69 Camaro"
<(E-Mail Removed)_SPAM> wrote in 34 Lines :
>
> >Hi, Pieter.
> >
> >Two ways:
> >
> >1.) Use the DAO library to create a new Workspace object. In that
> >workspace, use VBA to login as the other user with the appropriate
password
> >and workgroup information file.
> >
> >2.) Shell out to DOS and use the command line switches for the other
> >UserID, password, and workgroup information file.
> >
> >HTH.
> >
> >Gunny
> >
> >See http://www.QBuilt.com for all your database needs.
> >See http://www.Access.QBuilt.com for Microsoft Access tips.
> >
> >(Please remove ZERO_SPAM from my reply E-mail address, so that a message
> >will be forwarded to me.)
> >
> >
> >"Pieter" <(E-Mail Removed)> wrote in message
> >news:(E-Mail Removed)...
> >> What I want to do is that 1 user has his application open, but is able
to
> >open another
> >> instance of Acces from a different user ( also different WG).
> >>
> >> How to code this in VBA that this new instance of Acces is loggedin as
> >that other user?
> >>
> >> Pieter.
> >
>
> Free Server Software:
> www.MySql.com
>
> Snel weten welke applicaties er op de achtergrond
> opgestart worden, gebruik 'Starter'.
> Download: http://CodeStuff.mirrorz.com.
> Geeft virussen geen kans om op de achtergrond mee
> te draaien en andere mensen te infecteren.
>
> Microsoft never, repeat NEVER, sends updates, fixes, patches, etc., as
> attachments to emails.
>
>
> Access user level security info (m.d.a Goos Van Beek):
>
> http://members.chello.nl/goosvanbeek...cSecDemo2K.pdf
> http://members.chello.nl/goosvanbeek...ity_FAQ_NL.pdf
> http://members.chello.nl/goosvanbeek/Files/Security.zip
>
> Pieter (NL)