Hi,
First of my apologise for the topic, i know that this is an infoapth forum and not a sharepoint, but i tried posting in the microsoft forum and i didnt got any answer.
Well I am in big trouble ...my deadline project is approaching and I didn't do any progress concerning my project..
This is my project
Some data's are submitted to a Sharepoint list by a InfoPath form.
So once the data is in the Sharepoint list a workflow is launched
for example:
An InfoPath form submits this data:
First name last name phone adresse city company job title phone email
Well my workflow(designed with Sharepoint Desisgner) have to check if the data exist in 3 tables(Access).
Well for the
moment, I am looking on how to build a custom activity for Sharepoint
designer but I didn’t found anything on how to connect and query the
database.
Due of the size of the database(access 400MB) i dont want to link or move to a Sharepoint list and tue of the complexity and number of check i prefered to realise my workflow using sharepoint designer and not visual studio
Any advice is precisous for me.
Thank you in advance
Pierre
P.S I'm using MOSS 2007, SPD, Infopath 2007, Access 2007