I am running asp website at www.aitcom.net and it gos through a series of 
pages coolecting values when I hit the third product display page it only 
produces products for certain vehicles but I now I am querying for Items 
taht are legit and in there.

Does this have any thing to do with the use of access or  is it a problem 
accessing 1800 records listed. I plan on having about 50,000 when all 
setup. 

I am in development phase right now and 

Consedering going to PHP and mysql is the much performance differnce