NOT A TABLE error

[phil22046]

In my development system, VFP8 I try to open a standalone table named strings and get a "not a table error." However the compiled app exe does not have a problem reading the table. I tried VFP 6,7,8 and 9 and have this same problem. I have been developing on this system for 2 months and this problem just started today for no apparent reason.

 

[Stella740pl]

You table's header is probably corrupted. Try to restore it from a backup or, if you recently changed the structure, from FoxPro backup; or repair it with one of table repair utilities (search this forum and forum184 for old threads on the topic).

As for the compiled app that can read the table - are you sure it opens the table at the same location that you try to open manually? You can use debugger to check, what's going on in the application.

You mentioned named strings - what do you mean and what exactly are you doing to open that table?

 

[phil22046]

Well the exe was located in a different directory and reading its own copy of that table. I have verified that the exe can read this copy of this table and my development system can't

 

[Stella740pl]

Well, it doesn't matter where .exe is located; the thing is, if that is the same .dbf file that you are opening and .exe is opening - you say it is?

And what did you mean about named strings?

IF it is the same table, how do you open it in the app and manually? Can you post the code?

While you are in the running exe and the table is open, can you suspend the app, select the table and COPY TO C:\Tmp\MyNewFile, then later try to open MyNewFile manually?
Does it work?

And finally, is it only one table that throws an error or you have more of them?

 

[phil22046]

I now believe that this is a cryptor problem. The reason the exe works is that the cryptor library is working correctly in the executable and for some reason has decided not to work in the development environment

 

[Stella740pl]

Oh, so you are using some encryption? Do you encrypt the whole table or some fields from it? Does it affect the header?

I never use encryption, so can't comment on whether it could be the possible reason.

But you said you never encountered the problem in the previous 2 months? Why now?