Re: Compacting an Access database with DAO


"John L." <JohnL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7E349F96-08FD-41AD-A3E0-6F1410983BB3@xxxxxxxxxxxxxxxx
We have a few databases with linked tables to SQL Servers and when we
attempt
to compact these databases by programmatically, it fails due to SQL Server
login information. I understand that you cannot use Microsoft Access to
compact and repair a SQL Server database, but we do have some native
Access
tables + forms/reports etc within the database; which we would like to
compact and repair. Is there a work around for this?

Thank you for your help.


I'm with Bob here, as your question is a bit vague.

To compact a database with DAO you must have access to the mdb file, and all
users must have released it. (no one logged in). ie, you can't compact a
database through a linked table.

[If using any mdb previous to Jet4, you have to do it in two steps, Repair
and Compact. With Jet4 you only need to call Compact.]
RepairDatabase "C:\myData1.mdb"
CompactDatabase "C:\myData1.mdb", App.Path & "myDataNewName.mdb",
<optional_locale>, <optional_options>, <optional_password>

-ralph



.

Relevant Pages

  • Re: Join Split Database
    ... Correction - I was able to compact and repair; it was when I tried to import ... Make two copies of the BE file and place in separate folders on ... Best case scenario is the users will not need to use the database ...
    (microsoft.public.access.gettingstarted)
  • Re: Invalid bookmark when entering data in a subform
    ... The compact and repair, decompile and compile, and importing into a new ... And here is a standard sequence to fix a problem database. ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • help with corrupt database
    ... I read your post below in the hope of finding help with a database that's ... I can't run the compact & repair utility now - I just get the same error. ... Do you think this file is corrupt beyond repair then? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Form Dirty not firing
    ... I no longer think that my database is corrupt. ... If the property is not set, the event procedure will not run. ... > also forces me to do a backup and compact and repair again. ...
    (microsoft.public.access.formscoding)
  • Re: Form Dirty not firing
    ... also forces me to do a backup and compact and repair again. ... MISSING references. ... Database Utilites... ...
    (microsoft.public.access.formscoding)