Nancy Lytle
nancy.lytle at auatac.com
Wed Mar 26 07:55:34 CST 2003
Can anyone tell me why I would get this message?
Provider not found. It may not be installed properly.
I understand the meaning, it's just that the provider it can't find is Jet.
Here is the code.
rstGroup.Open strSQL, "Provider=Microsoft.Jet.OLEDB.4.0" & _
"Data Source=C:\AccC:\AccessTests\CRDatabaseTest\CRMasterFE.mdb:"
Any assistance appreciated.
Nancy Lytle
The entire context is:
Public Function StartDB()
Call fcnOSUserName
Dim strSQL As String
Dim strGroup As String
Dim intClientIDCount As Integer
Dim rstGroup As ADODB.Recordset
Set rstGroup = New ADODB.Recordset
strSQL = "Select Group from tblUsers Where UserName = " & "'" &
fcnOSUserName & "'"
rstGroup.Open strSQL, "Provider=Microsoft.Jet.OLEDB.4.0" & _
"Data Source=C:\AccC:\AccessTests\CRDatabaseTest\CRMasterFE.mdb:"
strGroup = rstGroup.GetString()
If strGroup = "A" Then
DoCmd.OpenForm "frmAdministration", acNormal, "", "", , acNormal
DoCmd.Maximize
ElseIf strGroup = "RW" Then
DoCmd.OpenForm "frmDataEntry", acNormal, "", "", , acNormal
DoCmd.Maximize
Else
DoCmd.OpenForm "z_RFil5_frmCustom", acNormal, "", "", , acNormal
DoCmd.Maximize
End If 'User name
End Function