Saturday, July 31, 2010

How To Fix Office 2010 install error 1402 ‘Setup cannot open the registry key: UNKNOWN\Components\…’

Deleting Grooveex.dll was one of the two problems I encountered recently during Office 2010 re-installation in Windows 7. This post will focus on the Install Error 1402 where Office 2010 setup cannot open the registry key named Unknown/Component/[Random Numbers]. Fixing this problem requires a cup of coffee and patience.


This error is only shown when registry keys do not have Administrator permission. But you are logged in as Administrator, right? As it happens some setup can mess up the registry permissions and Office 2010 installer is no exception.

Entering the following line in Command Prompt will fix the problem for most people, 
secedit /configure /cfg %windir%\inf\defltbase.inf /db defltbase.sdb /verbose
but it didn’t work for me. If it doesn’t work for you as well, follow the second method below.
Download SubInAcl, a command line tool from Microsoft that enables administrators to obtain security information about files, registry keys services, etc. It will install to Program Files folder, copy SUBINACL.EXE file to /Windows/System 32 folder.
 
Now create a new notepad and paste the following code in it;
subinacl /subkeyreg HKEY_LOCAL_MACHINE /setowner=administrators
subinacl /subkeyreg HKEY_CURRENT_USER /setowner=administrators
subinacl /subkeyreg HKEY_CLASSES_ROOT /setowner=administrators
subinacl /subkeyreg HKEY_LOCAL_MACHINE /grant=administrators=f /grant=system=f
subinacl /subkeyreg HKEY_CURRENT_USER /grant=administrators=f /grant=system=f
subinacl /subkeyreg HKEY_CLASSES_ROOT /grant=administrators=f /grant=system=f
cls
Exit
Rename the notepad to reset and change the extension to cmd, the complete name will become “reset.cmd” as shown in the screenshot below. Run this file as administrator.
reset cmd
The process will now take several minutes, do NOT close the Window what may come. Once the process is complete, the command line window will automatically close and you can then install Office 2010 successfully.
reset registry

Update: Mike in the comments below has shared a method that worked for him and many others, the method is as follows:
I was able to get the install working with Win7 64 bit. When you get the error: “setup cannot open the registry key named” The key that follows is what you want to look for in the registry. Once you find the key (mine was in hklm\software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components), you will notice that there are subkeys underneath that you don’t have any permission to. First, right-click the top key (one in error message) and click permissions. Next click advanced and then the owner tab. Make sure adminsitrators is listed as an owner and then click the check box “Replace owner on subcontainers…”. When you press OK, you will get errors but that’s OK. Now check “Full Control” on the permisions for the administrators group and then click the Advanced button again. Then check the “Replace all child object permissions…”. Click OK. Again, you might get errors but that’s OK. You’ll notice you have permissions to the subkeys now.
Unfortunately, there is more than one key effected. If you run setup again, you get an error on another key. I ended up looking for any key in the components area that had the arrow showing they could be expanded. Any one of those I didn’t have permission to, I changed like above. I think there were about 7 or 8 more. Eventually, the install worked and now I’m up and running. Long process but it did work for me.

Friday, July 30, 2010

How do you transfer a domain from godaddy.com to your hosting account?

For Hosting & Domain
Actually, you can settle your domain point to your hosting /Folder directory and adjust DNS server IP address to your hosting account.

For Domain Transfer
Normally, you can find "Domain management" part of your hosting account at your hosting provider company site page. And then, select "domain transferring" tab to enter your domain name that you want to transfer. Meanwhile, you should go back GoDaddy to unlock your domain; also, you should follow some procedures as verify your authorization code with email confirm...etc. You have to wait 5 days after you complete all the step to submit transfer, finally, you domain transfer to the other hosting company.
However, you'd better consider of 2 things;
1. You have to view your domain contract period; if it gonna expires soon, that's fine you can do it ASAP. Otherwise, you have to know your registration fee have no refund when you transferred your domain still in your contract period; you can do it if you didn't care!
2. this is a real domain that you should pay the registration fee to the other domain company for holding your legal ownership permission. I saw hostgator doesn't really has that, they just said "Domain transfer coming soon and Free?" at the home page. So you have to ask your hosting provider company and I don't think is free but you might have discount for it!

