In my database I've got a table containing 648.000 movie titles (movie_id, title). this table is the datasource for a combo
box in a form which connects the movie to a person (or an object, i.e. file, article etc.).
when typing the first few characters in the combo box (to add a new movie to a person), the combo box narrows down the
but if the title requires more characters to by typed to narrow down the selection to the required one (i.e.
"a,m,e,r,i,c,a,n, ,p.e.r" for "american perfect) and I'm typing to fast, it happens that (after pressing TAB to confirm the
selection) access (2000) presents the error message "the microsoft jet database engine stopped the process because you and
another user are attempting to change the same data at the same time". after confirming the message, it keeps popping up
several times until I change focus to a different master record.
needless to say that I'm the only user using the database. despite of the error message, ms access saves the record properly
in the underlying table, but doesn't display it in the form (change to a different record, change back and it's there).
I suspect that there's a background process, scanning the titles table for records matching my (typed-in) selection criteria
which conflicts with the insertion of the new record into the person_on_movie table.
I already tried to compress and repair the database, but it didn't help.
Any ideas how to overcome this problem ? maybe by implementing the lookup manually, in VBA ? (reducing the number of records
is not an option ;-) )
tnx in advance.