with over 450,000 records and about 24 fields I know it
will be slow but how could I speed it up without
upgrading to SQL Server. I already compacted and it
didn't do much

Hi,

With the amount of records you're talking about, there
wouldn't much performance gain in whatever you try.

Some suggestions:

-Eliminate some fields (probably not your preferred choice)
-Have only one user working with the database at once (If
this file is on a network, only have one person at a time
using the database will significantly speed performance)
-If you have forms, keep them very very simple
-Avoid excessively long dropdowns

These most likely won't do very much, but it's something
to try. But with the number of records you have, and
assuming they'll keep adding up, I strongly suggest you
migrate to a SQL Server database.

Regards,
Eric

>-----Original Message-----
>with over 450,000 records and about 24 fields I know it
>will be slow but how could I speed it up without
>upgrading to SQL Server. I already compacted and it
>didn't do much
>.
>

What part is slow? Initial form load? Querying? Other?

Is the table indexed? Properly?

Is it on a network? Local HD?

Some details, please...

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



"Silas" <(E-Mail Removed)> wrote in message
news:08d401c34f90$29e00ce0$(E-Mail Removed)...
> with over 450,000 records and about 24 fields I know it
> will be slow but how could I speed it up without
> upgrading to SQL Server. I already compacted and it
> didn't do much