Paypal Update: Resumes Electronic Withdrawal Service to India

Now this comes as a surprise – Just 2 days after Paypal had announced that they will be stopping Electronic Funds Withdrawal to Indian Banks – They seem to have made a complete U turn.
The announcement on their blog today says that Indian Paypal users can perform electronic withdrawals as they did before. Infact, Electronics Funds withdrawal is already online and working.
paypal-EFT-start
Here is the update from the Paypal India Blog:
Hi everyone, it’s Dickson Seow again, from the Corporate Communications team. We’ve received good news – India users can perform electronic withdrawals right now as you did before.
We apologize for the inconvenience this has caused you over the past few days. While we have received your appreciation for the advance notice and the refund of the cheque processing fee, we have also heard loud and clear that you highly value the ease-of-use of our electronic withdrawal service. We want you to know that our customers are our #1 priority and we are working non-stop to improve our service to you.
We sincerely thank you for your patience and continued support as we are committed to delivering a world-class service to you in India. To thank you for your loyalty, we will still provide the US$5 processing fee refund for any cheque withdrawals made from July 29 until further notice.
Please check here for updates. If you have any questions, please contact PayPal customer support by logging into your PayPal account and clicking on ‘contact us’ at the bottom of the page.
Paypal seems to be really confused – Infact, Paypal had confirmed to some users that the ban on Electronics Fund transfer to India is permanent and the only way they can get money is through Cheque. See some of the comments on our earlier Paypal post, where users have confirmed it from Paypal itself !
Anyways, Paypal users can have a sigh of relief, they will not have to go through the torture of waiting endlessly for their hard-earned money !

PayPal Ending Electronic Withdrawals in India Aug. 1

PayPal announced Tuesday that starting Aug. 1, it will only allow check withdrawals for its users in India.

"At present, you can request for either an electronic or check withdrawal of funds from your PayPal account," Dickson Seow from the PayPal corporate communications team wrote in a blog post. "From July 29, 2010 onwards, you will only be able to request for a check withdrawal of funds from your PayPal account."

PayPal said it will refund the $5 check fee charged on withdrawals made on July 29 onwards.

The change stems from a government financial overhaul that has put the future of PayPal in India in jeopardy since earlier this year.

In February, PayPal halted personal payments in India amid questions from Indian regulators about whether personal payments constitute remittances--or money transfers that foreign workers make into their home countries--into India.

This suspension caught many by surprise and meant that some people with money in their PayPal accounts had no way of getting it out. PayPal had planned to start allowing withdrawals to Indian banks on February 14, but complications delayed that move until early March. Personal payments were still suspended.

To gain access to funds, users must click "Withdraw" and then "Request a check from PayPal." Check processing takes 4 to 6 working days, excluding delivery time. More details are available on PayPal's Web site.

"We sincerely apologize in advance for any inconvenience caused from this change and we are working hard to restore the electronic withdrawal service," Seow wrote "In the meantime, we are bringing this matter to your attention so that you can plan your future withdrawal activities accordingly."

How to use Web Site Administration Tool without installing VS 2005

Hello everyone!! This one is a tweak to ensure that you are able to Administer your ASP.NET 2.0 web-site *without* installing Visual Studio 2005 on your IIS Server.

For that, you would need Framework 2.0 installed on your Server. If you don't have it, please install it from http://msdn.microsoft.com/netframework/downloads/updates/default.aspx.

Now, follow the instructions below...

