More info:
The My Documents folder is shared with Everyone and the Permissions give total control
I am converting from a macro to save to vb and previously u had no problem with the macro.
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> I am exporting a query using vb. I went to the folder that I'd like it exported to and cut and pasted the address. The Access program that I'm using is in C:\Documents and Settings\AGENT\My Documents\Backup\Connie\Access\DatabaseData.
>
> The description of the code: "...cannot open or write to the file 'C:\Documents And Settings\AGENT\My Documents\Backup\Susie\Listed Statistics--Copy last one to begin'. It is opened exclusively by another user, or you need permission to view or write its data."
>
> My code is:
> DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, _
> "qListingsRawData", _
> "C:\Documents and Settings\AGENT\My Documents\Backup\Susie\Listed Statistics--Copy last one to begin"
>
> Thanks!
> Connie
>
Tidak ada komentar:
Posting Komentar