OO 2.0 Question 9964

Quantum Leaper

Agreed that the db part is not an Enterprise-level tool, but the querying and reporting modules can be considered such.

I'll take a look at Seagate Info 7. Sounds like some kind of reporting system - ie no dbms.

You can build just about any level of complexity of a relational db as you need in Access. I don't promote it for large-scale systems with lots of concurrent users and millions (or even hundreds of thousands) of records, but for small to mid-size department systems in companies running MS Office, or for querying and reporting on disparate data sources, it's a no-brainer.

Examples of Access-based systems I've deployed in the last few years (mostly not concurrent users): * capture field data (surveys, comments) locally, produce analysis and reports, periodically upload data to master Oracle db (70 users) * import lists of email addresses to Access system, then autogenerate emails to employees (10 users) * schedule daily am and pm meetings - upload to master system (70 users) * IT time reporting program: Access front-end, Oracle back-end (100+ users) * franchise operating performance summaries and analysis: lists, charts, graphs, tables (several hundred users) * track renovation history of rental properties (40 users, 10 or so concurrent)

I'm not exaggerating at all: OO Base stinks. It's not nearly the program Access was 10 years ago. It's not even as good as Borland Paradox for Windows was in 1993. Maybe it'll get better, but if you're looking for a good local db-query-reporting tool don't waste your time.