Error in Copying access DB from one folder to another using excel VBA

Question

Hey I am not able to copy an access DB from one folder to another using excel vba . I am not getting any error ... But still no file is getting copied...Instead i am getting something called '873ED000' with 0 bytes. What could be the reason?. Please help me out. Also is this the best method to copy ?? My tool needs to be faster and the Database is huge.

FileCopy "E:\Test Folder\Feature_Planning_Data.accdb", "" & ThisWorkbook.Path &       "Feature_Planning_Data.accdb

If the file is huge, are you sure you have Compacted & Repaired recently? — Fionnuala
– Fionnuala, Commented Jan 9, 2013 at 12:09

Siddharth Rout · Accepted Answer · 2013-01-09 08:16:29Z

1

Try this (I am assuming that the Excel File from where you are running the code is saved)

FileCopy "E:\Test Folder\Feature_Planning_Data.accdb", _
ThisWorkbook.Path & "\" & "Feature_Planning_Data.accdb"

answered Jan 9, 2013 at 8:16

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in Copying access DB from one folder to another using excel VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related