1) In the box where you have VS 2005 installed, open an application which you want to Administer.
2) I am using File System to open the website and have called it WebSiteAdminister
3) Click on the ASP.NET Configuration button in your Solution Explorer's toolbox
4) Copy the URL (in my case, it is... http://localhost:2002/asp.netwebadminfiles/default.aspx?applicationPhysicalPath=C:\Inetpub\wwwroot\WebSiteAdminister\&applicationUrl=/WebSiteAdminister)
5) Now, go to the IIS Box where you don't have VS 2005 installed
6) Open IIS console (Click on Start -> Run, type Inetmgr and click OK)
7) Right-Click on your Default Web Site and say New -> Virtual Directory
8) Click on Next, give an Alias (WebSiteAdmin) and click Next
9) In the Directory text box browse to... "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ASP.NETWebAdminFiles" and click Next, Next and Finish
10) Right-click on WebSiteAdmin and hit properties
11) Click on the ASP.NET Tab and select 2.0.50727 as ASP.NET Version and click Ok
12) Copy the content of the website from the Development box to the IIS Server (I did it at "c:\inetpub\wwwroot\WebSiteAdminister")
13) Open an instance of Internet Explorer and in the Address Bar type... http://localhost/WebSiteAdmin/default.aspx?applicationPhysicalPath=C:\Inetpub\wwwroot\WebSiteAdminister\&applicationUrl=/WebSiteAdminister
14) You should be able to see ASP.NET Web Site Administration Tool (You can bookmark this so that you don't have to remember that string)
15) As you can see, we have removed the port number (2002) and changed asp.netwebadminfiles to our application WebSiteAdmin.

By the way, just to bring it to your notice, Administering you web site using the above technique is NOT supported at Microsoft. For support options at Microsoft, please visit... http://www.microsoft.com/services/microsoftservices/srv_support.mspx

How to Use PayPal: Basics and Beyond

PayPal is a money transfer site which allows individual to send funds to others or make online purchases. PayPal is a popular site for transferring money online, but making the most of a PayPal account can be confusing. This page will teach you how to use PayPal.

PayPal is an online financial middleman that facilitates the transfer of money between people and businesses online. Users only need to share private financial information with PayPal, not unknown parties. You can use PayPal to buy things online, shop on eBay, or receive money from your friends. If you've ever wondered about how to use PayPal, read on and learn!

This guide takes you through all the steps needed to get started, and then to make full use of PayPal services.

First we’ll look at the different types of PayPal account – Personal, Premier and Business – and which one is best for your needs. Then we’ll proceed on to how to create an account from scratch.

A PayPal account can receive money as soon as it’s been created, but to use it to send money or to buy products online, you’ll need to set up a means of getting funds into the account. Normally to do that people link their PayPal account to an existing bank account, or to a credit or debit card. This guide covers that process, and the means by which PayPal makes sure that you are the true owner of the account.

After you’ve completed those steps, you’re all set to send or receive money, and to buy and sell online. We’ll examine some of the ways that you can do that, for example by using PayPal buttons on websites, including eBay, using PayPal from a mobile phone, and how to send money by email.

Finally we’ll discuss how to stay safe using PayPal, looking out for signs of potential scams and security issues. We’ll also provide pointers to more topics, such as using PayPal with other software like Quicken, Skype and Facebook, and ways to resolve any problems that you might have.

How To Make Money With Youtube

Day 1 - How To Make Money With Youtube

YouTube is a popular online website, which allows internet users, just like you, to share videos or watch an unlimited number of them.

Make Money With YoutubeWhile a good portion of the individuals who post videos on YouTube are just posting videos that they have laying around, there are many more who actually make videos with the sole purpose of uploading them to YouTube and sharing them with other internet users. If you are one of those individuals, there are a number of points that you will want to keep in mind.What you need to MAKE MONEY WITH YOUTUBEWhen it comes to making a YouTube video, one of the things that you will need is a video recording device. Popular video recording devices include camcorder, webcams, as well as cell phones with video recording capabilities. If at all possible, you will want to try and use a webcam or a camcorder, as these video recording devices often produce the best quality. If you are looking to make your YouTube video be a hit, quality is something that you will want to take into consideration. Many YouTube video viewers dislike watching poor quality videos; in fact, not everyone sticks around to finish watching them.Editing is also something that you will want to take into consideration. YouTube actually encourages you to examine your video before uploading it to their site. If you notice anything that you would like changed, you are advised to edit your video before uploading it to YouTube. Of course, you don't have to edit your video if you don't want to, but editing your video is also likely to improve the overall quality of your YouTube video. It is also relatively easy to do. Most computers come with movie editing software programs already installed. It may even be a good idea to play around with a movie editing software program and your YouTube video; you may be surprised just how fun it can be.

