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

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