Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access slows down after entering 3-5 records

Status
Not open for further replies.

MarkGibson

Programmer
Feb 15, 2001
24
CA
I have a front end/back end Access 2000 db with 5 users, with 16 tables, and approx 450 records in the main table. A single user (all alone, no one else in the office, no other programs open) opens the form which accesses the main table (and links to several of the others; each link is on a different tab). The first record entered is lovely, but by record 3 there is a noticeable slowdown, and by record 5 it is painfully obvious that something is wrong. This is an ethernet network with a switcher, running WinME, on 1.1Mhz P4 machines.

Any suggestions on why this might be happening and what can I do to reduce the impact? It is of course worse when everyone is working on
the network.

Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top