Results 1 to 4 of 4
  1. #1
    seen is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    12

    app.login


    Hi gurus,

    I have a question about the following and I can't seem to find any background info at any other sites:

    sub main()

    dim app
    dim mySession
    dim myForm

    set app = CreateObject("Remedy.User")
    mySession = app.Login("user", "pass", false)
    myForm = app.OpenForm(mySession, "server", "thisForm", 1, True)

    end sub



    I have two work computers. Both have Microsoft Access 2007 installed, both have the same version of this Remedy Action Request system program running.

    Here is the problem: The above code only works on one PC and not the other. The problem PC spits out the error # -2147467259 "You could not be logged in."

    Any thoughts?? I figure there are some environment variable differences between the two, but for the life of me I can't figure out what they are. Thanks in advance..

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you checked for any bogus MISSING References?

  3. #3
    seen is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    12
    Thank you for the quick response.

    I found out what the problem was. The Action Request Remedy System program has a server list directory which I hadn't properly filled out on the problem PC (I actually didn't even know it existed until this problem came up). Hence the login error..

    When logging in manually with AR you can set a "preference" server without ever having to add a connection server to the list. However Access doesn't recognize user preferences as a valid parameter.

    All good now

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Excellent! It sounds like this thread is ready for the Solved thread tool.

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

Similar Threads

  1. Login Screen in Access
    By Di7bash in forum Access
    Replies: 3
    Last Post: 03-18-2014, 11:57 PM
  2. How do I undo the requirement to login every mdb
    By garymkrieg in forum Security
    Replies: 3
    Last Post: 07-11-2011, 03:53 PM
  3. Database Login Issue
    By Nosaj08 in forum Security
    Replies: 1
    Last Post: 07-13-2009, 10:43 AM
  4. Login Script
    By theITguy in forum Access
    Replies: 2
    Last Post: 03-06-2009, 03:37 AM
  5. Database Login Error
    By narasareddy in forum Access
    Replies: 0
    Last Post: 08-30-2008, 12:00 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