I have an Access database that could eventually grow to thousands of entries. Right now the performance is not too good and I sometimes get errors like "too many client tasks" instead of anything at ...

In the most basic kind of database design, applications rely on only one database. In such a simple setup, an application developer can program directly against the database system's interfaces.