Tip Bank

DevX - Software Development Resource

GetFileVersionData – Retrieve file versioning information

Private Declare Function GetFileVersionInfoSize Lib “version.dll” Alias _ “GetFileVersionInfoSizeA” (ByVal lptstrFilename As String, _ lpdwHandle As Long) As LongPrivate Declare Function GetFileVersionInfo Lib “version.dll” Alias _ “GetFileVersionInfoA” (ByVal lptstrFilename As

DevX - Software Development Resource

GetDriveInfo – Drive serial number and other data

Private Declare Function GetVolumeInformation& Lib “kernel32” Alias _ “GetVolumeInformationA” (ByVal lpRootPathName As String, _ ByVal pVolumeNameBuffer As String, ByVal nVolumeNameSize As Long, _ lpVolumeSerialNumber As Long, lpMaximumComponentLength As Long, _

DevX - Software Development Resource

DriveType – Determine the type of a drive

Private Declare Function GetDriveType Lib “kernel32” Alias “GetDriveTypeA” _ (ByVal lpRootPathName As String) As LongConst DRIVE_UNKNOWN = 0 ‘ type can’t be determinedConst DRIVE_NO_ROOT_DIR = 1 ‘ wrong argumentConst DRIVE_REMOVABLE

DevX - Software Development Resource

DriveExists – Check whether a logical drive exists

Private Declare Function GetLogicalDriveStrings Lib “kernel32” Alias _ “GetLogicalDriveStringsA” (ByVal nBufferLength As Long, _ ByVal lpBuffer As String) As Long ‘ Check whether a given drive exist’ Note that this

DevX - Software Development Resource

Moving Logs and Databases

Question: I need to remove a drive from a Microsoft Cluster Server. As a result, I have to move the Message Transfer Agent log files, the Directory service database file,

DevX - Software Development Resource

Vacation Tracking

Question: Is there a way to track staff holidays using Microsoft Outlook and Exchange? Answer: To track them? That depends upon your definition of tracking, I suppose. The way that

DevX - Software Development Resource

Multiple Indexes

Question: I’m creating a database to be used with a Web site. The database contains news stories, which will need to be indexed from a list of keywords that come