Log out/Change user? - Microsoft Access / VBA

Is it possible when using Access security to log a user out? I have a
client who would like to be able to change users without having to shut
Access down.

Anyone come up with a good solution? (perhaps just close the app and
open it again in code?)

Bradley

Nov 13 '05 #1

Subscribe Reply

7859

Trevor Best

Br@dley wrote:

Is it possible when using Access security to log a user out? I have a
client who would like to be able to change users without having to shut
Access down.

Anyone come up with a good solution? (perhaps just close the app and
open it again in code?)

shell """" & syscmd(acSysCmd AccessDir) & "msaccess.e xe"" """ &
currentdb.Name & """"
docmd.quit

Nov 13 '05 #2

John Ortt

How do you use that command Trevor? I.E. Where does the users ID No get
inserted?

Thanks in Advance,

John
"Trevor Best" <no****@besty.o rg.uk> wrote in message
news:41******** **************@ news.zen.co.uk. ..

Br@dley wrote:
Is it possible when using Access security to log a user out? I have a
client who would like to be able to change users without having to shut
Access down.

Anyone come up with a good solution? (perhaps just close the app and
open it again in code?)

shell """" & syscmd(acSysCmd AccessDir) & "msaccess.e xe"" """ &
currentdb.Name & """"
docmd.quit

Nov 13 '05 #3

Rick Brandt

"Br@dley" <no@email.com > wrote in message
news:41******** **@news.melbour ne.pipenetworks .com...

Is it possible when using Access security to log a user out? I have a
client who would like to be able to change users without having to shut
Access down.

Anyone come up with a good solution? (perhaps just close the app and
open it again in code?)

The user is defined BEFORE your file is opened and is still defined AFTER
you close the mdb file. You have to start a new instance of Access to
become a different user.

It is possible in code to instantiate a new workspace with a different user
account, but you cannot then make that workspace the one that you are
running everything in.

Code that would open a new "external" instance of Access is the only way to
do it that I know of.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #4

John Ortt wrote:

How do you use that command Trevor? I.E. Where does the users ID No
get inserted?

Thanks in Advance,

John
It doesn't. The application simply closes and reopens. The user then has
to log in as usual.

Bradley
"Trevor Best" <no****@besty.o rg.uk> wrote in message
news:41******** **************@ news.zen.co.uk. ..
Br@dley wrote:
Is it possible when using Access security to log a user out? I have
a client who would like to be able to change users without having
to shut Access down.

Anyone come up with a good solution? (perhaps just close the app and
open it again in code?)

