If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

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?

Re: Long time to search through Access database

"Duane" <dsnelling@msc.ca> wrote:
>
>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

The time used to find a particular record doesn't depends on the database
exclusively, is your skill in programming too.
If you use this