Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How competitive is Access?
- Thread starter Linda354
- Start date
MichaelRed
Programmer
If your'e going to ask the question, it needs to be 'bounded'. Ms. A. is a venerable contestant in the realm of small relational dbs. It has excellent support, a wide usage and some features not yet even approached by the "Industrial Strength" databases. It is NOT a competitor in that arena.
It is more or less completely lacking in Client-Server knowledge / capability, although the caching scheme is quite good, this does not relpace client-server capability.
The lack of client-server capability also means it does not have any 'stored' procedure capability and no row-set triggers.
The up-side is the report generator capability, and it's considerable capability and polish. It (the report generator) is both mature and quite sophisticated.
Many applications use Ms. A. as the "Front End" for the INdustrial Strength data bases, obtaining a better overall system than eithr Ms. A or the Industrial Strength db by themselves.
Of course, the above is just my opinion.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
It is more or less completely lacking in Client-Server knowledge / capability, although the caching scheme is quite good, this does not relpace client-server capability.
The lack of client-server capability also means it does not have any 'stored' procedure capability and no row-set triggers.
The up-side is the report generator capability, and it's considerable capability and polish. It (the report generator) is both mature and quite sophisticated.
Many applications use Ms. A. as the "Front End" for the INdustrial Strength data bases, obtaining a better overall system than eithr Ms. A or the Industrial Strength db by themselves.
Of course, the above is just my opinion.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question