Search results

  1. E

    windows

    Hi, when I open a particular database I have to goto Window>Unhide! How can I do this in VBA?
  2. E

    Bloat

    Dave, a) I never run out of space in the dbs b) No problem compacting c) SQL backend - don't have one ofthose! I have split the 2 tables of 90,000 records into 2 separate databases. One as 121 fields and the other 137 fields. After deleting and appending fresh data the one with 130 fields...
  3. E

    Bloat

    Deleting records from another database that is linked to this 500mb database and appends new data to it which then doubles the size of the linked database. i.e. Database as 2 tables with 90,000 records both with 137 fields but can't see why it bloats so much!
  4. E

    Bloat

    New records have no reference to previous months as they are from a different financial month.
  5. E

    Bloat

    Database as 2 tables with 85,000 records and with 137 fields each that start at 360mb but doubles in size when a delete and append new records to them from another linked database.
  6. E

    Bloat

    do make table queries reduce bloat as they are append queires? I do compact after each run but was concerned of the bloat! Database doubles in size!
  7. E

    Bloat

    I am running 5 append queries that increase the size of a linked database from 0.5GB'S to 1GB! How can I reduce this bloat as I need to run these queries regularly and therefore have to compact the linked database each time.
  8. E

    Table Description

    Thanks Ken I will give this a go if I ever get time!
  9. E

    Table Description

    yes but if it exists I want to over write it but cannot code it!
  10. E

    Table Description

    I use the following code to update the table description. TDef.Properties.Append .CreateProperty("Description", dbText, Right(.Connect, Len(.Connect) - 1) & "; TABLE=" & .SourceTableName) but if it already exists It will not overwrite! How can I delete it first?
Back
Top Bottom