Unable to Export using UNC Path 2

[Eprice]

Hi,
I am trying to export a tab delimited text file to the network using the UNC path but get "Cant update, database or object is read only". I can manually export to that location but using the UNC get an error. If I take out the UNC path and put a regular "N\HOPA\Billing" path it works also. Any ideas why?

DoCmd.TransferText acExportDelim, "WaivedAudits", "tblAcctWaivedAudits", "\\fs3nt\qa\billing\io\Waived Audits " & strDate & ".txt"""

Thanks, Lisa

 

[lameid]

I never remember when you need double quotes for long names or not for sure but I know it won't work if you only use them to end your filename and path...

DoCmd.TransferText acExportDelim, "WaivedAudits", "tblAcctWaivedAudits", [red]"[/red]\\fs3nt\qa\billing\io\Waived Audits " & strDate & ".txt[red]"""[/red]

 

[PHV]

What about this ?
DoCmd.TransferText acExportDelim, "WaivedAudits", "tblAcctWaivedAudits", "\\fs3nt\qa\billing\io\Waived Audits " & strDate & ".txt"

BTW, what is the value of strDate ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[randy700]

You have spaces in your path name - both sides of Audits.
Should they be there?


Randy

 

[Eprice]

strDate is just todays date formatted. I can get rid of that part. I changed the code to get rid of the date part to

DoCmd.TransferText acExportDelim, "WaivedAudits", "tblAcctWaivedAudits", "\\fs3nt\qa\billing\io\Waived Audits.txt"

Now I get a different error. Run-time error 3011. The Microsoft Jet database engine could not fine the object "Waived Audits#text. Make sure the object exists and that you spell its name and the path name correctly.
Lisa

 

[Eprice]

I got it with this.
DoCmd.TransferText acExportDelim, "WaivedAudits", "tbl AcctWaivedAudits", "\\fs3nt\qa\billing\io\WaivedAudits" & strDate & ".txt"

Thanks
Lisa