Re: MS Access usefulness and size restrictions

We are running an Excel workbook over the LAN with multiple updates, but you do have to enable sharing - apologies for a little off topic BTW. I have worked with Excel workbooks bigger than 15Mb and the only issue has been memory size (this was before memory was so cheap and my employer was trying to get me to manipulate large files with 32Mb RAM & a P150. It ran fine on a PII 400MHz and 64Mb RAM).

No doubt one of the finer minds than mine could suggest as to why your application was a dog with 25 users, but I would suggest that perhaps it needed a re-write to optimise it for multiple users.

--
Regards,

Richard H. Rowson

<b.linda_at_sh.cvut.cz> wrote in message news:9hpi4n$l01$1_at_ns.felk.cvut.cz...


> 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