June 28, 2011

Remove password from Symantec Enterprise Antivirus

Filed under: Software — Tags: — lpopejoy @ 7:19 pm

So how do you get rid of the big yellow giant when you don’t know the password.  Fortunately, it isn’t hard.

Navigate to this registry key:

HKLM\Software\Intel\LANDesk\VirusProtect6\CurrentVersion\AdministratorOnly\Security\

Find the “UseVPUninstallPassword” key and change the value from a “1″ to a “0″.  Now go to Add/Remove Programs and remove it.  Enjoy your new freedom.

June 3, 2011

Decrease MySQL database size after deleting records

Filed under: Software — Tags: — lpopejoy @ 11:08 pm

I have a Mysql Database that I removed over 1,000,000 records from. Before record deletion, the database size was 408 MB. After I deleted all those records, guess how big it was? You’re right: 408 MB.

So to “reclaim” that space, first go to your favorite mysql query browser, and execute the query:

show table status;

It should show you all of your tables and information regarding those tables. One column should say “Data_free”. Look at what database has a large amount of “Data_free” space, and the excute another query:

optimize table YOURTABLENAMEHERE

 

After I had successfully optimized two tables, my database size went from 408 MB to 61 MB.

Now maybe my backups will work a little faster…

All the best,

Luke

October 15, 2010

Verizon USB760 not recognized after update

Filed under: Software,XP — lpopejoy @ 11:02 pm

I had a user call and say that after an update to his VZAccess Manager software, his USB modem was no longer detected.

First I tried removing and reinstalling the VZAccess Manager software.  That didn’t work – it still would not detect the device.

So I removed the software again, and went to C:\Program Files\ and deleted the “Verizon Wireless” folder.  I then went to C:\Windows\System32\Drivers and sorted the files by last modified date.  I was able to identify one file that was published by Novatel Wireless.  The file name was “NWADIenum.sys.”  I renamed that file to NWADIenum.sys-old and rebooted the computer.  I then plugged the USB modem in and installed the VZAccess Manager software again.  It detected the modem this time and installed new drivers for it.

To download the VZaccess Manager software (and any related updates for your card), go here:  www.vzam.net

Hope that gives you some extra time with your family this weekend.  :)

–Luke

March 10, 2010

All Office 2007 Apps Crash on Startup

Filed under: Server 2008,Software — Tags: , — lpopejoy @ 10:04 pm

Ok, so on a Server 2008 Terminal Server, I was getting this error when any Office 2007 app was started:

Faulting application WINWORD.EXE, version 12.0.6514.5000, time stamp 0x4a89d533, faulting module unknown, version 0.0.0.0, time stamp 0×00000000, exception code 0xc0000005, fault offset 0×00000000,process id 0×2320, application start time 0x01cac065295370c1.

After much hair pulling and screaming, I narrowed it down to this Microsoft Update:  Update for 2007 Microsoft Office System (KB967642)

I did also uninstall KB969559, KB978380, & KB977724 before removing KB967642 – which provided the final successful resolution.

Microsoft Updates (before I started removing when troubleshooting)

Microsoft Updates (before I started removing when troubleshooting)

Hope this saves some hair for somebody.

Luke

Edit:  It looks like the culprit may have been KB977724 after all.  Just had this problem again and removing that KB fixed it…

February 18, 2010

Considering a Blackberry Rollout?

Filed under: Blackberry,Business,Dell,Exchange Server,Software — Tags: , — lpopejoy @ 8:01 pm

Looks like your planned rollout just got cheaper. Can you say FREE? Thanks to some welcome and good news from the RIM giant.

http://www.blackberry.com/newsletters/connection/it/i210/enterprise_server.shtml?CPID=EMC-BBCN_IT_Feb2010

Here’s a nice comparison chart that shows all the features: http://na.blackberry.com/eng/services/business/server/express/ComparisonChart_NA_012110.pdf

If you need some help with that deployment, give our office a call!

Cheers to collaboration,

Luke

February 17, 2010

Quickbooks won’t print or save PDF’s…

Filed under: Software — Tags: , , — lpopejoy @ 5:34 am

If this looks familiar to you:
quickbooks-print-problems

Then I’ve got answers. First of all, for reference, you can look here: http://community.intuit.com/wikis?cid=8aec7ad5eac7a65757c6b03ac465eca5bc57e3b3

The short answer, to fix it, for me… was to go to C:\Program Data\Intuit\Quickbooks YEAR\ and rename the file QBPRINT.QBP to QBPRINT.QBP.old. Make sure you do that while Quickbooks is closed. Now open it and hopefully you will be able to print again. Note that you will have lost all your Quickbooks printing preferences…

Happy Accounting.

Luke

August 4, 2009

No ACT Plugins For Word

Filed under: Software — Tags: , — lpopejoy @ 9:52 pm

So I’ve got a fresh Word and ACT installation with NO toolbars.

The fix is a registry modification found here:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=21680&p_created=1191262515&p_sid=Fk-*5kBj&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MSwxJnBfcHJvZHM9NjUxMiZwX2NhdHM9JnBfcHY9MS42NTEyJnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD0yMTY4MA**&p_li=&p_topview=1

I also installed SP3, but I don’t think that was the problem.

–Luke

December 11, 2008

Before you can perform print-related tasks such as page setup or printing a document, you need to install a printer

Filed under: Software — Tags: — lpopejoy @ 12:03 am

When you try to print your pdf that your vendor just emailed over… You get:

Before you can perform print-related tasks such as page setup or printing a document, you need to install a printer

Have I ever mentioned that I’m becoming less and less impressed with Adobe?  It seems like their software, like almost everyone elses, is becoming more bloated and problematic rather than less so.  It takes forever to start, and takes forever to close.  We get faster computers, only so we can run software that just hardly better than what we are replacing…… anyway… on to the solution…

Anyone care to guess?

Well, try assigning yourself a default printer, or else changing your default…  It’s stupid, but that’s the solution!  …at least for me!

Now, on to fight more byte battles.

LP