Follow Us:

Call us:  (306) 986-8888

December 2015

How to create a box on a Microsoft Access form A recent challenge i ran into was how to display files from a folder in an Access database form.  After a LOT of googling, I discovered there is not much out there on this topic, and what was there was overly complex and not what I wanted.  Hence my blog today.  The basic steps are this:  Create...

Read More

So what do you do when you work 25 years in IT and watch technology change around you?  Use it to empower your life!  We got a little crazy with Kijiji after it came out and spent a few years gathering parts and eventually moving to our Kijiji cabin.  It's rustic, charming, offgrid, somewhat drafty, and remote.  But it's a break from tech after a...

Read More

If you haven't found it yet, YES, you can read the .laccdb (database lock file)  created by a database when it is locked.  This file does not read in a text editor, you need to access it with other means. So what is the .laccdb file?  When a database is opened, Access automatically creates a lock file matching the file name, but with an extension of...

Read More

Over the last few years I've run into many customers with record locking issues.  Given the scenario of a shared multi-user database with the backend stored in SQL or another Access database, you risk two users simultaneously editing the same record.  You may have a form which presents a list of data, or a form with several bound data fields that users frequently edit.  So...

Read More