Disable AutoStart Macro (MS Access)

Q. I have an MS Access file that I'm trying to open. While starting, it tries to run a macro that crashes (hangs, doesn't work, etc) and then kicks me out. What can I do?

A. Disable "AutoStart" macro. To do that press and hold the "Shift" button while opening your database.

Note: if your macro used to bring up forms and you've stopped it, you will need to open the forms manually. Click on the Drop-down menu in Navigation Pane and select "Forms" From there you'll be able to get the forms you are looking for

Internet Explorer 7 Crashes when using OWA

Q. After I've installed S/MIME control, my browser is crashing any time I'm trying to send an email using Internet Explorer.

A. This is a known bug with MS Exchange, and you can resolve it by downloading a hotfix:

Update for Exchange Server 2003 SP2 (KB 924334)

Certificate Signing Request (CSR) Generation

Q. How do I generate a CSR?
A. Here are generic instructions on how to do that.

1. Generate Private Key

Generate a 2048 bit RSA private key and store it in the file www.domain.com.key (the name of the file is not important, this is just for your records):

openssl genrsa -des3 -out www.domain.com.key 2048

Upgrade Fedora 12 to Fedora 13

Q. I'm trying to upgrade Fedora 12 to Fedora 13. I've ran into some issues, while upgrading using the traditional methods (Running yum install preupgrade and then running preupgrade-cli). The error that I get is that there's not enough space to save install.img on my boot partition. (The size of the file is 140mb and the partition is 100mb).

A. One way to fix this, is to delete your old kernel images. But this would not solve your problems if your /boot partition is 100 meg, additionally, during the upgrade, the system deletes all obsolete kernels. The solution to this problem is to do a different kind of yum upgrade. (Thank god the days of only upgrading Fedora with a DVD are over!)

Create a video from images

Q. I have a bunch of frames (images) that I took, I would like to create a video using them.

A. Assuming that the images are frames and not just random pictures, you can use mencoder to create the video. MEncoder is capable of creating movies from one or more JPEG, PNG, TGA, or other image files. With simple framecopy it can create MJPEG (Motion JPEG), MPNG (Motion PNG) or MTGA (Motion TGA) files.

mencoder "mf://*.jpg" -mf fps=10 -o test.avi -ovc lavc -lavcopts vcodec=msmpeg4v2:vbitrate=800

Ask for a password, unless from specified IP (Apache)

Q. When accessing a directory in apache, I would like to set up a way to ask for a password from a user if he is not listed on the allowed IP list.

A. This one is a bit of a pain to figure out, so here it is:

<Location />
Order Deny,Allow
Deny from all
AuthType Basic
AuthName "Access Restricted"
AuthUserFile "/var/www/.htpass" #your password file
Require valid-user
Allow from 192.168.5.10
Allow from 192.168.10.10
Allow from 10.10.10.3
Satisfy Any
</Location>