
Copying Database File in code
I am writing a VB program that works on an Access Database. I want to
include an option to 'SaveAs' which would
close the open Recordsets
close the open Database
Then
FileCopy DatabaseName, NewDatabaseName
I am getting an error #70 "permission denied" here
I can't find Any open Recordsets from the Database and the Database seems
to close OK. Is there something else that would lock up a database file so
it couldn't be copied?
The NewDatabaseName is a unique file name with a valid path.
On the other hand is there an easier way to copy all of the data in a
database to a new database? An Action Query?