适用ACCESS97、2000
这两项磁碟机资料须使用API函数方可取得，代码如下：
Private Declare Function GetVolumeInformation Lib "kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As String, ByVal lpVolumeNameBuffer As String, ByVal nVolumeNameSize As Long, lpVolumeSerialNumber As Long, lpMaximumComponentLength As Long, lpFileSystemFlags As Long, ByVal lpFileSystemNameBuffer As String, ByVal nFileSystemNameSize As Long) As Long
Function GetVolumn(X As String) As String
If Len(X) < 3 Then
X = Left(X, 1) & ":\"
Else
X = Left(X, 3)
End If
Dim nRet As Long, VolName As String, VolSN As Long, MaxCompLen As Long
Dim VolFlags As Long, VolFileSys As String
VolName = Space$(256)
VolFileSys = Space$(256)
nRet = GetVolumeInformation(X, VolName, Len(VolName), _
VolSN, MaxCompLen, VolFlags, _
VolFileSys, Len(VolFileSys))
If nRet = 1 Then
GetVolumn = VolName
Else
GetVolumn = ""
End If
End Function
Function GetNumber(X As String) As String
If Len(X) < 3 Then
X = Left(X, 1) & ":\"
Else
X = Left(X, 3)
End If
Dim nRet As Long, VolName As String, VolSN As Long, MaxCompLen As Long
Dim VolFlags As Long, VolFileSys As String
VolName = Space$(256)
VolFileSys = Space$(256)
nRet = GetVolumeInformation(X, VolName, Len(VolName), _
VolSN, MaxCompLen, VolFlags, _
VolFileSys, Len(VolFileSys))
If nRet = 1 Then
GetNumber = VolSN
Else
GetVolumn = ""
End If
End Function
前面的Declare陈述式宣告一个API函数（GetVolumeInformation），可取得磁碟机的两项资料。
