How to reclaim the diskspace from SQL log file (.LDF)?

To reclaim disk space from SQL log file

- Detach the database using Enterprise manager or Stored procedure.
- Delete the log file physically
- Attach the database using Enterprise Manager which will create a new log file for the database

Windows XP STOP Error 0x0000023

Recovery from this error is done with following process.

• Boot from Windows XP installer disk and choose Recovery console,
• login to Windows XP installation giving problem and
  
• Run 'Chkdsk' with '/r' option

0x23 error is because of FAT problems, checkdisk (chkdsk) recovers from problem.

Images not shown on MS Access form

Problem: Your MS Access form/report has a BoundObjectFrame control to display images but it is not showing images. It just shows a icon with image file name.

Solution:Install Microsoft PhotoEditor application from office CD. It is not availbale with office 2003, you have to install it from earlier versions like Office XP or Office 2000. It should solve your problem.
It is the problem with the association of image viewer application with image file types.