MS Access 2003: speed dropdown in a multiuser environment when 2 or more clients start a search simultainously
Posted on 2008-11-20
I have an (old) ms access app, that runs i a 2003 version mulituser environment (up to 10 clients). The app is developed/maintained in a 2007 environment. Now I experience the following: when 2 or more clients start a search at the same time, both of them will thereafter have very slow searches (was not so before). Theese searches normally results in some hundred records. If the client logs out and in again, the search is fast again as long as nobody else are doing a search. My records are growing bigger and bigger... The last change was (among others) to insert 2 new fields of type memo in the main table. Theese two fields contain not much text so far. Before there where 2 Memo fields in the table (now 4). I have a feeling that some size limits are the problem, but I do not know. And what can I do? Has anybody experienced this?