Hi guys.
I'm trying to create a backup copy of my database in vb. So user can click on a button to create the backup copy instead of going into tools and utilities.
I'm trying to do it by compaciting the database.
< DBEngine.CompactDatabase source, destination >
Where source is path to my database, and destination is path to the destination of the backup file.
So my problem is, I get message "You are attempting to open a database that is already opened exclusively by user 'Admin' on machine.... Try again when the database is available."
Is there a way in vb to close current db perform the operation as stated above and open the current db?
Any comment or advice will be greately appreciated.
Thank you in advance.
I'm trying to create a backup copy of my database in vb. So user can click on a button to create the backup copy instead of going into tools and utilities.
I'm trying to do it by compaciting the database.
< DBEngine.CompactDatabase source, destination >
Where source is path to my database, and destination is path to the destination of the backup file.
So my problem is, I get message "You are attempting to open a database that is already opened exclusively by user 'Admin' on machine.... Try again when the database is available."
Is there a way in vb to close current db perform the operation as stated above and open the current db?
Any comment or advice will be greately appreciated.
Thank you in advance.