Help! Differences in sizes is terrifying!

[Guest]

Hi:

Last week I setup a wireless computer that was to access a table in a
networked database. Most of the tables in the database are linked and stored
in a sql server. Except for the table that the wireless user was accessing.
Well that table get on getting corrupted and I finally connected the two,
wireless=data corruption. So I decided to stop using that wireless to access
that table. Well it corrupted my database, so I created a new database and
imported all the tables(links), forms, reports etc. It works fine, except
for one HUGE PROBLEM!!!!!! The database that got corrupted was 333 megs the
new one with all the imported tables(links), forms, reports, queries etc is
only 5 megs?

This sounds very bad, I hope it is not. Any ideas?

Celia

 

[Nick Coe \(UK\)]

In kitty typed:

Hi:

Last week I setup a wireless computer that was to access a
table in a
networked database. Most of the tables in the database
are linked
and stored in a sql server. Except for the table that the
wireless
user was accessing. Well that table get on getting
corrupted and I
finally connected the two, wireless=data corruption. So I
decided to
stop using that wireless to access that table. Well it
corrupted my
database, so I created a new database and imported all the
tables(links), forms, reports etc. It works fine, except
for one
HUGE PROBLEM!!!!!! The database that got corrupted was
333 megs the
new one with all the imported tables(links), forms,
reports, queries
etc is only 5 megs?

This sounds very bad, I hope it is not. Any ideas?

Celia

Well, to start with, the new DB will have no waste space
i.e. you can only really compare it to a compacted version
of the old one.

If the old one hadn't been compacted for a while then it
would have had a lot of unreclaimed space in it. Plus
corruption like that can bloat a DB sometimes.

Bottom line is, if it works and all the data is there it
ain't broke

As well as wireless lans being a no no, so are wans.

PS - Do you have any tables in the DB or is it just a nice
untabled, links only Front End? If you do, put them in
another mdb and link to them.

 

[Guest]

Thanks Nick, that is very reassuring. Yes, I had a couple of tables, but now
they have been recreated in the sql server.

Again thanks you so much.

Celia