combo box problem with 600.000++ records

  • Thread starter Thread starter imognimma
  • Start date Start date
I

imognimma

Guest
Hi,

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 selection accordingly.
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.
 
RuralGuy,

tnx for the link. I implemented my puristic version of this concept and it works like a champ when retrieving the data from a table. in my case it's slow when retrieving the data from a query (which provides more information to the user).

but that's a database design issue, I need to think this over.

tnx & cu
 
imognimma said:
Hi,

In my database I've got a table containing 648.000 movie titles (movie_id, title).

I presume this is 648,000 records. Who was the lucky person that got to enter all them :eek: :confused: :D

Dave
 

Users who are viewing this thread

Back
Top Bottom