Re: MS Access usefulness and size restrictions

Richard H. Rowson <richard_at_rhrowson.freeserve.co.uk> wrote:
> Since I can build one that doesn't fall over with 25 users, and I don't even
> develop full time at the moment as I have other duties to perform, I would
> shoot the developer who can not get Jet to perform better than 5
> connections. I wouldn't pay a contractor who delivered that ineptly. Excel
> workbooks can deal with five users working on them and it maintains a
> conflict history. Either the original developer was worse than incompetent
> or statistics are being manipulated.

hmm, i thought, that excel opens table for writing only once and for reading is not limited. Btw, in my ex-company, reporting stuff was based on excel VBA. The size was about 15MB per year (only agregated data) and working with it was "absolute masochizm".

Probably the difference is with the conformity of the response time. I saw (and seeing everyday) JET with cca 15-25 concurent users working on raw data with minimum use of constarints(mistake of the design) and huge JOIN operation over tables with less than 500000 lines and i have to admit that JET is greatly loosing his breath. As I wrote above with any extra connection the performance drops exponentially.

Access is good from small size up to lower midsize companies, whoses employers doesn't mid to run a report and have a cofee.

Bohdan Linda Received on Mon Jul 02 2001 - 05:24:23 CDT