Home Forums SQL Server 7,2000 Performance Tuning Access 2007 very slow with SQL server odbc connection (sql 2000) RE: Access 2007 very slow with SQL server odbc connection (sql 2000)

  • I have a similar situation. I have a form with only 6 fields in it. All the fields actually work well except for 1 date field. When we enter that field, there is a lag time of a good minute or so before you can enter the date in it.

    My Access front end was originally created in Access 2000. Workstations running Office 2000 and 2003 do not see this issue. Only workstations running Office/Access 07 have the problem. I am connected to an SQL Server 2000 back end.

    I have even converted the front end on these workstations to Access 2007 so they are not running in 2000 format. Still no good.