Home At GPC

Resources & Links

Access Test Bed

Tip of the Day

Other Free Downloads

Contact GPC

Start the conversation
by calling me at 425-876-0535
or emailing me at GPC Data.

I design and build databases for local and remote clients out of my location near Bellevue, Washington.
 

I am a 2007-2011  MS Access MVP Awardee

GPC Data - Ecachivachi

GPC Smart Tools for Smart Business^©

Ecachivachi

One of my favorite Venezuelan colloquialisms is "cachivachi". It means, roughly, "stuff" or "junk", as in "the junk drawer in the kitchen".

The EW used to remind me, from time to time, that my home office was filled with "cachichvachis" that needed to go to the dump. She was right, most of the time.

I have come to think of this page as my "Ecachichivachis". It's all that stuff that doesn't belong anywhere else, but I just can't bring myself to toss it out yet. You can smile, laugh, frown or turn the page; it's all good.

What's the sound of one geek laughing?

This is one of my New Favorite Cartoons: xkcd.com

Here's another: Raw Materials You'll have to register, but it's worth it, if you are a computer geek, or are in love with one.

Join Me on Linked-In

MS Access Template Downloads

I am thrilled by what I'm seeing on the MS Template Site. Unfortunately, Microsoft accepts only macro-driven templates, so my Work Tracking demo can't be uploaded there. Visit to get a full, working version here at GPCData. I'd love to hear What You Think.

19,900 DOWNLOADS--and counting

A little over three years ago, I submitted my first template for Access 2007 to the Microsoft Access Templates site. It consists of a table schema and a couple of forms with comments on the tables. Microsoft plans to accept databases with VBA in them. However, for the moment, they are still limited to macros.

It's slowed with the introduction of 2010, but the last time I checked, Microsoft reports that my contribution has been downloaded over 19,900 times.

Access Stress Test Data

Has this ever happened to you? You deploy a new database and everything is fine for a few weeks, or months. Eventually, though, users start to complain about slow response times and other problems. And they want you to fix it, NOW.

Have you ever wished you could do some really heavy duty stress tests before you put your application out there and head off that kind of result?

Here's a tool  (A2003 format)to help you do just that. A colleague of mine has packaged up several million rows of sample data that you can download and adapt for use in your pre-release testing. If you decided to use this data, we'd love to hear about your experiences with it. infogpcdata@gpcdata.com