Backing up an Access datatabase to span multiple disks

[maxflitom]

Hello Tek-Tips,

My app currently uses the JRO.JetEngine CompactDatabase method to backup my Access 2002 database. I have two concerns.

1. My first concern is that when by db gets too large to fit on the removable media, it will not allow the file to span multiple disks.

2. My second concern is that I continue to get Error # -2147467259, Database Opened exclusively by User (current machine name) when the app terminates. I close all my recordsets & connections. I get this error only after viewing reports created by the Data Environment/Report Designer. I cannot narrow down which report or in which sequence the error occurs. It occurs sometimes and other times it does not. I am running Windows NT 4.0 on a Pentium 133 (yes 133).

Should I use some other method of backing up my Access database?

Any suggestions will be greatly appreciated.

Tom (maxflitom)

 

[vb5prgrmr]

There are several ways in which you could backup your database. If you search the web you can find some zip code that will help you keep the size down and if necessary span disks. If you search this site you should find some posts by me that will link you to some of that compression code.

You can always come up with your own way of backing up the data (not the database just the data) and saving it to a single or multiple files. Then again if you go this route then you will also need to create the restore.

Now as for your second concern... one way to see which possible report is causing you your problems is to remove them one at a time starting with the last one added. A better method would be to include error handling throughout your project and if necessary add msgbox's/breaks where you think the suspect code may be.

Good Luck

 

[maxflitom]

Thanks vbSprgrmr,

I searched this site for Backup but not compression. Hopefully I will be able to find some code which I can incorporate in my app.

I have error handlers in place for the errors. When the app terminates, I call a backup routine which uses the CompactDatabase of JRO. In this routine, I have error handling set up. I close all my connection and recordset objects. I only get the error (message) occasionally and just cannot narrow it down. I will keep fooling around with it.

Tom (maxflitom)