G
Guest
I upgraded my application from Acc 2002 and Win Xp to Acc 2007 and Vista
Business.
My app is connected through ODBC to SQL server (2000 or 2005).
It works well on my laptop (Win Vista Business and Off 2007) only if the SQL
server is on the same computer (laptop)
If I try to connect with another SQL server on a desktop in my LAN the
application became very very ( x 100) ...... slow.
A form that normally takes maximum 2-5 sec to open (Access 2002 and XP) now
it takes 3 min (Access 2007 and Vista).
Both my computers (the laptop and the desktop) are Dual Core2 and have 1G
RAM - the laptop and 2 G Ram the desktop.
Business.
My app is connected through ODBC to SQL server (2000 or 2005).
It works well on my laptop (Win Vista Business and Off 2007) only if the SQL
server is on the same computer (laptop)
If I try to connect with another SQL server on a desktop in my LAN the
application became very very ( x 100) ...... slow.
A form that normally takes maximum 2-5 sec to open (Access 2002 and XP) now
it takes 3 min (Access 2007 and Vista).
Both my computers (the laptop and the desktop) are Dual Core2 and have 1G
RAM - the laptop and 2 G Ram the desktop.