I'm going to be starting a project in Visual Basic that will deal with 1000's of records in connection with a databse. I'm thinking of connecting VB to an AccessXP database, but i'm not sure if thats the best method. SQL Server isn't an option because that would cost the client an extra $500 per licence.

What would be the best way to store 1000's of records in a database, because I don't think that an AccessXP DB will be able to handle the amount of records smoothly? Whats the main diffrence between ADO and DOA connection types? Which one would be faster and handle large amounts of data better?


thanks,

Dimava