469,621 Members | 1,678 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

Open an Access Database from an InfoPath form

I have an InfoPath form that needs to update an Access database. I'm
using VB, in Visual Studio. So far i can't even open it: the
database is on my hard drive, and no password is set. The following
is the code in my onLoad event on the InfoPath form. (I've tried it w/
out the User ID and password and get the same error)
Dim strConnection As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
& "C:\My_Data\New Jersey Fees.mdb"
& "User ID=Admin" _
& "Password="
Dim cn As OleDbConnection = New
OleDbConnection(strConnection)
cn.Open()
Error:
System.Security.SecurityException
Request failed.
at
New_Jersey_Request_and_Replies.New_Jersey_Request_ and_Replies.OnLoad(DocRet*
urnEvent
e)
at
Microsoft.Office.Interop.InfoPath.SemiTrust._XDocu mentEventSink2_SinkHelper*.OnLoad(DocReturnEvent
pEvent)
do i have to digitally sign the form?

any ideas?

thanks
Jun 27 '08 #1
0 1001

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Eric van der Niet | last post: by
3 posts views Thread by Jeff Richardson | last post: by
reply views Thread by =?Utf-8?B?Q2hhcmxlcyBTaW1wc29u?= | last post: by
7 posts views Thread by bhavin30 | last post: by
23 posts views Thread by andyoye | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.