Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Bloat in new db

Discussion in 'Information Technology' started by David, Jul 28, 2006.

Tags:
  1. David

    David
    Expand Collapse
    Guest

    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
     
  2. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    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?
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "David" wrote:

    > 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
    >
    >
    >
     
  3. David

    David
    Expand Collapse
    Guest

    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

    "Jerry Whittle" <JerryWhittle@discussions.microsoft.com> wrote in message
    news:62502E43-2D85-4BF5-AFA2-98A973EE19A6@microsoft.com...
    > 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?
    > --
    > Jerry Whittle
    > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    >
    >
    > "David" wrote:
    >
    >> 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
    >>
    >>
    >>
     
  4. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

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

    -Aaron


    David wrote:
    > 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
    >
    > "Jerry Whittle" <JerryWhittle@discussions.microsoft.com> wrote in message
    > news:62502E43-2D85-4BF5-AFA2-98A973EE19A6@microsoft.com...
    > > 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?
    > > --
    > > Jerry Whittle
    > > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    > >
    > >
    > > "David" wrote:
    > >
    > >> 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
    > >>
    > >>
    > >>
     
  5. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    i mean seriously here

    MDB is shitty

    especially for linked tables.

    Access Data Projects are a dream environment.




    David wrote:
    > 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
     
  6. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "David" <dlchase@lifetimeinc.com> wrote:

    >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
     

Share This Page