Error 3617 - Unsupported ISAM 1

[briglass]

My visual basic program, when ran on someone else's machine, breaks for him at this line:

db.Execute "delete * from Banana"

The error message he gets is "3617 - Deleting data in a linked table is not supported by this ISAM."

I know he has Access 97 running on his computer, and I am pretty sure the program successfully accesses db previous to this error.

Does anyone know what error 3617 entails?

Perhaps he has Paradox or dbase running parrallel to Access and he has other than Access registered for handling SQL commands coming from Visual Basic?

Any help would be greatly appreciated... this is not a school project.

Thank you very much,
Brian

 

[danvlas]

There are cases in which records cannot be deleted in linked tables:

-linked Excel spreadsheets (however, edits and additions are allowed)
-text files: only additions allowed

Probably many others have restrictions.


You can use the Connect property of the tables to check whether they are native, or linked (and if linked, what type of source)

Regards,

Dan

 

[briglass]

eureka!

he sent me his data and the table is in fact linked.

it is linked as a text file, so only additions can be made, just as you have said.

is it possible for him to unlink the table to save his data?

or is it the data ruined?

thanks,
brian

 

[danvlas]

What do you mean? The text file can be modified by an external program and the changes will be seen in Access. I don't see why unlinking the file. Or am I missing something here?

Dan