DMS Facets

Relating several topics, including IT, Microsoft Access, sports administration, and micro-ISV business.

Real World Access (43)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Doug Yudovich’s Claims Reconciliation Sisyphus’s Quest The process was grueling – if not physically, then mentally, filling one’s day with Sisyphean tasks: Print the acceptance reports from the clearing house; Print the claim run reports from our billing […]

0

Real World Access (42)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Gina Whipp’s Franchise Management Imagine you’re a Company with franchises all over the United States. You have Brokers located in several states managing their regions. You have billions of Prospective Buyers all over the world that might be […]

0

Enigmatic Technology

Some rambling quirky personal revelations My friend Kirk once told me that I am “an enigma”.  I remember this, because even though I have a pretty good vocabulary, I had to look this one up to be sure. The circumstances at the time were that I chose not to try and find a place on […]

0

The Place of VBA

John R. Durant helps put things in perspective Over on Glenn Lloyd’s blog, there is a reference to an interesting article on John Durant’s blog, entitled “Why VBA Still Makes Sense”. At first glance, I thought this article was making a case for VBA to have a continuing strong place in the toolkit of Office […]

1

What is SharePoint

… from the Access developer’s point of view? We’re moving towards the release of SharePoint 2010, and with it a new stage in the life cycle of Microsoft Access. In a nutshell… we will be able to build a database  application, right in Access itself, using tools entirely native to Access.  And then we will […]

0

Three way street

Collaboration the hard way I have recently had one of the more unpleasant experiences of my career in software, and have been reflecting on where did the process go off track. Analogy It was pertinent for me to think of a building analogy. Let’s say you’re a plumber.  You’ve been looking after the plumbing needs […]

0

Real World Access (41)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Roger Carlson’s Training Registration Several years ago, Spectrum Health, the largest hospital system in out-state Michigan, changed its Hospital Information Management system. Since they employ over 12,000 people, scheduling the training for those employees in the dozen or […]

0

SharePoint Book Recommendation

Ishai Sagi’s new book SharePoint MVP Ishai Sagi has recently published a brand new book about SharePoint 2007. In a word – masterful.  Congratulations, Ishai, on a great contribution! The author is careful to point out that the book is not targeted to the technical end of the spectrum – the professional SharePoint developers and […]

0

Doing the Access Stretch

Pleasing Some of the People Some of the Time I have heard it said that the best thing about Microsoft Access is that it’s part of Microsoft Office, and the worst thing about Access is that it’s part of Office. For one thing, if it wasn’t part of Office, it’s doubtful it would have survived […]

1

Sweet as cherry pie

Bing causing a sensation People are noticing. Bing has sort of sneaked out of the closet while nobody was watching.  And we find that it has grown up since we last checked. Somehow, you get a sense that Microsoft are getting it right this time. We have an internet  search engine that has come a […]

0

Non-commercial Re-installations

A challenge for freelance developers Maybe it’s just me.  But I suspect this is a situation faced at times by others who work at the micro-ISV level. It has happened to me 3 times in the last week.  Customers have got a new computer, and have installed “my” application, without contacting me. Well, what’s wrong […]

0

Access Security

Management by Technology When planning and designing a Microsoft Access application, the question of the security of the data has to be carefully considered. Similarly, one is called upon, from time to time, to discuss this aspect in technical forums and newsgroups. Of course, from the technical angle, there are many aspects that could be […]

1

Nana is 100

On a personal note… My family and I have returned home from a very special visit to Adelaide, South Australia – my home town. The purpose for the trip was to help my grandmother Phyllis Schapel to celebrate her 100th birthday, on 10th January. Of course it was a very family-oriented affair. Wonderful to catch […]

0

Snip Snip

I like the Snipping Tool in Vista Sometimes “quick and easy” is good. The Snipping Tool which is part of Windows Vista is a screen capture utility. For me, it’s been a recent discovery.  But since that time, I have found myself grabbing it fairly often. The best thing about it is that it’s “feature-sparse”! […]

2

Real World Access (40)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Jeanette Cunningham’s Roads and Bridges ParkRoads is an MS Access based road and bridge asset management program. It is designed for use by rangers and other road management staff in Parks Victoria, a national park management agency, in […]

0

Database discussion

Access & SQL Server at US TechEd There is a video recording available of an interesting panel discussion, chaired by Mary Chipman at the US TechEd in June. It is about considerations for moving a database from  JET/ACE to SQL Server. This is a topic where one can often find considerable confusion.  You will see […]

0

Access White Paper

I went to a SharePoint User Group meeting tonight.  A great presentation by visiting British trainer Craig Carpenter. But I digress… Somehow at these events I always seem to end up mentioning Access to somebody. And, as is so often the case, the “somebody” is apparently surprised to know that Access is being used in […]

0

Real World Access (39)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Bob Larson’s Medical Point of Sale Providence Health System, in Portland, Oregon, was opening a retail outlet for selling appearance items for cancer patients in one of their hospitals. They needed a Point of Sale (POS) system in […]

0

Real World Access (38)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.  Branislav Mihaljev’s SMS Messaging One of the customers asked me if I can build a database program in Microsoft Access which he will use to send single or mass SMS text messages. Basically it is a simple task, […]

0

Shonky Operator

Beware of Roger Hamilton and XL Results Foundation I recently received an invitation to a presentation in Wellington by Roger Hamilton from XL Results Foundation. The topics of the meeting included personal profiling, wealth creation, and business success.  I figure I always have something to learn. He does this all around the world. I attended […]

13