Advertisement

05.07.2008 at 08:58AM PDT, ID: 23383271
[x]
Attachment Details

Temporary Db1.Mdb Files Is Not Automatically Deleted After Compact & Repair

Asked by TomWinslow in Access Coding/Macros, Access Architecture/Design

Tags: Microsoft, Access, 2003, Excel, SQL

I do many MSAccess 2003 projects on our LAN/WAN. Most of my MSAccess databases are set to automatically compact & repair after the MACRO runs.

Lately I have noticed that the db1.mdb files are not being deleted. If I run the same MSAccess process from my local C: drive the db1.mdb files are automatically deleted but on the network, they are not.

What network rights must have been changed to cause this to happen? I have the ability to export, delete, import, etc. I can delete the db1.mdb file with Windows Explorer but it will not automatically delete when MSAccess closes.

Any ideas?

Tw
Start Free Trial
 
Keywords: Temporary Db1.Mdb Files Is Not Auto…
Title
1 Compact and Repair
2 Compact/Repair db..
3 Compact Creating db1.mdb, db2.…
4 How automatically doing Compact and …
5 Auto Compact . . .
6 Problems Compacting Database
 
Loading Advertisement...
 
[+][-]05.07.2008 at 09:22AM PDT, ID: 21517971

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 09:26AM PDT, ID: 21518015

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 09:33AM PDT, ID: 21518075

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 09:36AM PDT, ID: 21518095

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 11:18AM PDT, ID: 21518985

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 12:15PM PDT, ID: 21519476

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.07.2008 at 03:44PM PDT, ID: 21521002

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Access Architecture/Design
Tags: Microsoft, Access, 2003, Excel, SQL
Sign Up Now!
Solution Provided By: harfang
Participating Experts: 1
Solution Grade: A
 
 
[+][-]06.15.2008 at 08:01AM PDT, ID: 21788745

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.21.2008 at 01:40PM PDT, ID: 21838637

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628