Acc2K FE, SQL Svr 2K BE, Slow form display?

[Steve Hall]

Dear All

We have a SQL Server 2000 BE on a Win 2K Server box. Access 2000
clients, running on Win 2000 Pro.

Front end design is fairly straight forward - 5 different "record
types" (split across approx 20 tables). For each "record type", there
is a datasheet view, listing the records of that type, and this can be
filtered by using a combination of text / combo / check box filters
above the subform datasheet. On clicking a record ID in the datasheet,
the "main form view" appears, listing the full details for the chosen
record.

Lately, the forms have become incredibly slow to display - not just a
problem populating the datasheets, but even to draw the comboboxes
takes time. The main form views are also very slow.

Curiously, if I take the SELECT statement from the datasheet
recordsource property, and paste it as a query within Access on my
machine (still linked to the SQL BE), the query returns almost
instantly (blink and miss it sort of speeds!). This suggest of course
that there are no network problems, and that Access is getting things
wrong. This is kinda emphasized by opening the subform on its own (as
opposed to within the parent form as part of the running app) - and
here the same problem occurs. However...

Running the client Access app on the server itself, and everything is
high speed... suggesting Access is fine, and there are network
problems!

Please help me. Im getting kinda dizzy chasing my tail so much!

TIA

Steve

[Kara Hooper]

Steve,
I think I've had a similar problem before. Everything seemed to be
working fine, but loading of forms and everything was really slow.
What I ended up having to do was create a new Access database and
import in all the data from the other database. You'll probably have
to relink objects as well. You can save the new database with the
same name as the old one once the old version is deleted. It's worth
a try.
Kara

www.klh-tech.com
KLH Technology Solutions

[Steve Hall]

ka********@hotmail.com (Kara Hooper) wrote in message news:<dc**************************@posting.google. com>...

Steve,
I think I've had a similar problem before. Everything seemed to be
working fine, but loading of forms and everything was really slow.
What I ended up having to do was create a new Access database and
import in all the data from the other database. You'll probably have
to relink objects as well. You can save the new database with the
same name as the old one once the old version is deleted. It's worth
a try.
Kara

www.klh-tech.com
KLH Technology Solutions

Hi Kara,

Thanks for your thoughts. I fear you may well be right too! Oh well,
it'll keep me busy for a bit!

Meanwhile, any more thoughts from any other folks?

Cheers

Steve