Slow application

[Guest]

Dear,

I've wrote a database for one of my customers, tables placed on the server (2,4 GHz , Win 2003 server, 2GHz RAM, 100 Mbit connection) forms, code,... placed on the desktop.
The speed this Application works is terrible !!
creating recordsets use of SQL, you can smoke a sigaret and drink a coffee before this is done, tests on another computer connected with a slower server works perfect !!
Does anyone have an idea what cause this problem ??
FYI,

Application Size 15 Mb
Access 2003

 

[Tony Toews]

The speed this Application works is terrible !!

The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

creating recordsets use of SQL, you can smoke a sigaret and drink a coffee before this is done, tests on another computer connected with a slower server works perfect !!

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm