Liz,
That seems like the best solution. I'm working on that now but keep getting disturbed by people in the plant needing something. Job security right? LOL
Thank You!
Doyce
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Can you export to a local h: drive and then rename it and copy the renamed version over to the share?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of winberry.doyce@...
Sent: Wednesday, October 30, 2013 6:14 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: RE: [MS_AccessPros] Export Spec and file extension
Duane,
I thought about doing just that, However if I do, I'm going to have to save it local first then rename and then copy it to the network share. Corporate IT has some kind of new procedure where within seconds after a file has been uploaded to a share, it is swept off to the "cloud". It's not there long enough to rename. I guess I'll search for some code examples for Name and how to move a file from one location to another.
Thanks for your help!
Doyce
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Doyce,
You may need to use the Name statement to rename the file after it is exported.
From Help:
Name oldpathname As newpathname
Duane Hookom MVP
MS Access
________________________________
MS_Access_Professionals@yahoogroups.com
> From: winberry.doyce@...
> Date: Wed, 30 Oct 2013 05:54:15 -0700
> Subject: [MS_AccessPros] Export Spec and file extension
>
>
>
>
> Hello friends,
>
>
>
> Need some help today. I have a procedure where I export a table to a
> CSV file with an export spec. My corporate IT who gets the file changed
> the procedure on their end and they want the file extension changed to
> RSH instead of CSV. Now the procedure won't run. It gives me an error
> that it can't update because the database is read only. Well I change
> the file extension back to CSV and it runs fine. How can I change my
> export spec to allow a file extension of RSH?
>
>
>
> Doyce
>
>
>
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar