Connecting Tech Pros Worldwide Help | Site Map

Access 2002 db opened with access 2003

  #1  
Old November 12th, 2005, 07:10 PM
David
Guest
 
Posts: n/a
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


  #2  
Old November 12th, 2005, 07:10 PM
Sigurd Bruteig
Guest
 
Posts: n/a

re: Access 2002 db opened with access 2003



"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


  #3  
Old November 12th, 2005, 07:11 PM
Trevor Best
Guest
 
Posts: n/a

re: Access 2002 db opened with access 2003


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.
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2002 vs. 2003 Neil answers 52 February 16th, 2006 10:35 PM
Create database in Access 2003 gets Access 2000 formatted DB Susan Bricker answers 3 November 13th, 2005 09:44 AM
upgrade to Access 2002 or 2003? Jeff Keller answers 15 November 12th, 2005 04:15 PM
decompile in Access 2002? deko answers 28 November 12th, 2005 03:22 PM