InfoPath Dev

This is my first post of the forum.  I've already used the site to help me with my current form development, especially the "How to" articles, so many thanks for those.

I have designed an InfoPath form which works both online and offline.  When online a laptop user queries the primary data connection with combo boxes which are populated from secondary data connections.  The form is is now full of data from the query.  The user saves the form as an .xml document.  They are now at a client site with no connection to the central Access database, so open the xxx.xml document and can now complete the form offline and save it.  Next time they're in the office the open the form again press submit and it updates the Access database. 

This all works fine except that when opening the form offline the user receives the message "Please enter MS Jet OLE DB Initialisation Information".  No surprise I guess as the database isn't available.  The user cancels the message and the form works fine, but how can I supress this message?  Is it possible to check the online status and ask the form not to attempt to connect to the primary and secondary data sources as the data is now held in the xml form?

Thanks.

HI and welcome to the forum.

Data Connections are verified on form open, even if they are not being queried so i think it is difficult to remove this other than coding it completly which would add more complexity and hassle to the form.

Have you thought about putting the DB in a network folder, probably already is, but then set it up as a off-line folder?  This way the laptop will still see it even though it is off-line and you will not have the error.

This would also enable you to not have to start the form before they leave the office.  They would take the latest copy with them and could access it while off-line.

You still have to manage the submit and the sync but if you want to email me, we could discuss what I have seen before.

Clay, many thanks for your reply.  I shall definitely try your suggestion of putting the mdb into on offline folder when I'm with the client later this week.