Friday, April 27, 2012

Access 2007: The Database Has Been Placed in a State by User on Machine That Prevents It From Being Opened or Locked

Problem:  You get the message "The database has been placed in a state by user on machine that prevents it from being opened or locked" when you try to open a shared database over a network.  The database can only be opened by one person while the others receive the above message.

Solution:  The database should automatically open in shared mode, but network security settings may interfere with this.  Try one the following:

1)  Does the first person opening the database see a notification at the top that warns "Security Warning: Certain content in the database has been disabled".  If so, then click on the "Options..." button, select "Enable this content" and click OK.  The notifications should disappear and others should now be able to open the database, but should also Enable the content in the same manner.

To fix this in a more-permanent manner, from the "Options..." button given in the warning, click on the "Open the Trust Center" link at the bottom of the window the appears.  From within the Trust Center window, go to Macro Settings (on the left) and select "Enable all macros".  From now on the security warning should not appear.

2) If you do not see a security warning as describe above, the security settings could still be a problem and Access just isn't notifying you.  In Access, click the Office button in the upper-left corner, select "Access Options", select "Trust Center" from the left menu, and then click the "Trust Center Settings..." button.  From the Trust Center, select "Macro Settings" from the left menu and choose "Enable all macros" from the options.
3)  Create a shortcut to the database by right-clicking the Access file, selecting "Send to >" and choose your Desktop.  From now on, open the database from the shortcut on your desktop.  Solutions #1 and #2 may still apply to this setup.

Wednesday, April 18, 2012

Excel 2007: How To Remove Extra Spaces from Text in a Cell

Some data imports in a spreadsheet can cause some extra spaces to appear before or after text in a cell.  To clean it up, check out the Trim function built in to Excel.  Trim removes any extra spaces besides the spaces between each word.

1)  Create a new column next to the data you wish to trim.  (Unfortunately you can't apply to Trim directly over the top of the current text).

2)  Click the Function (Fx) button next the text box where you input data.

3)  In the "Or select a category:" drop-down, select "Text".

4)  Find Trim from the bottom list and click OK.

5)  Click on the cell that you wish to clean up.

6)  Apply to any other cells or columns you wish to clean up.

7)  Copy the data and paste the values over the original cells.  Voila!

Sunday, April 1, 2012

How to Read Skype Chat History

Two points first:

1)  You can read the history from within Skype by opening up a chat window for a contact and clicking on the links near the top of the chat window that indicate how far back to display conversations.

2)  The Skype log files are located here:  c:\users\username\AppData\Roaming

Okay, now to read Skype history without having Skype open (and you must have Skype closed to unlock the files), try using this free software:

SkypeLogView

Very simple.