How to start an other User LvL Sec. DB for a diverent User.

[Pieter]

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.

 

['69 Camaro]

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]

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

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.)

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/Files/AccSecDemo2K.pdf
http://members.chello.nl/goosvanbeek/Files/MS_Access_Security_FAQ_NL.pdf
http://members.chello.nl/goosvanbeek/Files/Security.zip

Pieter (NL)

 

['69 Camaro]

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.)

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