Follow Us:

Call us:  (306) 986-8888

Blog

There is nothing easy when it comes to trying to bring security into your Access database.  Ideally you would use SSO and talk to Active Directory.  Or SQL and have that applied.  But when all things are considered if you just want a simple solution to better handle options for users, and are not worried about password integrity...

Read More

Thinking of migrating to Access 2016?  Here is the high level overview: BACKUP your database.  if it is split, be sure to backup both the front end AND the back end. Open the database in Access 2016.  At this point, I am guessing you have NO issues, and it worked.  That was hard, wasn't it?  be sure to check the back end as well. Now, in...

Read More

A common problem I see when visiting a prospective client site or providing guest lectures on Access at User Groups: "My database always prompts me to click Enable when I open it?" First, I am surprised many people think this is normal.  Google would be quick to walk you through fixing this.  BUT, I do get a lot of people with this issue. This is happening because Access...

Read More

A common problem in Access is the lack of drilldown reports.  Our approach to this is to build something where you get a similar drilldown result but using clickable links to more detailed reports relative to a record being selected.  YES, you can build drilldown reports that act and feel more like a drilldown report (we do this using forms actually, which respond based on...

Read More

The Wannacry cryptovirus is causing global problems.  As of Sunday, May 14, the virus has spread to well over 100,000 systems in over 100 countries.  Version 2 is supposedly making the rounds now, the total effect of this virus is not yet known.  This virus attacks unpatched systems running Windows Server 2008 or older on an SMB exploit that was patched in March 2017.  The NSA...

Read More