Jim Lawrence
accessd at shaw.ca
Tue Dec 4 08:45:46 CST 2007
Hi Steve: Depending on the OS it can be easily removed. Go into services Start > Administration Tools > Services and Disable or Set to manual Check out http://www.file.net/process/msmpeng.exe.html There is a free program called startup inspector that might also help you remove it: http://www.download.com/Startup-Inspector-for-Windows/3000-2086_4-10452094.h tml HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of steve Sent: Tuesday, December 04, 2007 6: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