Data base size discrepancy

[Susan L]

I have two identical data bases; the same two tables, the same 28 fields per
record, the same number (1675875) of records, the same queries and all the
data is numerical (double). However, one data base is 530MB and the other is
1808MB! The second one takes much longer to load as well. I can find no
reason for this. Can anyone suggest things I might take a look at?

 

[Dorian]

see other response
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Tom Hutchins]

I thought the saying was, "Give a man a fish and he will eat for a day. Teach
a man to fish and he will sit in a boat all day drinking beer."

Hutch

 

[Paul Shapiro]

I have two identical data bases; the same two tables, the same 28 fields
per
record, the same number (1675875) of records, the same queries and all the
data is numerical (double). However, one data base is 530MB and the other
is
1808MB! The second one takes much longer to load as well. I can find no
reason for this. Can anyone suggest things I might take a look at?

Try the Compact and Repair menu item. That's a poor name, because what it
really does is reorganize the database and discard the trash that's been
left in the file. If that doesn't help, create a new blank db and import
everything from the old one.