Recently, a client started experiencing errors, seemingly at random, in the database application I managed for them. The errors immediately started mentioning corruption and then these came through … Error 3167 – Record is Deleted Getting everyone out of the system and running a Compact / Repair seemed to help, but then … “The Microsoft…
Should You Keep Using Microsoft Access?
Full Disclosure – I Owe My Career to Access I’ve been working with Microsoft Access off and on since 1997, just a few years after it was first introduced in ’92. I can realistically say that learning Access made my career in I.T.. I’d had some previous programming and database experience with Borland Paradox and…
How to Shut Down Remote Instances of Microsoft Access
When you’re managing a multi-user Microsoft Access application, there are times when you need all users out of the database so that you can make changes to table structures and other items. Asking everyone to shut down is unreliable and using the Windows Task Manager to forcibly shut down instances of Microsoft Access is risky…
Latest Mystery: Tracking Down the Archive
I installed The Events Calendar by Modern Tribe, Inc. on another site the other day so I could keep a community calendar of tech and business events. It seems like a pretty good WordPress plugin which is probably why it has over 700,000 installs. It’s not perfect – the free version doesn’t handle recurring events…
Five WordPress Plugins That Will Enhance Your Website
WordPress is the most popular Content Management System, powering approximately a third of the world’s websites in September 2019 according to W3Techs.com. One of its advantages is the ability to quickly add almost any necessary features through the installation of plugins. The WordPress marketplace includes over 50,000 plugins, many of which are free to download…
Managing Your Organization’s Contacts with CiviCRM
Whether you’re selling products, managing a non-profit or running a political campaign, one of the most important things you do is to manage relationships with other people. Your ability to maintain your organization’s contact database, whether it contains potential customers or donors, is essential to your operations. Many organizations use various types of Contact Relationship…
Troubleshooting MS-Access Error 31532 – Unable to export data.
Microsoft Access can sometimes seem to have its own obstinate personality, throwing errors that persist no matter what you try. I wanted to share a recent troubleshooting experience to show some of the steps that you can take when a function is just not working as expected and the decision process involved in fixing it.
Things I Learned About CiviCRM This Week
I was introduced to CiviCRM a few years ago when a new customer needed a replacement for an old poorly designed database solution and needed it quickly. After getting quotes starting at $10,000 for systems supposedly designed for non-profits, I stumbled on CiviCRM which was free, open source and seemed to have a good community…
Deploying MS-Access Table Design Changes to Remote Files
A New Challenge for Access I designed a Microsoft Access database for one of my clients and it’s split into two files – a front-end file with all the forms, reports and code and a back-end file with the tables. That’s pretty standard. During the development process, I needed to make adjustments to the table…
Unboxing the Unitek IDE / SATA to USB 3.0 Drive Adapter
I hoped it would be a simple fix when the customer asked me to look at her Windows 7 machine this week. I don’t really do PC repair anymore but I have one or two old customers I’ll help out when needed. I figured it was just some Windows settings that needed adjustment but after…