database

I have a database that has 110,000 barcodes in it. I am trying to create a system that I can enter barcode1 in the system and it return a good or bad value. I have it loading in an array at the moment. which does nto seem to work that well as it is taking a longtime and it is causing the sytem to bog right down. is there a better way to loop a variable through this many codes? thanks Ryan Holo Graphix Industries - HYPERLINK "http://www.hgilive.com/"www.hgilive.com Director (Interior Chair) - BC Print and Image Association Charter Secretary - Rotary Club of Kamloops Aurora -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.262 / Virus Database: 264.7.1 - Release Date: 8/27/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.262 / Virus Database: 264.7.1 - Release Date: 8/27/2004