G
Guest
We are having a Access Database (v 2003) which contains number, text and
memo field types. There is a record in the database that contains the string
"#Error" (without the quotes) for a memo field. This gives a problem when you
use this data in a DTS package for datatransformation. Opening the tabel and
selecting the "#Error" record results in the following error message:
The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time.
Inserting the string "#Error" in a memo reproduces the error. We have't
found a way to remove the record containing the "#Error". The record
containing the "#Error" string is inserted in the Access database via a C#
program.
Does anyone know if there is a way to remove the records containing "#Error"?
Is the usage of the #-sign in Access allowed in columns memo field?
Regards.
memo field types. There is a record in the database that contains the string
"#Error" (without the quotes) for a memo field. This gives a problem when you
use this data in a DTS package for datatransformation. Opening the tabel and
selecting the "#Error" record results in the following error message:
The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time.
Inserting the string "#Error" in a memo reproduces the error. We have't
found a way to remove the record containing the "#Error". The record
containing the "#Error" string is inserted in the Access database via a C#
program.
Does anyone know if there is a way to remove the records containing "#Error"?
Is the usage of the #-sign in Access allowed in columns memo field?
Regards.