I have created an application using VB and Access. The database will have
over 12,000 records to a max of 200,000 records. It seems to take forever
to search for a given item, eg. make sure there is no duplications in the
database. Is there anyway to speed up this process?

I was told to use FoxPro, but I do not have FoxPro. Does the FoxPro provided
with VB6 have the tools to compact and repair the database?

please email me at dsnelling@msc.ca