Results 1 to 2 of 2
  1. #1
    floyd is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    66

    Security Template Database

    Ref: https://www.accessforums.net/sample-...ent-20745.html

    ERROR: The code in this project must be updated for use on 64-bit systems.
    This is in red
    Code:
    Private Declare Function apiGetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
    This only works if saves as a Access 2003 format?



    MOD EDIT: split thread and merge posts
    Last edited by June7; 11-18-2013 at 02:02 PM.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    The files provided with that thread are accdb version for Access 2007 and up.

    The code extract posted expects 32-bit computer.

    Don't need api code to get username.

    Environ("USERNAME") will also retrieve user network login username.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Manlift Rental Database Template
    By emerbrennan in forum Access
    Replies: 1
    Last Post: 08-15-2013, 08:03 AM
  2. access student database template
    By austinpeay1999 in forum Access
    Replies: 6
    Last Post: 06-19-2012, 03:43 PM
  3. Replies: 5
    Last Post: 04-30-2012, 11:03 AM
  4. Database Template for Academic Use
    By Al Bothwell in forum Access
    Replies: 1
    Last Post: 04-10-2012, 06:37 PM
  5. Help with Classroom Management Database Template
    By alpinegroove in forum Database Design
    Replies: 6
    Last Post: 05-31-2011, 08:53 AM

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