This is a family-oriented newsgroup and you really shouldn't describe
such things here. There are young eyes, windows to easily influenced
minds, reading it.
The Access Gods have been restless and unhappy lately and I think that I
understand why. Beware!
howard.canaway@[EMAIL PROTECTED]
wrote in news:02e684ca-5f95-444e-9033-
36f47e85eb5d@[EMAIL PROTECTED]
> I have always wondered about the specification page in the Access Help
> files. It reads
>
> Microsoft Access database (.mdb) file size 2 gigabytes. However,
> because your database can include linked tables in other files, its
> total size is limited only by available storage capacity.
> Number of objects in a database 32,768
> Modules (including forms and re****ts with the HasModule property set
> to True) 1,000
> Number of characters in an object name 64
> Number of characters in a password 14
> Number of characters in a user name or group name 20
> Number of concurrent users 255
>
> Now I thought to test the Modules section of this given it is what my
> current project is most concerned with. My current project has been in
> active development for the past 8 years, not a monolithic 8 years
> trying to achieve one goal but an 8 years spent adding small features
> that users request over time, new re****ts, new ways(quicker, simpler,
> etc.) of doing things and simply new things to do. We do everything
> with this software from inventory management to po's invoicing orders
> management individual job management, returns, quality control, etc.
> It really is a monster.
>
> IT has about 700 forms and re****ts with a good deal of re use between
> re****ts, every form does data input and display and each does a lot,
> believe me we manage everything we do with this (its really kind of
> scary when you think of it Access being the heart and soul of any
> medium sized company)
>
> Because at one point we had close to 1000 forms and re****ts (we cut
> out anything that wasn't used in the past year as a sign that well we
> didn't need it) this limit seemed to be im****tant.
>
> I set up a form in access 2003(our company uses 2000 for its main
> business, for a smaller branch we've gone to 2003 as a test before
> migrating) and had it copy one of my previous forms up until i got to
> 1023 (1024 seems like a real number that could be a limit on a
> computer system) and then i set it to add more. and more and more
> until i got to 2000 forms with code modules (granted they were the
> same exact code inside them, so i don't know if access does any
> optimization with code modules that are the same, maybe someone here
> knows?) and access kept on trucking.
>
> I just thought I'd throw this out there to generate some conversation
> and thoughts on how hard the limits MS publishes are and should we
> really be worried about pu****ng access past these points. As we keep
> growing as a company and we add more requirements to our system (we're
> working on becoming ISO 9000 and implementing all the forms and
> procedures within our system along with expanding our current QA
> system to be inline with as the jobs are being preformed on the
> factory floor) it would be nice to know how hard we can push Access
> before we have to rewrite everything into a compiled exe (VB6, .Net
> whatever floats our boat at the time)
>
>
>
|
