Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-16-2019, 01:56 AM   #1
copperfield
Newly Registered User
 
Join Date: Aug 2019
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
copperfield is on a distinguished road
How to help users automatically log in.

Hello everybody.
I have a question I want to ask.
I have created a database for a minimum of ten users to log into simultaneously and add records via a form. All of the records need to have the respective usernames appended to the records to show they were the ones entering the data.

How do I get access to do this? Do I really need to make a list of users and have them select themselves from a dropdown? Is there a way to get the form to display the user who is currently logged in?

Thank you very much!

copperfield is offline   Reply With Quote
Old 08-16-2019, 02:18 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 9,822
Thanks: 107
Thanked 2,660 Times in 2,434 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: How to help users automatically log in.

It sounds from your description that each user will be sharing the same copy of the database. That is a recipe for corruption and loss of data.

First of all you need to split your database with the data in a backend database on the server or a network location. Each user then needs their own copy of the front end on their own workstation.

You can then do one of the following
1. Use code to get the Windows login of each user https://www.access-programmers.co.uk...1&d=1565947256
Save that as a variable or tempvar so it can be assigned to each record they create or edit
It can also be displayed on each form if you wish
2. Use a user name and password login system for additional security. This is essential if users will ever share the same workstation
There are many examples you can adapt for your purposes. For example see https://www.access-programmers.co.uk...d.php?t=193131
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Add New Users and Open to their page NearImpossible Modules & VBA 8 07-24-2019 10:11 PM
[SOLVED] Automatically log users off malfiscious Modules & VBA 5 02-18-2013 01:23 AM
Form to Load automatically Showing Users Records Sharkiness Modules & VBA 1 08-27-2009 07:33 AM
Automatically Logging off idle users abledog Modules & VBA 1 12-15-2008 07:51 AM
Automatically Generating Users Walk_The_Line Forms 1 08-14-2007 12:54 PM




All times are GMT -8. The time now is 01:01 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World