Results 1 to 3 of 3
  1. #1
    Bongobob21 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    29

    LogIn Screen

    Hi everybody,

    I am using my access database with linked Excel Sheets as table. Therefore just one person at a time can use the database, as otherwise an error occurs telling the second person using the database that the excel sheets are already used. But this is not really a problem. The only thing I would like to have is a logIn screen which tells you who is currently using the database.

    I know how to create a LogIn screen but I have no idea how to create a message saying something like "Login not possible, User XYZ is currently using the database!"
    If somebody already did something like this I would be more than happy about some help.



    Thanks!

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,863
    AFAIK, you cannot edit a linked Excel file, regardless of one user or three users accessing the file. So, I do not understand the functionality you have with one user that you do not have with two users.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,332
    If you import the excel tables into the db, then you wont have this problem. many people can then use the db.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating a Classic Login Screen
    By Xipooo in forum Tutorials
    Replies: 1
    Last Post: 02-03-2016, 07:02 AM
  2. Login in form - not showing on screen
    By Sheba in forum Forms
    Replies: 2
    Last Post: 10-08-2014, 09:57 AM
  3. Login Screen in Access
    By Di7bash in forum Access
    Replies: 3
    Last Post: 03-18-2014, 11:57 PM
  4. Login screen coding
    By thinkkwise in forum Access
    Replies: 1
    Last Post: 08-05-2013, 05:08 PM
  5. Replies: 3
    Last Post: 06-22-2012, 04:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums