Bloat in new db

[David]

We are using Access 2003 with 2002/2003 format in a 3 year old db. We were
getting system errors that we could not fix with repair/compact so I created
a new blank db and imported all objects. All works fine now except for 1
problem of db bloat. The db is an Access front-end with SQL server backend
using ODBC attachments. The Access database size is normally 25,000 KB. I
have a re-attach function that merely recreates the connection string on all
tables which we have been using for years. Now, all of a sudden, when I run
this on my new db it bloats the db to 146,000 KB. If I run it a 2nd time it
bloats to 268,000 KB. This never happened on the old db. Can anyone help me
resolve this problem? Thanks.

David

 

[Guest]

What happens when you do a compact and repair?

Are you sure that it's linking and not importing?

Are you creating any relationships on these tables?

 

[David]

The Repair/Compact takes it back down to the 25,000 KB size. However, if I
do the "relink" function again it bloats back up to the 146,000 KB. I have
been running this same function for several years and this has never
happened before. All the function does is replace the .Connect string on
each linked table.

Yes, it is just "linking".

No relationships as SQL takes care of that.

Thanks.
David

 

[dbahooker]

use Access Data Projects and spit on anyone that tells you otherwise

-Aaron

 

[dbahooker]

i mean seriously here

MDB is shitty

especially for linked tables.

Access Data Projects are a dream environment.

 

[Tony Toews]

The Repair/Compact takes it back down to the 25,000 KB size. However, if I
do the "relink" function again it bloats back up to the 146,000 KB. I have
been running this same function for several years and this has never
happened before. All the function does is replace the .Connect string on
each linked table.

Yes, it is just "linking".

That bloat is exceedingly excessive. Are you up to date on your
patches? Could you post the relevant lines of code in the relinking
function?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm