Long time to search through Access database
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 email@example.com
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center