I am developing a 3-tier database application for a library (perhaps a small, mobile library) which is to store info about the literature contained within.
This is the biggest project I have attempted so far, and I have a few questions.
1) Can a 3-tier DB app run on a standalone PC (or is a 2-tier better)
2) What kind of database is best for such a project (I reckon about 20,000 books will be stored in the DB under fields like Author, Publisher, Category etc...)
I will be able to create DB types included in the VB Data Manager Add-in, so things like Microsoft MDB files, Paradox DB's, DBase etc...
The application should preferably be able to run on a small network (with a server) too, but thats not essential.
What do you Database gods think?
Thanks.
Adam
