beciakk
asked on
Copy database
How to create new access database, and put in it records from Data Control recordset (backup of database). Shall you give my full procedure (with comments).
Since you want to backup you must be having a data control for the existing databse, make this into a control array. ie. if the name of the datacontrol is DataControl1,make the index propertity as 0 and use the following code
Load DataControl1(1)
and set the required properties like the connection,databse etc.
Hope this helps
Load DataControl1(1)
and set the required properties like the connection,databse etc.
Hope this helps
ASKER
kamall:
You forget, that the database file is opened by Data Control and I can't close it and open (maybe you can help :-).
susmita:
So good, so far, but I don't know how to do it (Help me)
Thank you
You forget, that the database file is opened by Data Control and I can't close it and open (maybe you can help :-).
susmita:
So good, so far, but I don't know how to do it (Help me)
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FileCopy SourceFile, DestinationFile
Both SourceFile and DestinationFile are the full path/filename of the source and destination files.
Make sure that the database is closed before copying it.
Regards