Bad File Name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 11 Sep 2007 23:21 GMT

I'm getting the Error #52, Bad File Name or Number.

FileCopy "C:\PROSERV\DB\Restore.mdb",
"C:\PROSERV\BU\Format(Date,""yyyymmdd"") & "".mdb"

The file defintely exisits. Could it be the format part thats not right.
Thanks
DS

Reply to this Message

Marshall Barton - 11 Sep 2007 23:54 GMT

>I'm getting the Error #52, Bad File Name or Number.
>
>FileCopy "C:\PROSERV\DB\Restore.mdb",
>"C:\PROSERV\BU\Format(Date,""yyyymmdd"") & "".mdb"

Hard to tell without knowing what file name you are looking
for.

Is this the same question as your next one?

Signature

Marsh
MVP [MS Access]

Reply to this Message

Ken Snell (MVP) - 12 Sep 2007 00:47 GMT

FileCopy "C:\PROSERV\DB\Restore.mdb",
"C:\PROSERV\BU\" & Format(Date,"yyyymmdd") & ".mdb"

Signature

Ken Snell
<MS ACCESS MVP>

> I'm getting the Error #52, Bad File Name or Number.
>
[quoted text clipped - 4 lines]
> Thanks
> DS

Reply to this Message

DS - 12 Sep 2007 12:43 GMT

> FileCopy "C:\PROSERV\DB\Restore.mdb",
> "C:\PROSERV\BU\" & Format(Date,"yyyymmdd") & ".mdb"

Thanks Ken.
I see the error of my ways... " &
DS

Reply to this Message