Copying Database File in code 
Author Message
 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?



Tue, 26 Oct 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Copying BE database via code

2. code to copy database

3. Save a copy of an entire access database with code

4. Code to Copy Records to a New Database

5. Find a copy a file with File.Copy method

6. Copy-File Code: I dont know

7. Copying files in Access Code

8. File Copy with code?

9. VB Code from COBOL Copy Files

10. File copy using code VB5

11. Copy opendned file using code

12. * URGENT! File copy source code

 

 
Powered by phpBB® Forum Software