Results 1 to 7 of 7
  1. #1
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480

    Function Back End Log / Sandstorm

    I am creating an app that has a lot of buttons and commands that can be executed... I have the front end, and then a back end that keeps track of usage. What is being recorded is....



    Username = Expr1: Environ("username")
    Function User = Expr3: [screen].[activecontrol].[name]
    Date/Time = Expr2: Now()

    Now, locally this works fine. I have the Back End on a shared drive. But when testing on other workstations, it says Environ is unsafe, and produces an error. Now everywhere I have this set to report out, it should...

    DoCmd.SetWarnings False
    DoCmd.OpenQuery "qryFuncLog"
    DoCmd.SetWarnings True

    Eliminating these errors.. but they still come up. And I see no entry on the Back end. Everyone has access to the shared drive so that should not be the problem... Any Ideas?
    Last edited by redbull; 03-22-2012 at 10:59 AM.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    SetWarnings wouldn't affect this. How about:

    http://office.microsoft.com/en-us/ac...001050432.aspx
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Alright, that is a really good start, testing on a couple machines now. So it looks like I need to change this setting on every computer that will be running this application??

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I suspect so; I never used 2003 in a production app, so I've never had to deal with the issue myself.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Alright, So I was able to change the security to LOW on the users machines... This seems to resolve the issue for about half of the group. the other half are still receiving the error. Guess I am going to find out how to check their JET version.

  6. #6
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Alright, going to mark this as solved. I was able to to resolve the issue without making changes to every PC manually... If you go into "digital certificates for VBA projects" and create a certificate... then import it into your project, it seems to work from there. Thank you again pbaldy for pointing me in the right direction.

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I'm glad you got it sorted out.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. I'm back!
    By evander in forum General Chat
    Replies: 3
    Last Post: 02-27-2013, 08:29 PM
  2. Back to the beginning - again
    By Sorbz62 in forum Database Design
    Replies: 4
    Last Post: 02-19-2012, 08:39 AM
  3. back end path
    By Mclaren in forum Programming
    Replies: 1
    Last Post: 06-08-2011, 01:13 PM
  4. Lock back-end DB with VBA
    By somm in forum Programming
    Replies: 5
    Last Post: 12-31-2010, 01:38 AM
  5. Back up database
    By sdondeti in forum Access
    Replies: 15
    Last Post: 11-03-2009, 02:17 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