ISAM error

[Tim]

Hi everyone,

I posted my question couple days again, but no one answer
it. Could anyone help me out? I really need some help on
it.

Here is my problem:

I tried to use VBA to compact password protected
database. I ran the following code, but I got the error
message like this:Run-time error '3170': Couldn't find
installable ISAM.

Public Sub test2()
DBEngine.CompactDatabase "c:\TempTest\data.mdb", "c:\TempTe
st\data10.mdb", , , "tim"
End Sub

I tried to download the service pack2 for office 97, but
it didn't help.

Does anyone know how to fix it?

Thanks a lot.

Tim.

 

[TC]

This was posted in 1999 in response to a similar problem. I can not vouch
for it personally, so I'm telling you this on an "information only" basis!
(ie. try it at your own risk)

<QUOTE>
This was probably a re-install of office97 - correct? On re-installs, the
Excel and Text File ISAM's seem to get corrupted so that they don't
automatically re-install. The way to get around this is to re-install them
manually using regsvr32.exe - which comes standards with windows9* and NT.

Go to Start : Run and type:

regsvr32.exe C:\Windows\System\Mstext35.dll

then hit ok. Note there is a space between .exe and C:\Win... This
re-installs the Text ISAM. On NT machines I believe the path is
C:\Winnt\System32...

For the Excel ISAM it is C:\...\msexcl35.dll
Note there is no second e in msexcl35.dll.
</QUOTE>


HTH,
TC

 

[TC]

Are you sure that you are supplying the password properly in the
CompactDatabase statement?

DBEngine.CompactDatabase "c:\TempTest\data.mdb", "c:\TempTest\data10.mdb",

, , "tim"

I don't have Access here to check, but I thought from memory that it needed
to be:

... , ";PWD=tim"

or somesuch.

HTH,
TC

 

[Tim]

Hi TC,

Thanks for your response. I tried your code but I still
got the same error message.

I am working on the Access application not other
application why I have this kind of error. I tried on the
other machine but I got the same error. If I removed the
password, then I compacted the DB. I wouldn't get the
error. Why? I couldn't get it. Do you have anyway to
get around it?

Is there a way to remove the password from password
protected DB, then compact the db and the put the password
back by VBA?

Thanks a lot.

Tim.

 

[Tim]

Hi TC,

You are right. The code is working now.

Thank you very much.

Tim.

-----Original Message-----
Are you sure that you are supplying the password properly in the
CompactDatabase statement?

DBEngine.CompactDatabase "c:\TempTest\data.mdb", "c:\TempTe
st\data10.mdb",