shell """" & syscmd(acSysCmd AccessDir) & "msaccess.e xe"" """ &
currentdb.Name & """"
docmd.quit

Nov 13 '05 #5

John Ortt

"Br@dley" <no@email.com > wrote in message
news:41******** **@news.melbour ne.pipenetworks .com...

John Ortt wrote:
How do you use that command Trevor? I.E. Where does the users ID No
get inserted?

Thanks in Advance,

John

It doesn't. The application simply closes and reopens. The user then has
to log in as usual.

Bradley

Sorry Bradley,

I misunderstood your original question. I was looking for a tool which
would log users off remotely to allow me to perform updates on the database
without the potential for record locks etc.

I am currently doing this with a logout table. Essentially the table has one
record and a tick box. The value stored in the tickbox is loaded onto a
hidden form when the user opens the database and refreshed every 5 minutes.
If the Logout value is changed to true the code automatically flashes a
splash screen explaining that the database is being closed for maintenance
and all the users are logged out within 5 minutes.

The drawbacks with this system are that it is not immediate, it consumes a
small amount of resource to keep refreshing and it is possible to circumvent
and/or disable (through the use of Modal forms or the Shift key when opening
the database etc.).

Thanks anyway,

John

Nov 13 '05 #6

Similar topics

1825

Global variable lost in Change event Handler?

by: beanweed | last post by:

BACKGROUND ---------- I have an ASP.NET application having two panels. In one panel, an XML document, transformed using xsl, is displayed. In the other panel are some controls that allow a user to change the xml. For example, each "l_item" element appears as a row in a table labelled with a "label"; so if I have <l_item id="1"> <label>blah</label> ...

.NET Framework

3046

Only Admin can change db.Props ?

by: Arno R | last post by:

Hi there, I just distributed an application in which I (try to) change db.properties depending on CurrentUser() For instance I set the property's AllowBypassKey and AllowBuiltinToolbars to False when CurrentUser() <> "xx" I just noticed that the property's can only be changed changed by a user belonging to 'Admins'. I never noticed this before. I could swear that in other apps (A97) this works fine without the user being an admin... ...

Microsoft Access / VBA

9864

Changing Password to an account that has to change password at first logon using System.DirectoryServices

by: Fabrizio | last post by:

(Sorry for the crosspost, but I really don't know which is the right newsgroup!) Hi all, I try to change the password to a user that as to change the password at first logon: try {

C# / C Sharp

5140

who can add users and change passwords?

by: Jan | last post by:

Hi: I have created a secured database for a client. For various reasons, I don't want the client to have full persmissions for the database; they aren't in the admins group. I have instead tried to create a second group, called "localAdmin," for the admin-type person at the client. I want this group to be able to do some basic admin-type stuff, including adding new users and clearing passwords if users forget theirs. I can't seem to...

Microsoft Access / VBA

4488

Change domain user password?

by: J | last post by:

Hello. I apologize if this isn't the appropriate group for this question but I was wondering if it's possible to allow regular windows domain users to change their passwords through an .asp page? I'm trying to figure out the best way to handle domain users to log into an .asp application tied with SQL Server 2000 on the back end since I keep reading that windows authentication is better practice to log into SQL Server. Thanks in...

ASP / Active Server Pages

4177

HOW Change Password

by: Xnet | last post by:

I need to change password of a local user of a W2003, without Active Directory. I need to do it from an application created with VB2005. Thanks!

Visual Basic .NET

1542

what or how to do if the user need to change password before entering the system.

by: spncc | last post by:

i'm making Form authenticate page to let the user first logon before using the application. However, like most security manner, the new user is needed to first logon and forced to change password before using the application. My problem is - When the user passed the authentication at logon page, we need to redirect them to change thier password. but anyway the user can type at the address bar to surf other pages on the application. What...

C# / C Sharp

2320

Custom Toolbar Change Password

by: eighthman11 | last post by:

Hi everyone: I created a custom toolbar called Password, so users can change their password. I used the Command "User and Group Accounts". I know the user can not change anything in the Tab "Users" or "Groups" in the "User and Group Accounts" and can only use the tab "Change Logon Password", but can I force a tab selection to the tab "Change Logon Password" and disable the other two tabs? Or does anyone know of an alternative way to...

Microsoft Access / VBA

2206

Change passwords in device

by: shellegreen | last post by:

Hello, I need help with some password changes that I have to do in some iPAQs. The company that I work has 3 models of iPAQ and 3 different versions of Windows Mobile (Microsoft Pocket PC 4.20.0, Win Mobile 2003 SE e Win Mobile 5.0). The devices are configured to use Dial up or Cell Phone connection (Bluetooth or infrared). Recently we developed a program that check the user password expiration date in Active Directory Server every...

Mobile Development

5071

change password AD using asp.net

by: bemytthm | last post by:

I just want to ask abt communicate with AD using ASP.net. I would want to ask you all to help me correct a problem like this: This is a code i use to change password on AD public bool ChangePasswordAD(string strLogin, string strOldPasswd, string strNewPasswd) { try { string domainAndUsername = "aloha.com" + @"\" + strLogin; DirectoryEntry entry = new...

ASP.NET

8371

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8889

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8790

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7391

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6206

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4372

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2782

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2017

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1779

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General