Day 2 - How To Make Money With Youtube

Make Money With Youtube Day 2

It is also important that you think about and examine the content of your video, especially if you are planning on doing a comedy video.

Comedy videos are popular on YouTube, but you need to remember that a large number of people visit YouTube for entertainment. Many of those individuals are from different races, sexes, and religions. You will want to be cautious of offending any of your viewers, intentionally or not. Keep in mind that comedy means different things to different individuals. Of course, you have the right to make just about any type of YouTube video you want; you are advised to use your best

Should you be good at making YouTube videos, you may be able to make a name for yourself on YouTube, but you will want it to be a good one.

It is also important that you examine safety when making a YouTube video. As previously mentioned, comedy videos are popular on YouTube and so are video blogs.

Video blogs are where internet users recite their blog in front of a camera, instead of in print. Video blogs are fun to do, but many video blogers, both on and off of YouTube, make the mistake of giving out too much information about themselves. For your safety, you will want to avoid giving your real name, especially if you are showing your face on your video blog. It is advised that you do not mention your real name in any of your YouTube videos, but you definitely do not want to mention your address or any of your phone numbers. Not divulging your personal information is for your own safety. You need to remember that you never really know who is watching your YouTube videos or what they are thinking.

The above mentioned points are just a few of the many that you will want to keep in mind, before making a video which will later be posted on YouTube. In short, aim for quality and keep internet safety in mind and your YouTube video could end up being a hit.

Day 3 - Make Money With Youtube

Look, subsribe to my Boot Camp and you will get WAY MORE that just how to make money with youtube. I will show you how I make money with Youtube, Myspace, Facebook and hundreds of Web 2.0 sites. BUT VIDEO MARKETING is the cement in the business. Within 1 year I have replaced a very good executive income. Hope to see you soon!

How to Download Yahoo Video?

Use Orbit Downloader as Yahoo Video Downloader Orbit Downloader is a free Yahoo video downloader which can help you to download FLV video from Yahoo easily with great speed. Also Orbit Downloader can download and manage FLV videos from almost all of video-sharing websites like YouTube, Dailymotion, Myspace, Google, Yahoo, Metacafe, iFilm ...

(1) Hover your mouse on the playing Yahoo video, making Brand Upon The Brain for example, you will see a small button appeared near your mouse, like this:



How to
 download Yahoo Video? - Use Orbit Downloader as Yahoo Video Downloader

(2) Click the 'GetIt' button, then the Grab++ will be run.

(i) When you first run the Grab++, it will noctify you refresh the page to grab the playing Yahoo video. ( if the Grab++ has been run before you play the Yahoo video, the hint dialog will not be displayed. )
How to
 download Yahoo Video? - Use Orbit Downloader as Yahoo Video Downloader
(ii) Close the 'Hint' dialog. Then refresh (press F5 or ctrl+F5 in your browser or click the 'Refresh' button in your browser) the webpage, you will find that the playing Yahoo video has been grabbed and listed in the Grab++ interface:
How to
 download Yahoo Video? - Use Orbit Downloader as Yahoo Video Downloader

(3) Select the Yahoo video in the Grab++ list then click ' Download...' button, Orbit Downloader will download the selected Yahoo video for you.



How to
 download Yahoo Video? - Use Orbit Downloader as Yahoo Video Downloader

How to
 download Yahoo Video? - Use Orbit Downloader as Yahoo Video Downloader

