Access 2003 Relinking tables bloat database

[shawn clarke]

I have a database application that had been converted to Access 2003 from Access 97 (both the frontend and backend have been converted). I have found that the database will bloat whenever the tables are relinked (either done using the Linked Table Manager or through code). This does not happen in Access 97. I have tried with the backend database being on the same local harddrvie as the frontend and with a remote data database and it does not change the outcome.

A database that initially was 400K ends up bloating to 15M after relinking the tables. There are approximately 30 tables that are being linked. Compacting and Repairing the database does put things back to the proper size.

Is there any way for me to prevent this from happening? Any suggestions why this happens in 2003 and not 97?

 

[Albert D.Kallal]

Gee, that is strange.

Does you re-link code delete the link..and then re-create it?

I just tested a medium size application (11 megs)...it has about 55-60
tables. I used the re-link code, and I found no bloat, or increase in the
file size at all.

So, I would first turn off track autoname correct.

(tools->Genera tab-> Name Auto Correct (un check this option).

Do a compact and repair.

 

[shawn clarke]

Yes, I had tried this previously but with no effect on my results (e.g.
still get the bloat). Also tried un-checking "Enable Error Checking"
although this setting should have nothing to do with linked tables at all...
but you never know.

I have tried this on different machines and have found the same result. Is
it possible that you have "Compact on Close" turned on? I have this
un-checked.

 

[Albert D.Kallal]

Yes, I had tried this previously but with no effect on my results (e.g.
still get the bloat). Also tried un-checking "Enable Error Checking"
although this setting should have nothing to do with linked tables at
all... but you never know.

Does your application compile to a mde ok?

I have tried this on different machines and have found the same result. Is
it possible that you have "Compact on Close" turned on? I have this
un-checked.

No...I don't have compact on close set....

I tested both code re-link, and also tested using the linked table manager.
55 tables, and virtually NO bloat or increase in size occurred. (and, I
would usually expect "some"...and that would be ok anyway).

I would consider installing the office updates...(sp2).

(you can let the office update do this for you....).