Category Archives: General

Access Report Design – Cluttered Controls – Can Grow & Can Shrink

By daz | Published: January 10, 2008

Here’s a quick tip with regards to report, and to a lesser extent, form design. Many times when you’re design Ms Access reports, often you will come across spatial problems, where you simply trying to fit too many controls (usually textboxes) on a report – even when you’re designing in landscape mode. Two extremely handy [...]

Posted in General | Leave a comment

Windows cannot access the specified device, path or file. You may not have the appropriate permissions

By daz | Published: November 14, 2007

Argh! At work today a computer took ill. An XP SP2 Box, which had been working faithfully for the past 3 years, had suddenley decided to disallow its users from accessing any program executables through the desktop and via the control panel. This problem started occuring while I was away, so I wasn’t actually present [...]

Posted in General | 2 Comments

Ms Access 2003 Bug – Crash after Compact/Repair & Autonumber Resetting

By daz | Published: October 30, 2007

Two little tidbits of information today. Firstly, a bug that occurs in Access 2003 after you try run the Compact/Repair function. This is a really annoying bug that seems to occur randomly in Access 2003. What happens is that for one reason or another your database corrupts, and when you try open it, Access tells [...]

Posted in General | 3 Comments

Ms Access – Cannot make MDE file error

By daz | Published: October 17, 2007

Well, as usual, I published Access tips in response to problems that I come across, and get around, during my day-to-day Ms Access development. As we know, Ms Access ain’t exactly the most stable product ever made and there are many bugs which often occur with badly explained non-sensical error messages. Today, I kept getting an error [...]

Posted in General | Comments closed

Quick Tip – Conditional Formatting on Ms Access Reports

By daz | Published: June 25, 2007

This is one little annoying problem that there is not enough obvious documentation for within Ms Access 2007. While it might seem obvious enough, at the time, it wasn’t to me (so who is to blame, my lack of knowledge, the software interface, or the help documentation?). I was developing a report in Ms Access [...]

Posted in General | Comments closed

Access 2007 After One Hour – Initial Highlights

By daz | Published: March 22, 2007

I’ve been using Access 2007 for about an hour now, quickly developing a small database to store information on what periodicals I’ve been reading for my thesis, and when I have accessed them. Quick review – it is fairly impressive! Highlights are: The Ribbon Gui common to all Office 2007 products is used very well in [...]