แก้ไข The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine (on Windows 64 bits)

เปิดไฟล์.vbproj และเพิ่ม < PlatformTarget >x86< /PlatformTarget > ลงใน

< PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' " >
และ
< PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' " >

อ้างอิง
http://www.bloggang.com/viewdiary.php?id=pui034&month=08-2009&date=29&group=13&gblog=11
http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/45aa44dd-0e6f-42e5-a9d6-9be5c5c8fcd1

แก้ไข Kaspersky ไม่โหลด Licence

Kaspersky Endpoint Security 8 for Windows CF1 version 8.1.0.831(a,b,c ): Patch D released

On February 21, 2013 Kaspersky Lab announced the release of Patch D for Kaspersky Endpoint Security 8 for Windows (version 8.1.0.831).
Patch D includes fixes covered by pf80 for issues related to Patch B:

• hanging of the operating system;
• slow launch of software installed;
• absence of Kaspersky Anti-Virus icon in the system tray.

Patch D applies to the following versions of Kaspersky Anti-Virus:

Kaspersky Endpoint Security 8 for Windows version 8.1.0.831 (a);
Kaspersky Endpoint Security 8 for Windows version 8.1.0.831 (a,b);
Kaspersky Endpoint Security 8 for Windows version 8.1.0.831 (a,b,c);
Kaspersky Endpoint Security 8 for Windows version 8.1.0.831 (a,b,c, pf80);
Kaspersky Endpoint Security 8 for Windows version 8.1.0.831 (a,b,c, pf82).

Patch D is distributed using the Update application modules task.

 If the Update application modules task fails on a client computer for some reason, e.g. due to Patch B installed, please do the following:

1. Reboot the computer in Safe mode.
2. Disable the Kaspersky Anti-Virus service.
3. Then reboot in the normal mode.
4. Install pf82 patch  locally or via Kaspersky Security Center.
   

Installing Patch D

Via Kaspersky Endpoint Security 8 for Windows GUI
To install Patch D automatically

• Open the Settings tab in the main application window.
• Go to Scheduled tasks > Update in the left part of the window..
• Enable the Update application modules option.

• Click Save.

Patch D will be automatically installed on the host during the next update session.
Reboot is required to apply the changes.


Via Kaspersky Security Center 9


To install Patch D automatically:

• Open the Properties of a group task.
• Enable the Update application modules option in both the Update settings for local mode and Update settings for mobile mode sections.

• Click ОК.

Patch D will be automatically installed on the managed computers during the next update session.

Reboot is required to apply the changes.


How to check if Patch D isinstalled
Locally
After installing the patch and restarting the computer, the application version changes to 8.1.0.831 (а,b,c,d), 8.1.0.831 (а,b,c,d, pf80).
You can view the full version of the application by clicking Support in the lower part of the main application window.
The bl.ppl file changes its version in the installation folder:

bl.ppl (8.1.0.903)

Via Kaspersky Security Center 9
To view the full version of the application, open the Administration Console and do the following:

• Go to the Reports and notifications node.
• Open the Kaspersky Lab software version report properties.
• Add the Updates installed field in the Detail fields section.
• Click ОК to save the changes.
• Generate the report.

The Updates installed field will show Patch D.


อ้างอิง http://support.kaspersky.com/9745

Excel การ Split ข้อความ

ข้อความ 11111:22222
ใช้ =LEFT(A1,FIND(":",A1)-1) จะได้ 11111
ใช้ =RIGHT(A1,FIND(":",A1)-1) จะได้ 22222

วิธีแก้ไข Profile Win7 เสีย (Join Domain)

1.Press on Start > Run >Regedit

2.Navigate to the following registry key :“HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList”

3.Under ProfileList navigate to binary key’s like this: S-1-5-21-3656904587-1668747452-4095529-500
 
4.On the right side under ProfileImagePath you'll see the profile path.

5.Chose the one with the desired user and delete the long registry key like: “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList”

การเปิดใช้งาน .Net ใน Windows 8 แบบ Offline

1. ใส่แผ่น Win8
2. ใช้คำสั่ง

Dism.exe /online /enable-feature /featurename:NetFX3 /All /Source:E:\sources\sxs /LimitAccess

**ตัวสีแดงจะเปลี่ยนตาม Drive ที่ใส่แผ่น Win8