Yet another infopath/access question

P

Paulo

Hello,

I have read some posts about this issue but it seems that everytime it
doesn't fit my needs....
I have a simple form that uses a local access access (no SQL) db to gather
an autonumber (no webservice). This, I have managed to do :). Now, when the
user saves the form, I want to insert a row in the access DB so that when he
opens the template again, it will have the next number. This is where things
start to get complicated. I do not have the possiblity to submit to a access
db in the GUI so I am pretty sure I need to do that programatically.

Is there a soul that can point me to the right functions to use? or better
some nice articles or even better for some code :9

Thanks
Paulo
 
P

Paulo

Hello,

"Not bound", how can I bound it?
I kind of thought I needed ADO code... do you know where I can find examples?

Thanks you
Paulo
 
S

S.Y.M. Wong-A-Ton

When you create a new form and choose "New from data connection" and then
select a db connection, your form will be bound to a db. I don't think you
can bind a form to a database after it has already been created.

No special ADO code is needed for InfoPath. You should be able search on
Google to find ADO code that writes to a database. This article
(http://support.microsoft.com/?kbid=185125) uses a stored procedure, but you
can modify it to use SQL statements.

Note: Since you'll be calling an ActiveX object when you use ADO, you might
get security warnings in InfoPath whenever the code is invoked. You wouldn't
have this issue if you used a web service to write to the db.
 
Top