<div>
The Compact and Repair creates a new db1.mdb with your data compacted, then deletes the original, and then renames db1.mdb as your database. You cannot compact your database while you are in it via a macro or code.<br />
<br />
Kelvin
</div>


The Compact and Repair creates a new db1.mdb with your data compacted, then deletes the original, and then renames db1.mdb as your database. You cannot compact your database while you are in it via a macro or code.

Kelvin

<div>
You can however do this with an AutoKeys Macro, using Sendkeys<br />
(do a web search of: &nbsp;Sendkey issues<br />
...to learn about the concerns when using SendKeys)<br />
<br />
Something like: %TDC<br />
<br />
Not near my Access 2003 box right now, but I am sure another expert can finish this off for you...
</div>


You can however do this with an AutoKeys Macro, using Sendkeys
(do a web search of:  Sendkey issues
...to learn about the concerns when using SendKeys)

Something like: %TDC

Not near my Access 2003 box right now, but I am sure another expert can finish this off for you...

<div>
Have the Permissions on the folder 'C:\Users\Judith\CARE2.8 changed at all recently ??<br />
<br />
Are you SURE the db is not open in another instance ?<br />
<br />
Do you see an LDB file in that folder ?
</div>


Have the Permissions on the folder 'C:\Users\Judith\CARE2.8 changed at all recently ??

Are you SURE the db is not open in another instance ?

Do you see an LDB file in that folder ?

<div>
<div class="content wysiwyg-content">
I have a macro that does a RunCommand where Command is CompactDatabase. &nbsp;I get the error message:<br />
<br />
The Microsoft Jet database engine cannot open the file 'C:\Users\Judith\CARE2.8\d<wbr />b1.mdb'. &nbsp;It is already opened exclusively by another user, or you need permission to view its data.<br />
<br />
The file db1.mdb doesn't exist. &nbsp;The file I'm trying to compact is CareProgram.mdb. &nbsp;Where is the db1.mdb coming from?<br />
<br />
Judith
</div>
</div>


I have a macro that does a RunCommand where Command is CompactDatabase.  I get the error message:

The Microsoft Jet database engine cannot open the file 'C:\Users\Judith\CARE2.8\db1.mdb'.  It is already opened exclusively by another user, or you need permission to view its data.

The file db1.mdb doesn't exist.  The file I'm trying to compact is CareProgram.mdb.  Where is the db1.mdb coming from?

Judith

Access 2003 Compact cannot find database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.