Append Query Is Timing Out

  • Thread starter Thread starter Waylon
  • Start date Start date
W

Waylon

Since the update to MS Windows Service Pack 4 (from 3), I can no
longer perform a make table or update query in Access 2K from a SYBASE
ODBC table. I can access the table with no problem but the make table
and append queries (both to tables within the Access database time
out.

Any ideas would be greatly appreciated.

Thanks,
Waylon
 
Hi

You can try the following to see if it helps:

1- Open your query in design mode
2- Right click in the tables area.
3- Select Properties
4- Set the ODBC Timeout to something greater than 60 seconds.


Maurice
 
Thanks but I'm still having problems.

Instead of timing out, I should have said the query just endlessly
hangs. If I perform the exact query on another Win2K (Service Pack 3)
box using Access2K, the query executes in literally a second or two.

Has anyone had a problem with make table or append queries using ODBC
to connect to SYBASE 12.5 databse?

Thanks you...
 
Back
Top