Skip to content

DBs in general

June 26, 2018

Ok, I support various DBs in my job.  I support two access DBs.  Support =s updating code in a few places when necessary, Support =s adding new functionality to the system.  New functionality means adding tables, forms, reports, queries.  Also, supporting the DB means fixing data.  Annually, my customers who use the DB create orders.  The orders are the transactional data.  The transactional data is kept in a separate DB from the code that generates it.  Good design.  Linked tables to be specific.  Every year, there are a handful of transactional records that do not process correctly.  Each year, I open the data DB and scrub the data for her, correcting it.  The first year took a while, each successive year a little quicker, familiarity helps, this year, I was able to isolate and update the transactional records in about 15 minutes…..

Which begs the question, why don’t you try to correct the issue with the code that generates the problem.  Treat the problem, not the symptom.  A fine principle indeed.  Last year, I decided to correct the problem and it was so!  Until my customer added more units (science kits) and they are experiencing the same issue that I corrected last year.  HUH?  I don’t really care too much, since I can correct the data (scrub a dub dub).  My customer gives me lots of details about how to see the incorrect record data via the application – “james, click here and then there and then do this and that and there it is….”  I snicker, since I browse into the data DB, open two tables and away I go.

My point here is that while we can know that something is wrong, correcting it is sometimes not any better, since the error often is between the chair and the keyboard.

Know your system, correct problems in code when it makes sense, correct transactional data when appropriate and move on.

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: