connection to Access DataBase

[mark]

am publishing an infopath form which is connected to a DataBase to a
sharepoint,everything is ok and i can view the form when loaded in the local
computer.But the problem am facing is in the other computer in the network it
is giving me the following error:

InfoPath cannot create a new, blank form.
InfoPath cannot open the form. To fix this problem, contact your system
administrator.
Form template:
http://projectserver/sites/pmo/KSA/TimeSheet1/Forms/template.xsn
The query cannot be run for the following DataObject: Employees1
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
InfoPath has encountered an error. The operation failed.

 

[Clay Fox]

One thing to be careful of is how you connect to the Access database.
you need to use the path \\server\share\db.mdb so that all users would be
able to navigate to it.
Obviously they need permissions.

If you use a mapped drive then they might not have the same setup on all
computers.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[mark]

Dear Clay,
the isuue am facing is that the databace is Access2007(.accdb) not mdb,and
am not able to find it when i search for databases!!!it is in a share folder.

 

[Clay Fox]

Ok. Hmmm.

I have not used the new Access file extension. You could try saving it as an
MDB and see if that makes a difference.

I would assume if you can setup a data source for it it should work. But ?
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[mark]

thanks mark.
it seems that am facing a problem on configuring the datasource!!!
look am using a computer in my network as a server and am puting the form
template and the badtabase in a shared folder in this computer.so what is my
next step??
shall i go to every computer and configure the connection or what??
can u give me the details in the configuration??
thanks for your response
Regards

 

[Clay Fox]

You should not have to configure each computer. Once a data connection is
established in the template that will be the same one that is used by
everyone without any additional configuration, except that they must be able
to access the dat in the same way and path.

Have you tried accessing the database directly from these other computers?

I would think their could be an issue using the new file format for access,
at least worth checking by doing a save as.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com