Win XP Access 2007 "Could not find Installable ISAM" error

J

JHB

Hi:

I have an Access 2000 app that I am trying to transfer to Access 2007,
using comptabality capabilities of Access 2007. Everything appears to
be working fine EXCEPT that when the program uses VBA to save a file
outside the Access environment I get an error "Could not find
Installable ISAM", and the file is NOT saved. The same processes work
just fine under Access 2000! I have searched for solutions, and none
that I have run into seem to fit he case I am dealing with.

Here is a sample of the code I use (in this case to backup the
database):


Function BUDB()
'Select the master and copy it for backup. Note- all processes must
cease before the file TASC_be.mdb can be copied to backup.

Dim OLDFILE As String
Dim BUFILE As String
Dim NOWSTRING As String
BUFOLDER = "C:\TASC\BACKUP\"
NOWSTRING = Format(Now(), "yyyy-mm-dd")
OLDFILE = "c:\TASC\DB\TASC_be.mdb"
BUFILE = BUFOLDER & NOWSTRING & " BACKUP TASC_be.mdb"
message1 = "Your Database has just been backed up. " & vbNewLine &
vbNewLine & "The backup File Name is: " & BUFILE & "." & vbNewLine &
vbNewLine & " It is strongly suggested that you copy that file to a
secure location (such as Dropbox). "
namemsg = "Backup Done"
On Error GoTo Failure
FileCopy OLDFILE, BUFILE
MsgBox message1, vbOKOnly, namemsg
GoTo Endit
Failure:
MsgBox "The attempt to backup your files failed. Please close the
applicaton and try again.", vbOKOnly, "Backup Failure"

Endit:
End Function


Does anyone have any suggestions for changes that will overcome the
issue I am dealing with?

Thanks

John Baker
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top