Please Enter MS JET OLE DB Initialization Information??

[Weisen]

Hi Guys,

I developed an InfoPath form that directly connects to Access database and
allow user multiple submit as email message. I put InfoPath form in a public
folder, split Access database into front side and backside. All tables are in
a data folder, backside. Others such as forms, queries are in admin folder,
front side. the InfoPath is linked on intranet website. The problem I met is
that someone outside of our Geomatics group cannot open it. when they click
the link and a message box is popped up as below:

Title: Please Enter MS JET OLE DB Initialization Information

Data Source: \\...\data\Request09.mdb
User Name: Admin
Password:
Provider String:
Open Mode: DB-MODE-READWRITE

Button “OK†Button “Cancelâ€

Any help is much appreciated.

Thanks,

Weisen

 

[Franck Dauché]

Hi,

Is it too late for you to wrap a Web Service around your Access DB? It was
designed to handle situations such as yours.

Regards,

Franck Dauché

 

[Weisen]

Hi Franck,

Thanks for your reply.

Your meaning is that I can get ride of the current problem using Web service
connection, isn't it?

I guess that data folder for database tables is restricted to read only
access.

Thanks again for your reply.

Weisen

 

[Franck Dauché]

Well, as a general rule, it is better because no DB path or field names are
embedded in your form. This gives you the best flexibility. It is way
easier to managed security; especially when dealing with Internet/Intranet
issues...

Now, to come back to your problem, did you check that the MS Access driver
is installed on the computer where your DB Front end is? Is Access installed
there?

Franck Dauché

 

[Weisen]

Weisen thanks Franck.

Your reply is helpful. It is too late for me now. I put lots of code in it.

Regards,

Weisen

 

[Adam Harding]

Weisen

This can be overcome without a web service

In the links to your datasource instead of linking directly to the database
as a main or secondary connection follow these instructions to embed the
password in the form so that external people can access the form.

Publish your workgroup security file to a public area so the form can access
it.

Now modify your data connection, instead of browsing to the database click
new source, select 'Other/advanced' then click next. Select 'Microsoft Jet
4.0' line and click next

Browse to your database, and input the account and password to access the
database and give the account update and append rights.

Then go to the fourth tab called 'All' and select the line 'Jet OLE system
Database' click 'Edit Value' and type in the path to your workgroup security
file, do not use mapped drives but compeuter names.

Once this is done go back to the second tab and click 'Test Connection' if
the test comes back as succeeded click OK either map it to a table or map it
to a then it adds a datasource to your pc. Open this up and it asks for the
database account and password which you can save as part of the form so that
it is invisible to users.

I have done this successfully a number of times and although it is less
secure than a web service it still functions well.

I have tried this with people outside of our domain who have access to our
intranet and it works a treat.

cheers Adam