B
Bruce Maston
I have a table with about 600 records and 4 fields.
My SQL is "SELECT * FROM comment WHERE clientID = intID."
This ADO request takes about 15 seconds to execute. I have a cable modem
connection, and this is an ODBC connection where Access 2K is the front end
and SQL Server is the back end (by which I mean I have Access on my machine
and the database is on an ISP's server).
There are only 3 machines using this database from different locations and
rarely at the same time.
I don't think this is normal. Would anyone have a suggestion what the
problem(s) might be?
Many thanks for any suggestions.
Bruce Maston
My SQL is "SELECT * FROM comment WHERE clientID = intID."
This ADO request takes about 15 seconds to execute. I have a cable modem
connection, and this is an ODBC connection where Access 2K is the front end
and SQL Server is the back end (by which I mean I have Access on my machine
and the database is on an ISP's server).
There are only 3 machines using this database from different locations and
rarely at the same time.
I don't think this is normal. Would anyone have a suggestion what the
problem(s) might be?
Many thanks for any suggestions.
Bruce Maston