[AccessD] Cannot compact and repair database

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed Jul 5 14:22:09 CDT 2006


Problem solved!
Problem was found when copying tables to a new database. One of the
tables was corrupted. Restored table from a known good copy. Database
can now be compacted and repaired.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bryan
Carbonnell
Sent: Wednesday, July 05, 2006 1:37 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Cannot compact and repair database

On 7/5/06, Kaup, Chester <Chester_Kaup at kindermorgan.com> wrote:
> I have a database that when I tried to compact inside access and got a
> message that access has encountered and needs to close. This is with
the
> database open exclusively. I tried it using JetComp outside of access
> with the same result. Tried to decompile using the following from
Start
> Run and got an error cannot find c:\program...
>
> C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE /decompile
> c:\files\dss\sacroc.mdb

Try wrapping the paths in quotes. It might be getting hung up on the
space, so your command will look like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /decompile
"c:\files\dss\sacroc.mdb"


-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list