Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jul 2003
    Location
    Phoenix, Arizona, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Different responses on different computers (XP, SP-2)

    I have a front-end application that resides on several computers. They are all running Win2K-SP4 with Access XP-SP2. On one computer I can't login to the system because a subscript error in the login procedure. On a 2nd computer I can login fine and everything works except for one script during data entry. On a third computer, everything is great including the script that didn't run on the 2nd computer. Also, one computer lets me copy a record and paste in the data for a new record but another computer won't let me do that.

    Does anyone have any idea what could be the problem or where I can start the trouble shooting from? As I mentioned, all machines run the same software.

    Thank you in advance for any help.
    John B.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Different responses on different computers (XP, SP-2)

    Sorry but your description is a bit vague. By login to the system, are you talking about the Windows login or Access? If you can't login to Windows, that isn't an Access issue. And what do you mean by a "script"? Are you talking about Access VBA code, an Access macro, or something else?
    Charlotte

  3. #3
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different responses on different computers (XP, SP-2)

    <hr>They are all running Win2K-SP4 with Access XP-SP2<hr>

    I posted yesterday ( <post#=290199>post 290199</post#> ) about problems with Win2K-SP4 and Access 2000 SP1 on the Win2K board. I would look closely <img src=/S/eyeout.gif border=0 alt=eyeout width=15 height=15> at SP4. Judging by other forums (e.g. http://www.w2knews.com/anecdotes.htm ), it has caused a lot of problems.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  4. #4
    Lounger
    Join Date
    Jul 2003
    Location
    Phoenix, Arizona, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different responses on different computers (XP, SP-2)

    Sorry Charlotte. The Login I mentioned is a VBA module/code that runs after the application loads. Before one can do anything in the database, they need to login to establish their user access levels. So why the code runs on one computer but gives a subscript error on another computer when using the same login IDs and Passwords I don't understand.
    By script I meant VBA code. It's a donation Database so first we look up the name to see if they already have an entry that we'd just add a donation line. If the name isn't in the database, we need to create a new top level record with name address, etc. It's when we go from the search to add new record that a debug window comes up and then various variables (UserID for example) no longer contain data, so we need to log out and log back in. This too works on some machines but not all.
    Hope this clear definition helps.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Different responses on different computers (XP, SP-2)

    ACtually, I'm running Office 2000 SP-3 and Access 2002 SR-2 on Win2k SP4 and haven't had any problems.
    Charlotte

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Different responses on different computers (XP, SP-2)

    So you created your own security rather than using Access security? In that case, different behavior on different machines can be caused by a lot of reasons. One rather obscure problem is printer drivers. I heard of one problem caused by having AutoCAD installed on a machine, and I've seen "identical" machines from the same vendor and purchased at the same time that had entirely different hardware drivers for some of their hardware. Variables will be zapped by an unhandled error in your code, so make sure everything is thoroughly error trapped and check your references to make sure that one machine isn't just marginally different from the others. I ran into a rather interesting problem recently and discovered that some references think they're resolved at runtime and the code sort of works, but the reference stays broken and crashes queries unexpectedly. Fixing the reference took care of the problem but references that think they are resolved don't return the correct value when you test their IsBroken status.

    Does any of that give you an idea of where to look?
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •