Sharepoint Designer and Database Connection

Pierre Delacroix — Tue, 08 Jul 2008 08:17:56 GMT

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

SharePoint Integration

Sharepoint Designer and Database Connection