Access 2002 db opened with access 2003

I asked before, maybe not clearly.

I have a 20Meg .mdb file (A2002) that I open with Access 2003, without any
error msg. However it only contains one small table with 15 small records.
This file is suppost to 1000s of records (sales for the past few months)

Just for the hell of it, I saved it as an Access 2000 file and the resulting
..mdb is only 190kb.

Where is the data going?

Thanks
David

"David" <david.i@comcast.net> skrev i melding
news:PqNNb.78322$8H.115261@attbi_s03...[color=blue]
> I asked before, maybe not clearly.
>
> I have a 20Meg .mdb file (A2002) that I open with Access 2003, without any
> error msg. However it only contains one small table with 15 small records.
> This file is suppost to 1000s of records (sales for the past few months)
>
> Just for the hell of it, I saved it as an Access 2000 file and the[/color]
resulting[color=blue]
> .mdb is only 190kb.
>
> Where is the data going?
>
> Thanks
> David
>[/color]
It was probably compressed when saving in another version! Try to compress
the original DB, and see what happens.

Sigurd

On Fri, 16 Jan 2004 15:27:25 +0100 in comp.databases.ms-access,
"Sigurd Bruteig" <s-brutexxx@online.no> wrote:
[color=blue]
>
>"David" <david.i@comcast.net> skrev i melding
>news:PqNNb.78322$8H.115261@attbi_s03...[color=green]
>> I asked before, maybe not clearly.
>>
>> I have a 20Meg .mdb file (A2002) that I open with Access 2003, without any
>> error msg. However it only contains one small table with 15 small records.
>> This file is suppost to 1000s of records (sales for the past few months)
>>
>> Just for the hell of it, I saved it as an Access 2000 file and the[/color]
>resulting[color=green]
>> .mdb is only 190kb.
>>
>> Where is the data going?
>>
>> Thanks
>> David
>>[/color]
>It was probably compressed when saving in another version! Try to compress
>the original DB, and see what happens.[/color]

Nah, it's wiped out all the sales from 2001 to today innit? <g>

--
A)bort, R)etry, I)nfluence with large hammer.