[AccessD] I can't Believe this

Boy have I heard that one before and seen it too!  Government IT
departments like applications they can control to a fare-thee-well and
are highly suspicious of anything a user can understand and might be
tempted to play with or (horrors!) ask questions about why it works that
way.  Never mind that the apps in question take many times as long to
build and have outrageous price tags--you get what you pay for, right?
Large corporations often fall into the same trap, throwing bad money
after good because they need "real" applications ... That IT can lock
down to prevent ... Etc., etc.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Wednesday, March 28, 2007 9:48 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com