Which is the best database format?

[G7LRQ]

Thanks for reading this.
I have been programming for a little while and have written a program that uses a random access database. The problem I am know having is that it is becoming slow to search any of the fields, as the number of records increases.

This is obviously not the right database to be using so what are the alternatives?

I need to be able to search any of the fields "FAST" (running on an average speed computer)and would like to be able to have as many as 30,000+ records.

What should I be looking for, or am I expecting to much?

Any help and code would be most welcome.


Many Thanks


Anthony (G7LRQ)

[Brent vanSchaayk]

I personally would use an ODBC Database. I work with one every day, they are highly customizable and the quickest to learn. The syntax for query's is just raw SQL so learning it is quite simple. There are many to chose from, the choice is yours though.

[JHausmann]

Use jet. It's free and relatively (pun intended) easy.