How to purge all the Integration Manager log tables?

I went through and purged all the log files from Integration Manager using 
the procedure outlined in the IM User's Guide. However, after I was finished 
I looked at the tables in the im.mdb Access database and noticed that the 
following tables still have quite a few records in them:

LogDocumentActivity
LogActivity
LogDocuments

The Log table was empty, which makes sense since I purged all the logs. 
However, these other tables seem to have retained their records.

Is there a way to purge these tables, too?


-- 
Bud Cool, Accounting System Manager
HDA, Inc.  Hazelwood, MO
GP 9.0, SP2
0
Bud (544)
2/21/2008 4:23:01 PM
greatplains 29623 articles. 6 followers. Follow

2 Replies
507 Views

Similar Articles

[PageSpeed] 27

Bud - 

I wrote a DTS package that would read the IM.mdb (access db source) and 
empty the contents of the below tables involved:-

table `Logs`
table `LogDocuments`
table `LogDocumentActivity`
table `LogActivity`

You can do this on a SQL 2000 server. Let me know if you need the DTS 
package exported as VB file or structured storage file.

-- After successfully running this package you would still need to compact 
and db using Access to notice any reduction in actual file size.
"Bud" wrote:

> I went through and purged all the log files from Integration Manager using 
> the procedure outlined in the IM User's Guide. However, after I was finished 
> I looked at the tables in the im.mdb Access database and noticed that the 
> following tables still have quite a few records in them:
> 
> LogDocumentActivity
> LogActivity
> LogDocuments
> 
> The Log table was empty, which makes sense since I purged all the logs. 
> However, these other tables seem to have retained their records.
> 
> Is there a way to purge these tables, too?
> 
> 
> -- 
> Bud Cool, Accounting System Manager
> HDA, Inc.  Hazelwood, MO
> GP 9.0, SP2
0
26point2er (113)
2/21/2008 10:57:00 PM
Bud,

Since you know how to open it in Access, why not just delete the records 
yourself?
Assuming you need instructions on how to delete rows:
First, create a new access database and link to your IM database.
(Right Click on the tables pane to bring up the link tables menu)
 This will insulate you from version conflicts. ( IM's databse is in 
Access97 format (JET3.5) while newer versions of access use JET4.0)
Now use the query builder to build your delete queries, or simply paste 
these queries and execute them

DELETE LogActivity.*
FROM LogActivity LEFT JOIN Logs ON LogActivity.LogID = Logs.LogID
WHERE (((Logs.LogID) Is Null));

Next, replace LogActivity with LogDocuments and LogDocumentsActivity and run 
the queries again

HS

"Bud" <Bud@discussions.microsoft.com> wrote in message 
news:367DD565-00FD-4616-9414-BA02A72051F4@microsoft.com...
>I went through and purged all the log files from Integration Manager using
> the procedure outlined in the IM User's Guide. However, after I was 
> finished
> I looked at the tables in the im.mdb Access database and noticed that the
> following tables still have quite a few records in them:
>
> LogDocumentActivity
> LogActivity
> LogDocuments
>
> The Log table was empty, which makes sense since I purged all the logs.
> However, these other tables seem to have retained their records.
>
> Is there a way to purge these tables, too?
>
>
> -- 
> Bud Cool, Accounting System Manager
> HDA, Inc.  Hazelwood, MO
> GP 9.0, SP2 


0
HSalim (1270)
2/22/2008 2:14:25 PM
Reply:

Similar Artilces: