Access all areas

04-05-2005 | Categories: — by Phrixus

Having just finished a 2 day MS Access Course my mind is full of the potential application that I could create to make my life much easier! Being that I barely have time to eat sometimes I am trying to put these out of my mind and focus on the real project that I am going to be attempting with my new knowledge. Because corporations value their data and security so highly, I am unable to directly access the DB where the data I need to manpulate for my daily work is held but I can get hold of all the data in a CSV file. I am not able to access my works SQL servers directly or run my own servers so I am left with one option, use the best (only) tool available… Access!! Now that I have learnt just how the query builder works, I feel that my chances of success have been greatly increased. Either way, I now think I should go on the advanced course so that I can the VB code needed to allow prompted queries and the like. Tomorrow will be update, append and split day me thinks!!


Additional Related Entries

No related posts

2 Comments

  1. Get your own Gravatar at Gravatar.com

    Are you not able to even run MSDE (Microsoft SQL Desktop Edition)? So long as your DB doesn’t go over 20Mb it should be *relatively* stable.

    Comment by GrinGod — 4/5/2005 @ 4:43 pm

  2. Get your own Gravatar at Gravatar.com

    Not sure how MSDE would be of benefit as I will still have to write the front end in Access. The DB needs to be opened by various other people to view the reports and it can’t be done via a web interface… no servers allowed!!!

    Comment by Phrixus — 4/5/2005 @ 5:50 pm

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.