ErichKolb.com

This article describes how to configure Microsoft Internet Explorer or Windows Internet Explorer to have more than two download sessions.
Read More »

From time to time its absolutely necessary to restart Windows Server 2003. This command will allow you to schedule an automatic restart at the time of your choice:

at 00:00 SHUTDOWN.EXE -r -f -t 01

Just change the 00:00 to the time of your choice. Now you dont have to stay up until after-hours to do the restart!

In reviewing the configuration of my IIS servers, I decided to remove the Administration Web Site since it’s never used. When you right click on the web site, the Delete option does not appear. Here’s how to remove the site if there is no Delete option? Since Microsoft does not allow you to delete, does this mean we shouldn’t?
Read More »

With Remote Desktop on Windows XP Professional or Windows Server 2003 (in Windows 2000 Advanced Server, this feature was called Terminal Services in Remote Administration Mode), you can have access to a Windows session that is running on your computer when you are at another computer.

What you need to do is create the new RDP listening port via the registry:
Read More »

Did you know there are keyboard shortcuts other than CRTL+ALT+DEL that you can use to lock your desktop? This will prevent people from walking up and snooping on your computer. You can save a keystroke by simultaneously pressing the Windows key + L. The Windows key has four wavy squares.

Or, to make things even easier, create a desktop shortcut.

Right click any empty area of your desktop
Click New
Click Shortcut
Type in the following: rundll32.exe user32.dll, LockWorkStation
Click Next
Name your shortcut
Click Finish

Now it’s as easy as a double click

Ever wanted to know how when you go to a site the cursor is automatically “stuck” on a particular form element?  Its pretty simple actually, just add the following to your input tag:

onload="document.formname.inputname.focus()"

Pretty much how it reads, formname is the name of your form, input name is the name of the field on your form.

A list and description of ways to further run diagnostics on your ipod. All the way from testing your scroll wheel to Scanning your ipods hard drive.
Read More »

The following must be done on your client PC in order to make Microsoft Access work with MyODBC. If you are using Access 2000, you should get and install the newest (version 2.6 or higher) Microsoft MDAC (Microsoft Data Access Components) from http://www.microsoft.com/data/. This fixes a bug in Access that when you export data to MySQL, the table and column names aren’t specified. Another way to work around this bug is to upgrade to MyODBC 2.50.33 and MySQL 3.23.x, which together provide a workaround for the problem. You should also get and apply the Microsoft Jet 4.0 Service Pack 5 (SP5) which can be found at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q239114. This fixes some cases where columns are marked as #DELETED# in Access. Note: If you are using MySQL 3.22, you must to apply the MDAC patch and use MyODBC 2.50.32 or 2.50.34 and up to work around this problem. Install the latest version of MySQL from http://dev.mysql.com/downloads/. Install the latest version of MyODBC 3.51 or 2.50 from http://dev.mysql.com/downloads/connector/odbc/. For all Access versions, you should enable the Return matching rows option. Start working with Access as the front-end for MySQL Server through MyODBC.

You cannot export a table or query to MySQL database unless you have installed the MyODBC. To import or link a table(s) from MySQL to Access, follow the instructions: Open a database, or switch to the Database window for the open database. To import tables, on the File menu, point to Get External Data, and then click Import. To link tables, on the File menu, point to Get External Data, and then click Link Tables. In the Import (or Link) dialog box, in the Files Of Type box, select ODBC Databases (). The Select Data Source dialog box lists the defined data sources The Select Data Source dialog box is displayed; it lists the defined data sources for any ODBC drivers installed on your computer. Click either the File Data Source or Machine Data Source tab, and then double-click the MyODBC or MyODBC 3.51 data source that you want to export to. To define a new data source for the MyODBC or MyODBC 3.51 driver, please Section 25.1.9.2, â¿¿Configuring a MyODBC DSN on Windows⿝. If the ODBC data source that you selected requires you to log on, enter your login ID and password (additional information might also be required), and then click OK. Microsoft Access connects to the MySQL server through ODBC data source and displays the list of tables that you can import or link. Click each table that you want to import or link, and then click OK. If you’re linking a table and it doesn’t have an index that uniquely identifies each record, then Microsoft Access displays a list of the fields in the linked table. Click a field or a combination of fields that uniquely identifies each record, and then click OK.

When Windows applications require user input or focus, they will either pop-up over the existing window, or their icon will flash on the taskbar waiting for user action. This tweak controls that behavior.
Read More »