Heenan, Lambert
Lambert.Heenan at AIG.com
Tue Dec 4 08:45:00 CST 2007
Hmm. Good old MS seem to have 'reorganized' their fora, so half the Google results give you ... Not Found: Forum Not Found This Forums has already been merged into another forum or deleted, please see the notification in Announcement Forums. However it seems that you need to disable automatic scanning altogether and only use the on-demand scan. Some people are also happy to uninstall the thing (from control panel by removing Windows Defender). Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of steve Sent: Tuesday, December 04, 2007 9:20 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] MsMpEng.exe My computer is essentially out of service due to a process named MsMPEng.exe. I don't think it ruins any database or other files, but it runs rampant and takes up over 90% of your CPU and most of your memory. Which leaves me with a 3 minute delay for every action I make. From what I've read in other forums, this is a Microsoft process related to Microsoft Defender, and typically comes when you install Microsoft's OneCare (firewall, backup, virus, spyware). I've tried turning off the "scan continuously" option under virus/spyware section of OneCare. It tried directly deleting the process, but it returns like a zombie. Has anyone else come across this and found a solution? Steve Capistrant Symphony Information Services www.symphonyinfo.com Email: scapistrant at symphonyinfo.com Phone: 763-391-7400 ext 801 Skype: steve.capistrant -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of rusty.hammond at cpiqpc.com Sent: Friday, November 30, 2007 9:39 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Trim in Access 2007 Not having worked with Access 2007 this is just a wag, but in SQL you can set a field as char (fixed length text) or varchar ( variable length text). Is this same capability in Access 2007 and could it be that your field type is set to fixed length? Rusty -----Original Message----- From: Michael R Mattys [mailto:mmattys at rochester.rr.com] Sent: Friday, November 30, 2007 9:25 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Trim in Access 2007 I'm going to try this Trim replacement: http://www.vbcode.com/Asp/showsn.asp?theID=967 Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com ----- Original Message ----- From: "Michael R Mattys" <mmattys at rochester.rr.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Friday, November 30, 2007 10:13 AM Subject: Re: [AccessD] Trim in Access 2007 > Yes, that's what I had originally. > Trim() does not appear to work at all > I'll have to do it with a custom function like yours. > > Michael R. Mattys > MapPoint & Access Dev > www.mattysconsulting.com > > ----- Original Message ----- > From: "Gustav Brock" <Gustav at cactus.dk> > To: <accessd at databaseadvisors.com> > Sent: Friday, November 30, 2007 10:05 AM > Subject: Re: [AccessD] Trim in Access 2007 > > >> Hi Michael >> >> Ignoring Trim for a moment, why not just execute a temporary query: -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com