>What do you mean "it doesn't work"? What error(s) do you get?
Provider=VFPOLEDB.1;Data Source=\\eukfs01\mis_deve\andersonanalysis\data\;Collating Sequence=MACHINE
• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
o Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) Get Online Help
Invalid path or file name.
Change to use credentials when connecting to datasource.
• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
o Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) Get Online Help
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Change to also impersonate user in Windows after connection.
• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
o Cannot impersonate user for data source 'DataSource1'. (rsErrorImpersonatingUser) Get Online Help
Specified method is not supported.
Move data to my hard drive, give permissions to everyone.
Provider=VFPOLEDB.1;Data Source=\\euk01314\outbox\andersonanalysis\data\;Collating Sequence=MACHINE
Works!