Who has the largest Access Database in terms of objects (forms etc)???

[Moss100]

I’ve been working on my database for around 15 years - it evolves as the industry changes and gets updated most weeks.

It got me wondering how many others had huge Access databases - it really does confirm the real world power of Access, despite what others may write.

Is there an easy way to get a statistic regarding number of forms, queries etc?

Regards all Mark

 

[67peshawar294]

Moss100, probably not "huge," but the mdb db I created for work 25 years ago in Acess97 ( started out as a Condor db) has; 34 tables, 76 queries, 65 forms, 37 reports, 14 macros and 19 modules. accdb size is 6,235 megs.
I retired in 2009 and still use it as an accdb for reference. I've never asked if it is still in use at the office. It was for an optical shop where I worked as an optician for 4 ophthalmologists. Kept track of patients, frame inventory, glasses prescriptions and before we got a new phone system, would dial the phone number to inform patients their glasses were ready. Would also calculate the imbalance between the two eyes at an axis of 90 degrees for a special grind.
It calculated the price of the glasses with all options and acounted for high prescription, prism...
One of the modules would figure the check digit of a UPC-A barcode and a form for printing a small label with the UPC, price and frame name. The label would fit on a small plastic tab that fit over the temple piece of the frame.
Had daily, weekly, monthly reports for frames sold, prescriptions sold. A calendar for scheduling frame representatives. And on and on.
Wanted to sell the db, but when the HIPPA requirements appeared I knew it was way, way over my head.

 

[Andrzejek]

MZTools offers a whole bunch of statistics, like:
[ul]
[li]File types[/li]
[li]Number of files[/li]
[li]Total lines of code[/li]
[li]Code lines[/li]
[li]Comment lines[/li]
[li]Blank lines[/li]
[li]% of the 3 above[/li]
[li]Classes[/li]
[li]Modules[/li]
[li]Methods[/li]
[li]Properties[/li]
[li]Etc.[/li]
[/ul]
It used to be free, but now you can have 30-days free trial. I would suggest getting it anyways. It is a great set of tools, very useful.


---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson