RonO (rono_60103) wrote,

  • Mood:

B***** Virus Writers

Having nothing more productive to do at work today, I was playing with a Visual Basic for Applications (VBA) function that will take the MS-Access database and convert it into a text file that should be able to populate a mySQL database (or possibly any other SQL database) with the same tables and data.

Since I have no use for this at work -- I don't have access to an SQL database that I could move the one Access database I maintain at work into -- I am thinking of using this with the DucKon registration database to create a proof-of-concept that I could move the data to MySQL but keep the functions I need at-con under Access where I rely too heavily on specific Access features.

Since the database, or at least the out-of-date scratch copy I have here at work, has a bunch of strange extra fields in each table, I modified the function to eliminate these; and then had to debug my modifications.

Once I had a working version -- or at least enough of a working version to send home -- I tried to send it home. First, I exported the code from MS-Access, creating a file with a .bas extension. Next, I tried to e-mail this home. That is where I ran into trouble. Apparently there is some virus floating around that uses files with a .bas extension. To prevent the spread of this virus, some part of the Motorola e-mail system will not allow such files to e-mailed.

So, thanks to some immature people who think that randomly disrupting or destroying other people's computers is fun, I had to compress a 12KB text file in order to e-mail it home.


  • Life Report/Trip Report

    When last I posted way at the other end of this surprisingly long February, I had a job, and a potential house.  Since then, Tara and I have packed…

  • Life Updates

    For the few people who only see my updates from my blog (or LiveJournal which mirrors my blog), here are a couple of updates on my life: 1: I have…

  • Transitions

    This morning, I was called into a meeting with my bosses boss.  As soon as he asked for the meeting, I was pretty sure what the meeting was about,…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded