These estrange incidents are becoming now more often.
I try to start a new operation and select append.
Select the master table.
Select genie to build (or just create).
when try to show the transaction table, is not there.
The table is in the system.
the table is working fine and forms and sets based on it, are working fine.
I have added a field to the table and saved it.
I have pack the db.
I have reattached all the tables.
I have duplicated the table and delete the original and duplicated back. (by the way, In operation I see the new duplicated table, NOT THE ORIGINAL).
Instead of copy the copy back to original, I try renaming the copy to the original name.
Even after creating an append operation based on the new name, I can not go back to that operation and change the transaction table.
None works.
In the past few instances when this happen, they were temporary tables used for import and I managed to delete and recreate.
So eventually I was able to finish.
This time is one of the main tables and now it does not want to show.
It seems that the name used of that table will not be recognized.
I have read a few threads and some point to table index corruption.
If this is the case, how can this index or corruption be fixed?
any utility to do this kind of fixing?
Am I running into some limits(I have about 40 tables and 10 sets)?
Computer has 4 gb of memory and is W7 ULTIMATE.
Any other suggestion?
I try to start a new operation and select append.
Select the master table.
Select genie to build (or just create).
when try to show the transaction table, is not there.
The table is in the system.
the table is working fine and forms and sets based on it, are working fine.
I have added a field to the table and saved it.
I have pack the db.
I have reattached all the tables.
I have duplicated the table and delete the original and duplicated back. (by the way, In operation I see the new duplicated table, NOT THE ORIGINAL).
Instead of copy the copy back to original, I try renaming the copy to the original name.
Even after creating an append operation based on the new name, I can not go back to that operation and change the transaction table.
None works.
In the past few instances when this happen, they were temporary tables used for import and I managed to delete and recreate.
So eventually I was able to finish.
This time is one of the main tables and now it does not want to show.
It seems that the name used of that table will not be recognized.
I have read a few threads and some point to table index corruption.
If this is the case, how can this index or corruption be fixed?
any utility to do this kind of fixing?
Am I running into some limits(I have about 40 tables and 10 sets)?
Computer has 4 gb of memory and is W7 ULTIMATE.
Any other suggestion?
Comment