This is really strange so bear with me...
We have an access fron end connected using mysql ODBC 3.51 to a MySQL 4.x database. It has worked fine for years and continues to work fine on five machines. We upgraded two machines (clean installs) to Vista and here is where the trouble starts (all the Vista bashers can just go away now as we have since seen this on XP Pro as well).
Vista machine 1 is Ultimate and has both Access xp runtime and access 2007 installed. Running either one takes forever to pull up a page that does a querry. Any page that does any querry. Opening a table takes quite some time too. Go to the ODBC manager and click test and it takes a good 10 seconds to complete, the older machines take a second or less. At one time we installed Vista SP1 and the problems went away, now they are back.
Vista machine 2 is a business vista and is only running the runtime, same results. Installing SP1 on this machine had no effect.
The database runs fine (same database, exactly the same frontend) on five other machines, all xp pro. We have seen this on an XP Pro machine at one of our customers using Access as a frontend to a SQL 2005 database using ODBC. In that case making a new profile solved the problem. Creating a new profile on Vista1 changed nothing.
I have uninstalled and reinstalled Access, the runtime, the ODBC driver, etc. No effect. I created a brand new profile, gave it local and domain administrator rights, no effect. It is not database code because even just the ODBC driver takes ten times longer to pass the connection test than the other machines. Network speed is excellent and all machines are connected to the same switch, same server, all 100Mb wired connections. The two Vista machines that are so slow are two of our fastest workstations and have plent of ram, run other apps fantastic, surf great, etc.
Any help appreciated!
Allan
Start Free Trial
