X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> 2003- error 1206 when compacting    
post Mar 7 2008, 03:30 PM

Posts: 284
Joined: 29-August 07
From: Rockville, MD

When I tried compact and repair of my database, a db1 database was created and in my original database a table MSysCompactError was created containing a record with -1206 unrecognized database format ...tblIndividuals I took the database home and tried compacting with Access 2007 and it seemed to have worked. What and why are these db1, etc databases that are created when compacting? [this is my first post - I am a newbie]
Go to the top of the page
post Mar 7 2008, 05:59 PM

UtterAccess VIP
Posts: 31,413
Joined: 23-September 04
From: NC, USA

do you mean that Access creates additional mdb files that are called db1, db2...in the directory that the original application is housed in every time you compact/repair? What permissions do you have on the folder the application is in. You need full read/write/delete permissions since Access actually creates a new application imports everything into it from the old one, deletes the old one and renamed the new to the old title. If it can't delete the old one then it will be stuck in the middle of the process.
Good luck
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    21st July 2019 - 08:23 PM