Category: Ms Access Tips
-
Ms Access 2003 Bug – Crash after Compact/Repair & Autonumber Resetting
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…
-
Ms Access – Cannot make MDE file error
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…
-
Quick Tip – Conditional Formatting on Ms Access Reports
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…
-
Access 2007 After One Hour – Initial Highlights
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…
-
Access 2003 – Importing Queries results in bad query aliasing.
This is a quick little tip. I came across a minor annoyance the other day when I was importing Access saved queries from another database and using link tables. If you import your queries before you link your tables, then try run the queries with no tables link – Access will complain that it can’t…
-
Ms Access – The Upgrade
I’d never thought I’d ever say something so geeky but I must comment that I don’t think I’ve ever been as excited about downloading a product as I am right now. And right now I’m downloading Ms Access 2007. I’m taking advantage of the http://www.itsnotcheating.com.au offer, and buying the new version of Office 2007 Ultimate…