P
Phill Prescott
I have created an Outlook form that user's fill out and mail to me. In the
form I have code such the following that writes the information in the form
to a table in an MSAccess database:
Set MyControls = Item.GetInspector.ModifiedFormPages("User
Information").Controls
Const adCmdTable = 2
Const adLockPessimistic = 2
Const adOpenForwardOnly = 1
Set objRst = CreateObject("ADODB.Recordset")
objRst.Open "Helpdesk", "Provider=Microsoft.Jet.OLEDB.3.51; Data Source =
\\choa-fs3\share\is-security\data\organz.mdb", adOpenForwardOnly,
adLockPessimistic, adCmdTable
objRst("SMSordcen") = MyControls("OrdCen").Value
objRst("SMSordnoncen") = MyControls("OrdNonCen").Value
objRst("LawsonClass") = MyControls("LawsonClass").Text
objRst.Update
objRst.Close
On one workstation I have Visual Studio installed so I assume on this
workstation I have all the "providers" required for this code to work.
On another workstation when I try to run this code I get the following error
message:
"Provider cannot be found. It may not be properly installed."
Anyone know what specific "providers" I need to install in order for this
code to work on that workstation.
form I have code such the following that writes the information in the form
to a table in an MSAccess database:
Set MyControls = Item.GetInspector.ModifiedFormPages("User
Information").Controls
Const adCmdTable = 2
Const adLockPessimistic = 2
Const adOpenForwardOnly = 1
Set objRst = CreateObject("ADODB.Recordset")
objRst.Open "Helpdesk", "Provider=Microsoft.Jet.OLEDB.3.51; Data Source =
\\choa-fs3\share\is-security\data\organz.mdb", adOpenForwardOnly,
adLockPessimistic, adCmdTable
objRst("SMSordcen") = MyControls("OrdCen").Value
objRst("SMSordnoncen") = MyControls("OrdNonCen").Value
objRst("LawsonClass") = MyControls("LawsonClass").Text
objRst.Update
objRst.Close
On one workstation I have Visual Studio installed so I assume on this
workstation I have all the "providers" required for this code to work.
On another workstation when I try to run this code I get the following error
message:
"Provider cannot be found. It may not be properly installed."
Anyone know what specific "providers" I need to install in order for this
code to work on that workstation.