[AccessD] error & structure: Please Help!!

Hello Scott,

this is the error table that i placed in the Backend

ErrorCode       ErrorDescription                           ErrorRecid 
ErrorTable
-1206              Can't find field Description                樂 
tblProjectGegevens
-1053              Can't find field Description 
tblProjectGegevens


i don't know when this error occurs.
In the table  self then one record is corrupt and all kind of weird signs
are in the fields, also in the grey square before the tablefields are weird
signs. Sometimes after deleting this record and other linked records in
linked tables, the database works fine. Sometimes then things are really
going wrong and all data has to be imported into a backup database and table
that was ok before the error. But this costs very much time. The database in
this presents worked for about 9 months without any error. After importing,
it worked again for three months, then again three months.

The strange thing is that i have no knowledge that i am trying to access a
field description, because there is no field description.


Pedro Janssen







----- Original Message ----- 
From: "Scott Marcus" <marcus at tsstech.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, November 23, 2005 6:38 PM
Subject: Re: [AccessD] error & structure: Please Help!!


> Pedro,
>
> What is the error?
>
> Scott Marcus
> IT Programmer
> TSS Technologies Inc.
> www.tss.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
> Sent: Wednesday, November 23, 2005 11:46 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] error & structure: Please Help!!
>
> Hi,
>
> is there really no one who can help me with this?
>
>
> Last week i posted an error message, but became no answer that gave me
> an
> explanation for the error.
> Is there someone who could look at the databasestructure ( i will send
> the
> stripped database ofline) and see why this error can appear, and give me
>
> some tips to prevent the error and for improvement of the structure.
>
>
> Pedro Janssen
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>