Databases

[Gonzo]

My client has decided at the absolute last moment to use a timesheet system which uses Excel files - which are uploaded into a Access database. Guess who got stuck writing the system?
We got stuck doing it 'coz the twit who was supposed to do it...took six months to decide that he couldn't do it. How he keeps his job....

Now I'm stuck with some anus auditor fellow who keeps loading the timesheets manually into a excel sheet - all 200 of them - to double check the database numbers. No wonder this place is constantly in a state of change!

Is there anywhere that is run well? Years ago, I worked at a place where the admin staff took before and after screenshots of every change that they made to the account records and filed them in the manual filing. It was because they did not trust the computer system.

[MarillionFan]

The thing is, when I turn up sometimes and I know its a small gig, I give 'em a spreadsheet using Macros, ADO & Power Functions

[Gonzo]

The thing is, when I turn up sometimes and I know its a small gig, I give 'em a spreadsheet using Macros, ADO & Power Functions

I'm sure they are fine. Its when you get users with a little bit of knowledge developing their own solutions that you can find some complete pigs ears.

EDIT - oh yeah, and the other pet hate is where they have had some contractor come in and knock something up for them using Excel and they can't tell you how it works!

[MarillionFan]

I write stuff that I know 90% of contractors wont have a ******* a clue how it works let alone permies.

Why. Cause it's short-term baby and if you wanted a proper solution then you'd pay the developmnt money.

MF in 'KEEPING US ALL IN WORK' mode.