Tips:

  • (1) You could run Grab++ to start sniffer BEFORE playing the Yahoo video in webpage. If Grab++ don't capture the Yahoo video, try refresh the page and make sure the video is PLAYING..
  • (2) The Yahoo videos are in FLV format. And lots of FLV players are in software download sites. Or you can download one of them athere.
  • (3) Some of the Yahoo videos can not be resumed because file-resume is forbidden in some Yahoo servers. If the connection is break when downloading, you could redownload it by clicking the download item's context menu 'Restart download'.
  • (3) There may be a timeout limitation at video.yahoo.com. If Grab++ capture the video, please download it SOON. If the video can not download, please refresh page and let Grab++ capture it again.

How to Manage Your Time

Have a lot to accomplish? Learn to focus on what is most important. Here's a quick, efficient and organized technique for completing tasks:

1. Make a random list of tasks.

2. Assign realistic priorities to each task.

* Priority 1: due today or tomorrow
* Priority 2: due in one week
* Priority 3: due in one month
* Priority 4: due next year
3. Balance your effort. Work on small portions every day.

* Do the daily tasks. Concentrate on what is at hand, then move on to the next daily task. Once daily tasks are completed, proceed to the next step, if desired.
* Do the weekly tasks. Once weekly tasks are completed, proceed to the next step, if desired.
* Do the monthly tasks. Once monthly tasks are completed, proceed to the next step, if desired.
* Do the yearly tasks.
* Small portions of the future tasks will have been done ahead of time.
4.Decide upon the time of day. Some people are more productive in the morning than the evening.
5.Manage time in increments. Play a game with yourself by competing against time.

* Work in fifteen minute, half hour or hour intervals.
* Give yourself a time limit to complete a portion of a task or the entire task.
6.Take a break. Clear your mind and refresh yourself to refocus.

* Decide beforehand on a 5, 10 or 15 minute break and stick to that decision.
* During your break, reasses to develop a new perspective.
* Breaks provide incentive by giving you something to look forward to.
7.Keep track of your progress.

* Cross things off the list as they are completed.
* You'll feel more relieved and relaxed just by getting through the daily tasks.
* This will give you a sense of accomplishment and spur motivation.
8.Reassess the list.

* Rewrite and reprioritize your list as needed.
* Add new tasks to the list.
* Eliminate certain tasks.
* Delegate tasks to others.
* Use technology to complete tasks more quickly, efficiently or accurately.
9.Make sure to leave time for fun, it doesnt have to be a lot of time but

make sure that you do!

How To Set Up Database Replication In MySQL On Ubuntu 9.10

This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.
I do not issue any guarantee that this will work for you!

1 Preliminary Note

In this tutorial I will show how to replicate the database exampledb from the server server1.example.com (master) with the IP address 192.168.0.100 to the server server2.example.com (slave) with the IP address 192.168.0.101.

Both systems are running Ubuntu 9.10; however, the configuration should apply to almost all distributions with little or no modifications. The database exampledb with tables and data is already existing on the master, but not on the slave.


I'm running all the steps in this tutorial with root privileges, so make sure you're logged in as root:


sudo su

