[AccessD] I can't Believe this

MartyConnelly martyconnelly at shaw.ca
Wed Mar 28 13:53:26 CDT 2007


I know Oracle has been BC government's de facto standard for 10 years.

But Oracle Forms are gaggh. Plus they tend to find that good Forms 
developers
with experience are hard to find and usually very underpaid.
They usually get first year programmers with 30 days training from most 
major
consulting firms. But then I haven't touched Forms since the 90's

It might have been better to use ASP.Net or VB.Net and buy a RAD tool
like DeKlarit or Iron Speed Designer for a couple of  $1000.


Jim Lawrence wrote:

>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.
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada




More information about the AccessD mailing list