Results 1 to 9 of 9
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Not totally sure where this ought to go, but I think the issue is a User Rights one so I am posting here.

    I have someone with a WIN 7 x 64 machine.
    This is running Access 2003 x 32
    This in turn links to a MYSQL x 32 bit on a Windows Server 2003 Machine.
    The ODBC river is x 32 (BUT same issue with x 64 driver), so I do NOT think it is the driver.

    If I log on as the hidden administrator account and use the database, it is very fast and works ok.
    IF a user logs on with Domain priviliges (still administrator rights), and uses system, then
    everything works fine.
    If they try to connect directly to MYSQL with admin tools, then it is fast.

    BUT.. If they try to use the Access Database, using the same connection, ODBC Driver and DSN,
    then the access is appaulingly slow.

    Since the speed issue apears to be related to Log On, I am wondering if anyone can
    give me a pointer as to what the speed issue might be.
    It appears to ONLY effect ODBC.

    Thanks.
    Andrew

  2. #2
    5 Star Lounger
    Join Date
    Jan 2010
    Location
    Los Angeles, CA
    Posts
    828
    Thanks
    4
    Thanked 38 Times in 34 Posts
    When you are referring to "the database" in the second paragraph. do you mean Access or MySQL?

    MySQL has tools that will tell you what queries are being done and how long they are taking. Try using those to see what is going on.

    Are you front-ending MySQL with Access? In other words, when you use Access it gets the data from MySQL? If so, Access could be doing a poor job of querying the database.

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    By the database I meant the Access Front End

    On only this machine and ONLY with this log in does this problem occur

    IF I log in with the Local Administrator Account, and use the system,
    the Access database retrieves the data VERY Fast.

    If I log on as this User (same machine), it is so slow you could not work with it.

    However, IF I use the same users account, and check MYSQL directly, via DOS or using MYSQL Manager tools
    everything works as per normal, and is fast.

    The implications seem to be that something is blocking or slowing down the
    ODBC connection to MYSQL, via Access for this LOG-IN

    I am not a Network man, so I am not really sure what settings applied could be causing this behaviour.
    Unfortunately nor does the Network Man.

    The Administrator Account I checked was the Local Hidden Administrator Account for the Machine.
    The User Account that fails is also part of a Domain, BUT it still has FULL (I am told) Admin rights.


    Interestingly OR not, the same user, had NO problems with their old machine,
    using the same Access Database Front End, to the same MYSQL database.
    That was on a 32 bit XP Pro SP3 machine.

    ODD..
    Andrew

  4. #4
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,588
    Thanks
    5
    Thanked 1,059 Times in 928 Posts
    Joe

  5. #5
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I have had a look but I do not think that this is the cause, unless it is specific to x 64 and specific logins.
    Andrew

  6. #6
    5 Star Lounger
    Join Date
    Jan 2010
    Location
    Los Angeles, CA
    Posts
    828
    Thanks
    4
    Thanked 38 Times in 34 Posts
    Are the "slow" user and the "fast" administrator using the exact same ODBC connection (same entry defined in the ODBC Data Source Administrator)? (I'm asking because I don't know how the app works - some apps let each user choose an ODBC connection.)

  7. #7
    New Lounger
    Join Date
    Dec 2009
    Location
    Emerald, Central Qld, Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Just as a bye-the-bye, have you tried running it in XP mode? I know I have seen some programs run better in a different mode (for no apparent reason!), and it might bypass a permissions problem unique to Win7 x64.

  8. #8
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    To answer both questions.

    Yes Both are using exactly the same Connection.
    It links with a System (machine) DSN
    Works on every other machine except this one with this Login.

    I have NOT tried running it in XP Mode.
    We will give it a go and I'll report back.

    Thanks
    Andrew

  9. #9
    5 Star Lounger
    Join Date
    Jan 2010
    Location
    Los Angeles, CA
    Posts
    828
    Thanks
    4
    Thanked 38 Times in 34 Posts
    Does the user have admin privileges? If so, have the user try running Access as administrator (right-click on Access and select the "Run as Administrator" option) and see if that changes anything.

Posting Permissions

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