Recently after trying to set file associations for a .accdb file ( Access 2007 / 2010 file type ) , when trying to open an .accdb file it would display the .accdb “is not a valid Win32 Application”.

When trying to right click on the file and choose “open with” and find the MSACCESS.exe executable in C:\Program Files\Microsoft Office\Office 14 ( 2010) Office12 ( 2007\ it would still display the same error message. If you opened Access up and went to file open , and find the file manually it would open the file correctly. The issue is the file associations are set in Explorer , so you have to reset the file associations, then restart explorer for them to work.

Go to Regedit and deleted the following key : HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.accdb

Then download this , and run it :

http://www.pariswells.com/upload/fixaccdbfileassoc.zip

Now go to CTRL ALT Delete , Task Manager , Find Explorer.exe under processes, End the process. Then go to File and Run and type in Explorer.exe and press enter. You should now be able to open your .accdb files. A restart would of also performed this acction

VN:F [1.9.22_1171]
Rating: 8.9/10 (7 votes cast)
VN:F [1.9.22_1171]
Rating: -1 (from 1 vote)

I was installing Blackberry Enterprise Server 5.03 on a Small Business Server 2008 Box. Following through the receommend guide here http://www.edutech.me.uk/bes-express/installing-bes-express-on-sbs2008-server/

However after the reboot of the server it brought up the Database Management prompt and would not allow me to select a Local Server even though I had asked the Blackberry setup to create a New Database. Looking through the SQL Server 2005 Configuration it didn’t look like the BLACKBERRY Database had been setup. After a brief look online it looks like the blackberry account ( besadmin ) setup needs to modify through Active Directory via the following:

Account tab > Account options: Select option: Use Kerberos DES encryption types for this account.

I made the change, uninstalled the software and went through re installation again , and after the reboot , the database had been created this time and setup was able to complete

VN:F [1.9.22_1171]
Rating: 8.5/10 (2 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

After installing Sage Payroll 2010 on a Windows 7 machine the program loads with a splash screen then disappears. Even after running is with administrator rights and Windows XP compatibility mode the issue still occurs.

The fix is to Open a Command Prompt Screen , Start , Type CMD right click and run as administrator

Enter “regsvr32 msxml3.dll”

Reinstall Sage Payroll Over the Top

Sage Payroll now works !

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: -1 (from 3 votes)

The page here has a solution however it doesn’t work : http://wpquestions.com/question/show/id/1840 and the topic is closed hence for this post!

You need to edit this file : wpsc-transaction_results.php

I placed my code after the true statment for correct purchase

if ( ( true === $echo_to_screen ) && ( $cart != null ) && ( $errorcode == 0 ) && ( $sessionid != null ) ) {            
The value you need is $cart[0][prodid];

There are 2 array’s you can get information from $purchase_log and $cart

 

 

VN:F [1.9.22_1171]
Rating: 3.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Recently I was trying to install Windows 7 on a custom built system with an asus m2n-sli deluxe motherboard. When running through the Windows 7 Setup , the screen would stay on the “Starting Windows” screen and then eventually come back with a Blue Screen with the Error machine check exception. I tried different power supplys , windows disks and memory. Eventually I found machine check exception is in fact an issue with the processor speaking to the memory. I increased the CPU voltage from 1.41 volts to 1.51 and increased the DDR2 memory to 1.9v and Windows 7 setup went through fine!

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Recently a user synced his iphone to an SBS 2003 box , however email would only come through when their Outlook was open recieving mail , or the user would read the email in Web Access. This is an issue to do with Active sync and Trend Antivirus that the below registry entry fixes :

Browse to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSExchangeIS\VirusScan via regedit

Change the value of “ProactiveScanning” to 1 and close.

Restart IIS and Exchange services to make sure it gets applied.

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Recently a collegue contacted me for some help with his university degree. The project was to create a website that was backed by a database. My background is mainly PHP and MySQL however, the course had been teaching them how to manipulate an MDB Access Database file using ASP. The outline of the task was a document management system for projects.

  • A user would enter their unique company number into a page
  • It would list available projects for that company
  • User would select the project and login with a username and password
  • The website would list all files which he had permission to access

The tutorials the lecturer had given out used dreamweaver to create the ADODB.Connection , however it seemed an over complicated way of doing it. After a bit of online research my first ASP project is below ( Could be better but only had an evening to do it! )

index.asp

code here : http://pastebin.com/7s739FKa

This code manages the Company ID input then list the projects from that company

login.asp

Takes the project ID from index.asp and checks the permissions table after username and password verficiation for files they have access to

code here  : http://pastebin.com/BmNiXZgz

db.mdb

File here : http://www.pariswells.com/upload/db.mdb

4 Tables

Users -> Username , Password and ID

Projects -> Project Name , Company ID Associated with that Project and Project ID

Permissions -> FileID and UserID

Company -> Company Name , Company Number and ID

 

Definitely prefer PHP to ASP!

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

If you run a “locked down” group policy model and need users to add new network and local printers to their machine without being Local Administrators you will need to configure the below group policy. This will stop the  UAC Box in Windows 7 coming up and asking to administrator permissions to run “C:\windows\system32\NtPrint.exe”. This can be applied through a domain controller via a networked group policy or locally using gpedit.msc

In Windows XP this setting is configured in

User Configuration -> Administrative Templates -> Control Panel -> Printers

However in Windows 7 this setting is configured in

Computer Configuration -> Policies -> Administrative Templates -> Printers : Point and Print Restrictions

N.B. If you want to deploy the below group policy you will need to have your Domain Controllers up to the 2008 R2 Schema or use this tool to Modify the Windows 7 Policy

http://blogs.technet.com/b/iftekhar/archive/2009/08/13/remote-server-admin-tools-rsat-for-windows-7-now-available.aspx

You need to set Point and Print Restrictions to DISABLED

VN:F [1.9.22_1171]
Rating: 6.2/10 (6 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Most Cloud Services such as Frontbridge or Google Apps now require you to verify ownership of your domain with a TXT DNS Record. I recently had to update this for a domain hosted with Easyspace and a quick search around the control panel and google for how to add this proved fruitless. Their control panel only gives you A Record, MX or CName…

Turns out after further investigation, you can’t do this yourself and you either have to raise a support ticket through your Customer Login or a bit quicker – call them on

Support : 0370 755 5066 ( 0370 calls are charged at a local rate in the UK )

Over the phone , they will give you an email to send the request to. This can take up to 3 hours for them to action , then another few hours to propagate

This information would have been really useful on here

http://helpdesk.ufindus.com/faq.php?do=article&articleid=1488 Where they tell you what a TXT Record is , or their DNS Records Page

http://helpdesk.ufindus.com/faq.php?do=article&articleid=1558

Hope this information helps someone else!

VN:F [1.9.22_1171]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: +1 (from 1 vote)
When a user tried to open a PDF Document via Adobe Reader X after an Adobe Reader Update it produced the following error message “Before proceeding you must first launch Adobe Acrobat and accept the End User License Agreement” I thought this related to the End User License Agreement of Adobe Reader , so I tried to open it standalone but it did not bring the terms and conditions. The machine previously had Adobe Acrobat 8.0 Installed as a trial , but this was unistalled so Adobe Acrobat 6.0 Licensed copy could be installed. I tried to open adobe acrobat 6.0 however there was no End User License Agreement either. It looks like Adobe leaves some old registry information , so a complete unistall of Adobe Products on the machine and reinstall should fix the problem. However an easy fix, is to open up Adobe Ready , Go to Edit / Preferences / General Then tick the box to “Enable Protected Mode”
VN:F [1.9.22_1171]
Rating: 7.1/10 (63 votes cast)
VN:F [1.9.22_1171]
Rating: +4 (from 16 votes)