The database used by the application package is specially designed for that
application. The data integraty is maintained by that app. For example,
particaular data must be in certain range, some have parent-child
relationship that is identifiled by primary keys and foreign keys, and so
on. You should never directly go to the table and make changes there unless
you are the designer, or you know exactly how the database is constructed.
It is expected you run into error after getting into somewhere you are not
sopposed to and making some changes you should not do.
To correct the error, if the database is not used since the change you made,
you may be able to undo it by the same way as you did, if you can remember
what you have changed (if you deleted some records, then you cannot simply
just re-enter these records in many cases, because the auto-numbered ID
field will get different value that may or may not cause trouble, only the
DB designer knows). If you cannot undo it, the only hope is, you know,
BACKUP.
McCoolit said:
There is this executable application package whose source code is not
available, and which uses MS Access to store data. I tried to link one table
which consists of two fields only, code and its name. I was able to link the
table to a SQL table. I can view and edit the record directly at the linked
table. However, when I tried to add a record trough the application, it
raises an error code # 2147467259. Do you have any idea of a possible
solution to this error?
