Date View Web Part : error

[zephyrhex]

i was finally able to successfully implement the Data View web part to an MS Access database.

it works fine on the server on which WSS is installed. i can view the Access data in sharepoint -- no problem.

but when i try to view the page on another machine, i get:
An error occurred while processing the data for this request. Contact the server administrator for more information.

instead of the data.

i put the MS Access database on the WSS server in inetpub/

http://wwwroot/DB

and the connection string is c:\inetpub\

http://wwwroot\DB\db.mdb

i am wondering if the path is the problem. *but*, from what i understand, Data View web part will not work with a database hosted on a network share (i confirmed this by testing it). if i can't share the folder, how do i get the web part to work on other machines? and is this even the problem, or is it something else?

thanks

 

[zephyrhex]

just wanted to update this with more info...

it appears that if the database is on the same server as WSS, you can share the folder and other computers can see the data ... but i don't have it working completely yet.

my local computer can view the data only if i am viewing it on the server at the same time. if i try to refresh my local page, i get the error. i then refresh the page on the server. when i refresh again on my local machine, i can see the data again.

ideas on what is going on and how i fix it?