Re: Last Modified Date

I wonder if the forms, modules and reports potentially have redundant code
that has been deleted but is still there invisibly. This presumably doesn't
apply to queries or tables. Not sure what compacting does, but it obviously
removes something.
I believe when you delete files from a folder you just put a Hex FF in front
of the file name, and wonder if something similar is done with VB
statements.
On second thoughts when you compact a BE database (Tables only), it often
gets smaller, but there you must be doing something with deleted records.
Wish I'd never started this topic now

BTW I use the Compact on Close option, probably should't but have had no
problems. Is this an Access Compact or DBEngine compact, and if the former,
how do you do the DBEngine Compact of the current database as opposed to the
BE database?

Phil

"lyle fairfield" <lylefa1r@xxxxxxxx> wrote in message
news:Xns9C3BB7BB68C36lylefa1r@xxxxxxxxxxxxxxxx
MGFoster <me@xxxxxxxxxxx> wrote in
news:3Kmdnf3zVJlDXdbXnZ2dnUVZ_jVi4p2d@xxxxxxxxxxxxx:

Phil Stanton wrote:
You're right. Shouldn't have doubted you.

Odd though, with Forms Reports & Modules the dates are changed, but not
tables or queries. Any idea of the logic of that

Phil

No idea.


I guess that the cause is that Forms, Reports & Modules are Access Objects
while Tables are Jet or Ace Objects.
It might be interesting to compare a DBEngine compact with an Access
compact. My guess is that the Forms, Reports & Modules dates will not be
changed with the DBEngine compact, but it's !!!just!!! a guess.
--
lyle fairfield

Jacko is alive and well and assuming his second personna as Canada's
Governor-General full-time now.


.

Relevant Pages

  • Re: System slows to snail pace-Help!
    ... Event Source: Service Control Manager ... Error Reports do you have? ... To compact place the cursor on Local Folders and select File, ... the System and Application logs in Event Viewer for the last boot. ...
    (microsoft.public.windowsxp.general)
  • RE: Compact and Repair Alternative
    ... Server database, you can't avoid the DB bloat. ... SQLServer Reports to see if any off the self products come up that may work. ... usually have the Access file set to Compact & Repair on close but my issue is ...
    (microsoft.public.access.modulesdaovba)
  • Re: Reports and Quweeries
    ... Compact the database to get rid of this junk: ... > In my application I have to produce 5 different reports. ... > I created a query for the initial SubReport and the MainReport as well as ...
    (microsoft.public.access.reports)
  • RE: Access 2007 - Problems with saving on 1 form
    ... Try doing a compact and repair. ... The button prints 2 reports. ... I closed out without saving and tried something as simple as moving ...
    (microsoft.public.access.forms)
  • Re: Error when I run Append queries
    ... It seems that I forgot to set the options to compact on ... The queries not work without error. ... Dennis ... >>> in an argument to a method, such as specifying both dbConsistent and ...
    (microsoft.public.access.formscoding)