Prev: How do I use a table to validate data being entered into another
Next: the database doesn't admit Activex control
From: admin etc on 24 Mar 2010 01:37
Hi,

I have an access database which is used as a contact database for customers,
in the main data table we enter in the last contact information. it was
working fine until last week when all of a sudden over half the data
dissappeared and it set itself as a 50 character length and deleted anything
after this.

Any ideas as to how I can get the information back?
From: John W. Vinson on 24 Mar 2010 01:44
On Tue, 23 Mar 2010 22:37:01 -0700, admin etc
<adminetc(a)discussions.microsoft.com> wrote:

>Hi,
>
>I have an access database which is used as a contact database for customers,
>in the main data table we enter in the last contact information. it was
>working fine until last week when all of a sudden over half the data
>dissappeared and it set itself as a 50 character length and deleted anything
>after this.
>
>Any ideas as to how I can get the information back?

Get out your backup :-{(

Someone must have changed the datatype from Memo to Text. Doublecheck the
table structure definition - if it's still memo, please post some more info.
--

John W. Vinson [MVP]
From: admin etc on 24 Mar 2010 04:56
The datatype is still memo but the format field had the @ symbol and when I
remove that then I could add more data. Only problem is when I open the
backup they are the same with the missing data although the problem only
happened last week?????

"John W. Vinson" wrote:

> On Tue, 23 Mar 2010 22:37:01 -0700, admin etc
> <adminetc(a)discussions.microsoft.com> wrote:
>
> >Hi,
> >
> >I have an access database which is used as a contact database for customers,
> >in the main data table we enter in the last contact information. it was
> >working fine until last week when all of a sudden over half the data
> >dissappeared and it set itself as a 50 character length and deleted anything
> >after this.
> >
> >Any ideas as to how I can get the information back?
>
> Get out your backup :-{(
>
> Someone must have changed the datatype from Memo to Text. Doublecheck the
> table structure definition - if it's still memo, please post some more info.
> --
>
> John W. Vinson [MVP]
> .
>
From: John W. Vinson on 24 Mar 2010 11:43
On Wed, 24 Mar 2010 01:56:01 -0700, admin etc
<adminetc(a)discussions.microsoft.com> wrote:

>The datatype is still memo but the format field had the @ symbol and when I
>remove that then I could add more data. Only problem is when I open the
>backup they are the same with the missing data although the problem only
>happened last week?????

The *display* (not the actual content) of Memo fields will be trunctated if
you apply any Format. Solution: remove the Format. Your content should all
still be there.
--

John W. Vinson [MVP]
From: Fred on 24 Mar 2010 11:55
One "sidebar" note.

Make sure you don't still have the data there, but "hidden" from the current
view (e.g. box) by line breaks.

do Shfit+F2

 |  Next  |  Last
Pages: 1 2
Prev: How do I use a table to validate data being entered into another
Next: the database doesn't admit Activex control