I had a situation where users had inadvertantly pasted a ton of data into one of the lookup fields
how many fields are looked up each time ?
> The more concurrent users, the longer the wait.
There is only one way that data is added to this look up and thats by a daily scripted update followed by a full delete/reload once a month.
I’m using a composite of two fields to find 4 other fields (Nat Ins number plus payroll to find surname, initials, title and one other field).
1 of 1 people found this helpful
a lookup of 4 fields, with 2 users, should not bring on a coffee cup
some things to try:
- take the file off line, and save it as a compressed copy. Frequent delete / reloads can bloat a file
- try using auto enter calcs, rather than lookups
- just for the hell of it, run a consistency check, and a Recover Log, and see if anything odd shows up. Frequent delete / reloads can cause problems
> daily scripted update followed by a full delete/reload once a month.
Message was edited by: gdurniak
Thanks Greg, I'll give your suggestions a try when I can next take the DB off-line.