Visual Basic 6.0 and a .mdb(error -2147467259 ) 1

[alanls1]

I am running a vb app. that calls about 8 or 10 active x programs that collect data. Thay all go to a single table to get a value/order number. Periodically(once a month) the .mdb will get corrupted. Eg. -2147467259 Unrecognized database format 'D:\hdturbo1\wip.mdb'. I can repair the .mdb manually and it is up and running again. Is there anyway to atumatically repair this error within my vb code? Any tips will be greatly appreciated. Thanks in advance.....

 

[Swi]

It would be good practice to compact and repair frequently as Access does not do a good job of cleaning up after itself. Here is a link:

http://www.freevbcode.com/ShowCode.Asp?ID=2879

I guess what you could do is test for the error and if it occurs run the above code.

Swi

 

[alanls1]

Thanks . This is exactly what I was looking for.. Many thank..... Alan.....

 

[Swi]

Your welcome. Glad to have helped.

Swi