[AccessD] I can't Believe this

Hi Bryan:

<Wednesday rant mode>
Be careful on the number of lines of code in MS Access. The last major
provincial government application that I created was deemed too complex to
support, with too many users and with using 'non-standard deployment of
technology' but the clients were very pleased with the programs performance.


To the chagrin of the department, the application was rebuilt using Oracle
forms with an Oracle DB and with a 700,000 dollar price tag. The department
was upset when that version proved too slow, too awkward to use and with too
few features. It is now being rebuilt again, by another company, at another
huge price tag, in Oracle. ...  (If I knew management wanted to throw
tax-payers money away I could have rebuilt my application twice at half the
price.) 
</Wednesday rant mode off>

Anyway I have been getting some good contract work as compensation from the
local department management, so I guess I should not complain.... too much.
MS Access seems to have a bad rap, especially with our provincial
government. It appears that your federal government department is more
enlightened.

Now that felt good getting that off my chest. :-)

Jim          

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bryan Carbonnell
Sent: Wednesday, March 28, 2007 5:36 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] I can't Believe this

I can believe this.

I have been asked to supply to IT, information on the custom Word,
Excel and Powerpoint templates we use regularly. That was fairly
simple. Only 8 total with less than 500 lines of code combined.

However, I also sent info off about our primary Access DBs.

One of them has over 10K lines of code, 60 queries, 40 table.

Another has almost 15k lines of code.

I couldn't believe that those DBs had that much code. I knew I worte a
lot, but didn't think that it was that much.

All I can say is thank goodness for MZTools and it's statistics. I'd
hate to count that many lines of code by hand.

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com