Please enable the root account on server2 (in case you haven't already done so) so that we can transfer the files from server1 to server2 with scp:


server2:

passwd root


 

2 Installing MySQL 5

If MySQL 5 isn't already installed on server1 and server2, install it now:


server1/server2:


aptitude install mysql-server mysql-client


You will be asked to provide a password for the MySQL root user - this password is valid for the user root@localhost as well as root@server1.example.com / root@server2.example.com, so we don't have to specify a MySQL root password manually later on:


New password for the MySQL "root" user: <-- yourrootsqlpassword


Repeat password for the MySQL "root" user: <-- yourrootsqlpassword


 

3 Configuring The Master

To make sure that the replication can work, we must make MySQL listen on all interfaces on the master (server1), therefore we comment out the line bind-address = 127.0.0.1 in /etc/mysql/my.cnf:


server1:


vi /etc/mysql/my.cnf




[...]
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1
[...]

Restart MySQL afterwards:


/etc/init.d/mysql restart


Then check with


netstat -tap | grep mysql


that MySQL is really listening on all interfaces on the master:


root@server1:~# netstat -tap | grep mysql

tcp        0      0 *:mysql                 *:*                     LISTEN      2166/mysqld

root@server1:~#


Now we set up a replication user slave_user that can be used by server2 to access the MySQL database on server1:


mysql -u root -p


On the MySQL shell, run the following commands:


GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'slave_password';

FLUSH PRIVILEGES;

quit;


Furthermore we have to tell MySQL for which database it should write logs (these logs are used by the slave to see what has changed on the master), which log file it should use, and we have to specify that this MySQL server is the master. We want to replicate the database exampledb, so we add/enable the following lines in /etc/mysql/my.cnf (in the

[mysqld]section):


vi /etc/mysql/my.cnf




[...]
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
server-id               = 1
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
binlog_do_db            = exampledb
[...]

Then restart MySQL:


/etc/init.d/mysql restart


Next we lock the exampledb database on server1, find out about the master status of server1, create an SQL dump of exampledb (that we will import into exampledb on server2 so that both databases contain the same data), and unlock the database so that it can be used again:


mysql -u root -p


On the MySQL shell, run the following commands:


USE exampledb;

FLUSH TABLES WITH READ LOCK;

SHOW MASTER STATUS;


The last command should show something like this (please write it down, we'll need it later on):


mysql> SHOW MASTER STATUS;

+------------------+----------+--------------+------------------+

| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |


+------------------+----------+--------------+------------------+

| mysql-bin.000001 |    19467 | exampledb    |                  |

+------------------+----------+--------------+------------------+

1 row in set (0.00 sec)




mysql>


Now don't leave the MySQL shell, because if you leave it, the database lock will be removed, and this is not what we want right now because we must create a database dump now. While the MySQL shell is still open, we open a second command line window where we create the SQL dump snapshot.sql and transfer it to server2 (using scp):


server1:


cd /tmp

mysqldump -u root -pyourrootsqlpassword --opt exampledb > snapshot.sql

scp snapshot.sql root@192.168.0.101:/tmp


Afterwards, you can close the second command line window. On the first command line window, we can now unlock the database and leave the MySQL shell:


server1:


UNLOCK TABLES;

quit;

How to change the mysql database location

  • Identify the database files you wish to migrate into the new data directory
    You can use the following command to list the current databases in mysql
    mysqlshow -u root -p

    Keep this list available as you will reference it in a later step
  • Shutdown the MySQL database, if it is running
  • mysqladmin -u root -p shutdown
  • Locate the MySQL configuration file. This is usually located in the directory $OSS_HOME/var/mysql
  • Note: You should make a backup copy of each file you're editing before modifying the contents The property you need to change is named datadir. The default value is $OSS_HOME/var/mysql, which places the database files in the same directory as the log files and other runtime generated files. This property is usually located in the [mysqld_safe] section in the configuration file You need to change:
    [mysqld_safe]
    datadir      = /opt/oss/var/mysql
    to
    [mysqld_safe]
    datadir      = /opt/oss/var/mysql/data
  • Save these changes
  • Create the directory you specified in the datadir property
  • mkdir -p /optoss/var/mysql/data
  • Check to make sure the user assigned to execute mysql has read/write privileges on this directory
    You may need to modify the directory settings using chown and chmod
  • Move the databases listed in the first step to the new data directory
  • mv test /opt/oss/var/mysql/data
    Note: You can use the copy (cp) command instead if you prefer. Remember to remove the copied files once the migration is complete You will need to move/copy each database into the new data directory
  • After all the databases have been migrated to the new data directory, you should start MySQL
  • openpkg rc mysql start
    The database files will now be managed under the new data directory. If you encounter any problems during startup, you check the hostname.err file located in the data directory.
  • Think about Apparmor
    If you are using some security software like Apparmor (which is installed on major default server distributions), think about editing the appropriate configuratio file

How To Convert Access to MySQL

Here's how to convert Access data to MySQL:

1. Install and configure MySQL or obtain the information need to access pre-existing server.
2. Visit DBTools Software and download the installer for the demo of DBTools QueryIT.
convert access to mysql
3. If you are in Access 2000, go to Tools > References menu option and click the "Microsoft DAO 3.6 Object Library" option in the dialogue box.
4. Enable DAO (Data Access Objects) by launching DBtools, select Options > Preferences and choose the DAO 3.6 option. It is not important for you to know what DAO are. Just know that, if this is not done, the program will crash.
5. Quit and relaunch DBTools.
6. Now we will establish a connection to your MySQL server. Either click the server icon on the toolbar or go to Server > Add Server to create a profile for your new connection.
7. After establishing a connection, use the Import Data Wizard to browse for the Access file you want to use.
8. Select the version of Access the file was created in, as prompted.
9. If you would like to use Access as a front end, open the database from Access and remove the tables you transferred. Using Access as a front end simply means using Access but having the data stored in a MySQL table.
10. Download the MySQL Connector ODBC (Open Database Connection) driver from the MySQL website. An ODBC allows you to create a connection between two or more databases.
11. Run the installer to install the driver.
12. Now there should be a new icon in your Control Panel that reads either ODBC or Data Sources. Double click this to open the ODBC Data Source Administrator.
13. With the "User DSN" tab selected, click on "Add." The DSN contains data source information. This will allow you to create a new data source and input information necessary for the driver to communicate with the data source.
14. Select "MySQL ODBC 3.51 Driver" from the list of drivers, and click "Finish."
15. Fill in the form and create a data source name that you will use to refer to the database when you wish to access it.
16. Click "Test Data Source" to ensure you have entered your login information correctly.
17. Click OK to create the DSN.
18. Click File > Get External Data.
19. You will then be presented with a file browser. As before, choose "ODBC Databases ()" from the drop-down menu at the bottom, and choose your DSN from the list of Machine Data Sources. You will then see a list of all the tables in your MySQL database. Select the table that you want to link, and click OK.
20. It will then prompt you to select a unique record identifier. A unique record identifier is the cell whose value makes a record unique. In your Access database you may have an ID number for every record -- unique to that record. Doing this is very important.
21. You can now access your linked MySQL database through Access. This means that the data for your database is now stored in MySQL tables. If you would like, you could use Access as the front end and continue to use it as you did prior to the migration. The only difference is that the data would no longer be stored in the Access file, but rather in MySQL tables.

How do I use phpbb?

Installing phpBB is pretty straight forward, you'll only need access to FTP and the login credentials of your database. Both are provided by your host. Also you'll need a FTP client if you haven't one yet to access the server. Have a search on google for one. Once you have this we can start setting the system up.
  1. Download the latests phpBB package (3.0.4)
  2. Unzip the archive, you'll end up with a directory named phpBB3
  3. If you want rename this directory to match your needs (forum, community, etc)
  4. Login to the server through your FTP client and upload this folder to your server.
  5. Point your browser to the installer
    http://www.example.com/phpBB3/install

  6. Follow the instructions on the screen


Once you've finished the installation login through ftp again and navigate into the phpBB folder. Now remove the directory named "install".

How to Check Transmission Fluid in a Honda Accord

Like other automotive fluids and oils, you should check the transmission fluid on your Honda Accord at regular intervals. Look for foreign particles and oil condition that may affect and accelerate the wear of internal components. Follow these simple steps to inspect the condition of the transmission oil in your vehicle in a matter of minutes. The guide applies to the 2003 2.4-liter engine, which is very similar to other models.

  1. Step 1
    Park your car in a safe place with a level surface.
  2. Step 2
    Start and warm the engine until it reaches operating temperature and the cooling fan comes on.
  3. Step 3
    Move the transmission shift selector through every position and back to park. Apply the parking brake and block the rear and front wheels.
  4. Step 4
    Open the hood of your car and locate the transmission dipstick. In most models, you will find the dipstick at the rear and to the side of the engine. Some transmissions have a dipstick handle marked with the words Transmission Oil, or come with a rounded, orange-colored handle.
  5. Step 5
    Pull the dipstick and wipe clean the tip with a clean shop rag. Insert the dipstick back into its guide tube.
  6. Step 6
    Pull the dipstick again, hold the tip on a clean shop rag and inspect the oil at the tip. The oil should be clear with a reddish color to it. If the oil looks dirty or smells burned, change the transmission oil.
  7. Step 7
    Look at the oil closely and make sure there are no metal, dirt, moisture or fiber particles in it. These particles might come from internal parts' wear. If left in the oil, these particles may accelerate parts' wear and even cause transmission failure. Change the transmission oil if it is contaminated.
  8. Step 8
    Make sure the level of the oil in the dipstick reaches the full mark. If the oil is between the Add and Full mark, add only half a quart of the manufacturer recommended transmission oil. If the oil is at the Add mark, add a quart of oil. Add oil through the dipstick guide tube using a funnel and check the oil level again.
  9. Step 9
    Replace the dipstick in the guide tube, close the hood and turn off the engine.

Thursday, July 29, 2010

How to Use Google Buzz (PCworld)

Your Gmail inbox will be more buzzing that ever before with the launch of Google Buzz service from Google. It brings real time interactive elements currently found on services like Twitter and Facebook directly into your Gmail inbox. It is a new way to start conversations about the things you find interesting and share updates, photos, videos and more. Best part, there is nothing to setup or download or install to use Google Buzz.

Get Google Buzz in Gmail inbox

1. Goto gmail.com & login into your account.
2. Click on Buzz icon on left sidebar under ‘Inbox’ icon. [Don't see that options? - Google Buzz is being rolled out in phased manner, your Gmail inbox should have this feature very soon]
3. Just like following & followers concept on Twitter and Facebook fanpages, Google Buzz will automatically display your following and followers Gmail users (people you email and chat the most).
4. Then you are all set to use Google Buzz,  you can share photos in full resolution, watch inline videos without going to separate webpage.
5. You can connect with activity on other website including: Flickr, Google Reader and Twitter (Facebook might be added later, hopefully).

Google Buzz Video Demo

Unlike email, Google Buzz is real time – any response made is delivered instantly to fire up the conversation and create buzz. Also, you can selectively follow few people and only see their updates. Bump into your Gmail account and test drive Google Buzz. [via GoogleBlog] [Also See - Get Google Buzz on Mobile phone]

How to use Google Buzz (Google Support)


Google Buzz lets you share updates, photos, links, and pretty much anything else you'd like with your Gmail contacts; it's an easy way to follow your friends, too. When you click Buzz in your Gmail account, you'll see the stream of posts from people you're following, and a box for you to post your updates. Here's a run-down of the basic functions:
  • Post some buzz: Click in the text box next to your name, and share what's on your mind.
  • Comment: if you see something in your stream you'd like to comment on, just click the Comment link under that post. Your comment will appear alongside it, and the author of the post will be notified.
  • Like/unlike: If you don't have something in particular you want to say, but you just happen to like someone's post, you can click Like. It will show up on that post that you liked it; if you have a change of heart about something you've liked, you'll see an Unlike link; just click it to remove your name.
  • Reply by chat: Click this link if you'd like to send a Chat message to the author of an update
  • Delete comments: You can delete comments people have posted to your buzz, or comments you've posted.
  • @replies: Write @ in front of someone's username as a way of directing your buzz at that person (it will automatically go to their inbox). You can only use @replies with people who are in your contacts, and other followers won't be able to see the Gmail username.
  • Mute: You can mute buzz that appears in your inbox by enabling keyboard shortcuts and pressing the 'm' key while you're reading it. Muting keeps the update from continuing to appear in your inbox as people reply to it.
  • Link to: Click the down-arrow to the right of a post, and select Link to this buzz. This allows you to send a link to this content
  • Email: Click the down-arrow to the right of a post, and select Email; a new Gmail message will open with the buzz content in the subject and message body.

How to Use Facebook