Double-clicking on Shortcut Doesn’t Work

Ok, you’re sitting at your desk and you get a call. A user double-clicks on their shortcut and the Access 2003 application does not open. No error. No activity. Nothing.

The user can still open up Microsoft Access, and open the MDB file from there just fine. What’s going on?

This is actually a common problem.

Network technicians don’t always know that an MS Access shortcut actually requires you to reference ‘msaccess.exe’. They’ll generally copy the .mdb and ‘paste shortcut’ on their desktop. Oh the shortcut will work if no one else is in the database, but once someone gets in. For whatever reason the access shortcut needs the reference.

Anyways I hope this post helps someone out. If it does let me know in my comment section!

Tweet This Post

Compact and Repair In Access 2007

For whatever reason I’ve never been sold on the new Vista Windows Office look with the Ribbons.  If you ask me it just seems more complicated then necessary and the navigation seems to take up more room.

Does Microsoft understand that customers get reluctant to upgrade because they keep moving all the options and items around?  Don’t they understand that customers don’t want to relearn a product that is already doing the job on it’s own?

Well anyways, on to the point of this topic.  Compact and Repair in Access 2007.  Where is it?  Is it under ‘Tools/Database Utilities’ like it is for Access 2003?  No!?!?  Those options don’t exist in 2007.  The most intuitive option or the closest option in 2007 is ‘Database Tools’.  But is it there?!  Of course not!

 

 

 

 

 

 

Then select ‘Manage’

 

 

 

 

 

 

 

 

 

 

Then select ‘Compact and Repair’.  And that’s it.

So, there you go.  That’s where Microsoft put the all important tool!  I can see that it “fits” there.  But Microsoft at least provide us with some kind of cheat sheet as to where you moved everything.

Tweet This Post