Sharepoint error when trying to edit a list using the Edit function in Datasheet

If you have installed the 64-bit new version of Microsoft Office, Office 2010, then you will most likely see the following message when trying to edit a SharePoint list using the Edit in datasheet function:

The list cannot be displayed in Datasheet view for one or more of the following reasons:

- A datasheet component compatible with Windows SharePoint Services is not installed.

- Your Web browser does not support ActiveX controls

- Support for AxtiveX controls is disabled

The issue revolves around the fact that 64-bit versions of Office 2010 do not ship with the 32-bit Activex control that would make the datasheet option work with Internet Explorer.

There are ways to make this work, and the usual suggestion is to find a copy of an Office 2007 product and either install it (such as SharePoint Designer 2007) or just choose to install the Windows SharePoint Services components of the product. This works, but I don't really want to go to that much trouble.

Another solution, and the one that I employed, is to install the 2007 Office System Driver: Data Connectivity Components. After installing the Components, go back to the menu and the datasheet option will work great.

Another solution, is to install the 2007 Office System Driver: Data Connectivity Components
<http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-
4598-9B72-EF94E038C891&displaylang=en> . After installing the Components, go back to the menu and the datasheet option will work great.

Excerpts from:
-->
-->

How to lock computer in Remote Desktop Connection?

It is quite easy to do that. Simply create shortcut as follow.

• Right click on the Desktop
• Choose New –>> Shortcuts
• And then in the dialog box type the following

rundll32 user32.dll,LockWorkStation

After that give the shortcut whatever name you like. Next time, when you want to lock your computer, simply double click on that shortcut and it’s all set!!!

---->>

IE Error: This Page Has Been Modified to Prevent Cross Site Scripting

In IE, click Tools -> Internet Options -> Click the Security Tab -> Click the "Custom Level" button -> Scroll towards the bottom until you see "XSS Filter". Click Disable. Click ok, and ok again. You may need to restart your browser. You can always turn it back on by doing these steps again and simply clicking Enable.

More info about this IE Error

The Recycle Bin on C:\ is Corrupted. Do you want to empty the Recycle Bin for this drive?

This worked for WINDOWS 7 Machines.

Go to Command Prompt:

C:\>rd /s c:\$Recycle.Bin
C:\$Recycle.Bin, Are you sure (Y/N)? --> Y (hit enter)
C:\>

then reboot, Windows automatically makes a new empty recycle bin:

for those with other OS's you need to know the name of you recycle bin it could be recycled or recycler check your properties tab for the recyle bin folder for the folder name then go to command prompt and just substitute the correct name

i.e.
C:\>rd /s c:\recycler
C:\recycler, Are you sure (Y/N)? y
or C:\>rd /s c:\recycled
C:\recycled, Are you sure (Y/N)? y

if you type in the wrong name you will get "The system cannot find the file specified."
then you need to go back and find out for sure what your folder name is.

NOTE OF WARNING: if you do this everthing in your recycle bin will be deleted permantly

Network printer is showing offline and is not printing

This issue occurs if the printer spooler is corrupt. Please follow the steps below to reset the spooler.

Reset Spooler

1. Click Start, click Run, type "Services.msc" (without the quotation marks) in the open box and click OK.
2. Double-click "Printer Spooler" in the Services list.
3. Click Stop and click OK.
4. Click Start, click Run, type "%WINDIR%\system32\spool\printers" in the open window, and delete all files in this folder.
5. Click Start, click Run, type "Services.msc" (without the quotation marks) in the open box.

Another possible cause is your security programs. They may block the some ports that you are using to communicate with the printer. I suggest that you temporary disable all of them and then check the result again.

social.technet.microsoft.com

How to Manually Start OST Compaction

Method 1: Microsoft Office Outlook 2007

1. Delete any items that you do not want to keep, and then empty the Deleted Items folder.
2. On the Tools menu, click Account Settings.
3. In the list, select Microsoft Exchange Server, and then click Change.
4. Click More Settings.
5. On the Advanced tab, click Offline Folder File Settings.
6. Click Compact Now.

Method 2: Microsoft Office Outlook 2003 and earlier versions of Outlook

1. On the Tools menu, click to select E-mail Accounts.
2. Click View or change existing e-mail account, and then click Next.
3. Click Microsoft Exchange Server, and then click Change.
4. Click More Settings.
5. On the Advanced tab, click Offline Folder File Settings.
6. Click Compact Now.
7. When the compact operation is finished, click OK twice.
8. Click Next, and then click Finish.

Method 3: Microsoft Office Outlook 2010

1. Delete any items that you do not want to keep, and then empty the Deleted Items folder.
2. Click the File tab on the Ribbon, and then click the Info tab on the menu.
3. Click the Accounts Settings tab, and then click Account Settings again.
4. In the list, select Microsoft Exchange Server, and then click Change.
5. Click More Settings.
6. On the Advanced tab, click Offline Folder File Settings.
7. Click Compact Now.

Microsoft Support

Turn off AutoComplete name suggesting in OUTLOOK

1. On the Tools menu, click Options.
2. On the Preferences tab, click E-mail Options, and then click Advanced E-mail Options.
3. Clear the Suggest names while completing To, Cc, and Bcc fields check box.

How to increase Virtual Memory?

In Windows XP

1. Click Start, and then click Control Panel.
2. Click Performance and Maintenance, and then click System.
3. On the Advanced tab, under Performance, click Settings.
4. On the Advanced tab, under Virtual memory, click Change.
5. Under Drive [Volume Label], click the drive that contains the paging file that you want to change.
6. Under Paging file size for selected drive, click to Custom size check box. You can enter the amount of memory you would like to reserve for Virtual memory by entering the initial and maximum size.
7. Click Set, When you are prompted to restart the computer, click Yes.
   

Special Note: You should choose the same amount for the initial size and maximum size. This will Stop your CPU from constantly changing the paging file.

HOT TIP: To stop your CPU from constantly changing the paging file, set the initial and maximum size to the same value. For example, 500 and 500. The value should be at least 1.5 times more than your physical RAM. If your computer has 512MB of RAM increase the virtual memory paging file to 1.5*512= 768

Recover Permanently(shift - delete) Deleted Mails in MS Outlook

Below is the procedure to recover shift deleted [permanently deleted] mails from Microsoft Outlook.

1. First go to Run and type regedit.
2. Go to the location: \HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\EXCHANGE\CLIENT\OPTIONS registry key.
3. Right click options and add new DWORD VALUE (data type is REG_DWORD) and then right click and rename to DumpsterAlwaysOn. It is case sensitive.
4. Then right click and modify and make the value 1 to turn the Recover Deleted Items menu choice on for all folders or enter 0 to turn it off. [I would recomend 1 for now].
5. Update : When you modify the value, use the "Decimal" option and NOT the "Hexa-Decimal" one.
6. Then go to Outlook , choose "Recover deleted items" option from the Tools Menu to get back your "permanently deleted" mails!

Note: This procedure can recover mails which were deleted by pressing shift+del in the past 4 days only.

jsb.blogspot.som

You do not have access to make the required system configuration modifications...'

Scenario 1: Your account does not have administrator access or are unsure if your account does

Login and install CattleMax from an administrator account on your system. If you are in a networked environment, you may need to contact your network administrator. If you are not in a networked environment, you may try logging in with another account on your system.

Scenario 2: You are logged in with an administrator account

There are inadequate permissions set to the 'HKEY_LOCAL_MACHINE\Software' and the 'HKEY_CLASSES_ROOT\CLSID' registry keys and their subkeys. You will need to modify the permissions for these keys to Allow Full Control for the Administrator, Administrators, and SYSTEM Groups.

Cattlesoft highly recommends the user consult a computer service professional before modifying the registry, as well as backing up the registry before proceeding. While we will help as best as we can, modifying the Windows Registry is done at your own risk and Cattlesoft cannot be held responsible for any mistakes in modifying the registry.

For information on modifying the registry, please visit the Microsoft help article titled "How to Modify the Windows Registry (opens in new window)"

To modify the permissions:
1. Click Start > Run. Type 'regedt32'.
2. Browse to the key/folder to be modified and highlight it.
3. Windows NT and 2000 - Click Security > Permissions.

cattlemac.com

Creating a Personal Folder

To move items from your Outlook mailbox into a personal folder, first create a personal folder:

1. Go to Tools, E-mail Accounts
2. Choose View or Change Existing E-mail accounts, then click Next.
3. Choose New Outlook Data File. A personal folder file will be the only option. Click OK.
4. Choose a location and name for the file then click OK.
5. Click OK again to return to the E-mail accounts window
6. Click Finish to return to the Inbox.

The new Personal Folder will be displayed in your folder list. You can move messages or folders from your Outlook space to your local hard drive or network drive simply by dragging them from the Information Viewer onto the folder. You can add to the Personal Folder at any time in the future.

The Outlook items in the Personal Folder are available to you only when the local drive or network drive is available to you. If you use Outlook from another computer or Outlook Web Access, items in a Personal Folder are not available.

How to install Sql Server Management Studio

SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions for configuring, managing, and administering all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.

Some time it becomes a mystery to install Sql Server Management Studio. Normally you click setup file to install Sql Server 2005 and its components, though you have selected Client Components (Which includes Sql Server Management Studio) to install with other components, but after installation is complete, you can’t find Sql Server Management Studio in installed programs list.

No need to uninstall and re-install your whole Sql Server 2005. Leave the installed components as is and find out SqlRun_Tools setup file to execute, from following path.

Select Change Installed Components ...

Select CLIENT COMPONENTS, install in completly or you can just select Management Tools. What ever you select DON'T forget to select "Entire feature will be installed on local hard drive"

Connect SQL

This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.

Error:
"This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator."

Above error appears everytime you attempt to use hyperlink in an Outlook.

Cause:
This is not an Outlook error. The most common cause is a corrupt registry key in Internet Explorer. The registry key found at
HKEY_Local_Machine\Software\Classes\htmlfile\shell\open\command
is either damaged or corrupt.

Resolution:

1 .To Reset Web settings in Windows XP:

1. Open Internet Explorer.
2. On the Tools menu, click Internet Options.
3. Click the Programs tab, and then click the Reset button.
4. Under Internet programs, verify that the correct e-mail program is selected.
5. Click to select the Internet Explorer should check to see whether it is the default browser check box.
6. Click Apply, and then click OK.

If you are using Vista:

1. Open Internet Explorer.
2. On the Tools menu, click Internet Options.
3. Click the Advanced tab, and then click the Reset button.
4. On the Programs tab, under Internet programs, click Set Programs, then "Set your Default Programs", select your e-mail program and click "Set this program as Default". Repeat for Internet Explorer.
5. Click OK and close the dialogs.

Quit Microsoft Office Excel, restart the mail system, and try again

Problem:
Controls to send mail are missing or disabled or there are errors when you try to mail.

Error:
Quit Microsoft Office Excel, restart the mail system, and try again

Resolution:
Run "Microsoft Office Diagnostics" located in the "Start Menu > All Programs > Microsoft Office > Microsoft Office Tools > Microsoft Office Diagnostics".

Recovering Microsoft Office Outlook messages that have been removed by a hard delete

1. Start the registry editor (regedit.exe).
2. Navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Exchange\Client\Options subkey.
3. From the Edit menu, select New and click DWORD value.
4. Enter the name DumpsterAlwaysOn and press Enter.
5. Double-click the new value and set it to 1. Click OK.
6. Close the registry editor.

Lotus Notes Error: You do not have mail file specified. Use File Mobile Edit Current Location.

Resolution: Check the mail filename and mail file folder in location.

• Click your current location (at your lower right corner).
• Select Edit current.
• Click the mail tab.
• Check the filename. It should be the user’s mail database filename.

Lotus Notes Problem: Can’t forward mails.

Resolution: Check the mail filename and mail file folder in location.

• Click your current location (at your lower right corner).
• Select Edit current.
• Click the mail tab.
• Check the filename. It should be the user’s mail database filename.
  

Slow Lotus Notes performance

Below might help improve notes performance.

• Delete the cache.dsk.
• Unmark subscriptions during startup.
• Check the Lotus Notes Client version.
• Compact the database.

Lotus Notes Error: Invalid disk structure

Resolution: Reinstall the database icon.

1. Go to the Workspace where the database icon is located.
2. Take note of the database’s Server, path location, file name and database name.
3. Delete the database icon.
4. Click File – Database – Open. (Shortcut: Ctrl + o).
5. Select the Server of the database.
6. Go to the folder where the folder is located.
7. Double click the Database name. Database icon will be displayed again on the Workspace.

Lotus Notes Replication

1. Launch the Lotus Notes application. Log in your password.
2. Ensure that the current location is Office.
3. Right click the database you want to replicate (e.g. mail database). Select Replication – New Replica.
4. Configure the settings (Input Database, Server and File Path). Click the More Settings button.
5. The Replication Settings will be displayed. Click the Basics option found on the left side of the window. If you want to set scheduled replication click the Change Schedule button. Follow the settings shown below. Click OK.
6. The Replication Workspace will be displayed. Once the replication is done you may close the window.
7. A new database icon will be displayed on the Workspace.

How to create a location in Lotus Notes

1. Click File – Mobile – Locations.
2. Click the arrow down of New button and select Location.
3. On the Basic tab, type your preferred location name on the Location name field. It can be your name. The Location type field should have Local Area Network value.
4. Click the Servers tab. Type the Notes server of your Mail database. Leave the other fields blank.
5. Click the Mail tab. Type your Mail filename, including the complete path. Type the Mail domain. Other configurations should have same value as shown on the picture below.
6. Click the Save & Close button. Click the X button of your Local Address book.

Setting up Power on Password.

1. Turn on the computer.
2. Press F10, once the F10 Set-up message appears in the lower right corner of the screen.
3. On Setup Utility window, select Security – Power On Password. You will be prompted to enter new power on password. Re-enter the new password.
4. Press F10 to update the changes.
5. Go to File – Save Changes and Exit
6. Confirm the changes made by clicking yes.

Windows is running slow

1. Check if there are is enough free hard disk space. Free hard disk space allows the computer enough room for the swap file to increase in size as well as room for temporary files.

2. Run Scandisk, to check the physical status of the hard disk.

3. Run Disk Defragmenter. This is to arrange data in the best possible order.

4. Remove or disable Startup programs, specifically those that are not really important.

5. If the OS is Win 95 & Win 98, go to MSDOS window
a. Type cd\ to go to C:\> prompt.
b. Type ren autoexec.bat autoexec.ch.
c. Type ren config.sys config ch.
* These commands will rename autoexec.bat and config.sys. It will make sure that the memory is being optimized through Windows.

6. If the OS is Win XP, delete all files in the prefetch directory (C:\Windows\Prefetch). Prefecth permits Windows to load portions of commonly run programs when the computer first loads. This will enable frequently run programs to load faster.

7. Check the CPU, if the processor is not overheating.

8. Reinstall Windows.

Returning to the Last Known Good Configuration

1. If the user encountered a problem after installing new software, or patches, or updates or driver, you can use the Last Known Good Configuration tool to resolve the problem. This will return the last state of the computer before any changes were done.

Procedures on how to use the Last Known Good Configuration tool:

1. Restart the computer.
2. When the results of the POST appear on the user’s screen, press F8 until the Windows Advanced Options menu appears.
3. Select the Last Known Good Configuration option and then press Enter. Windows will restart with the old configuration settings
4. If the restart is unsuccessful, the startup menu option will be displayed again on your screen. Select the Last Known Good Configuration again.
5. If it still doesn’t work, try booting up in a Safe Mode.
6. Use Recovery Console or reinstall Windows if the computer still won’t boot up.

Non-System Disk Error

1. Check if there is a diskette or CD in the startup drive. Remove it if there is any.
2. If the problem still exists, check the hard disk cable.
3. If the hard disk cable connection is ok and the problem still exists, there might be already s problem with the startup files.

How to get the computer name

1. On your Desktop, right click the My Computer icon.
2. Select Properties.
3. On the System Properties, click the Computer Name tab. Click the OK button.

How to add the workstation to the domain

1. After the installation of Windows, the Getting Started with Windows 2000 screen will appear. Uncheck the checkbox of Show this screen at startup. Click Exit.
2. Click Start – Control Panel. Double click the System icon.
3. Click the Network Identification tab. Click the Properties button.
4. Enter the Computer name with the following format -
5. Tick the radio button before Domain. Type the Domain on the Domain box. Click OK
6. The Domain Username and Password dialog box will appear. Enter an account that has a privilege to join the domain. On the Name box, type connect for the \connect password. Click OK.
7. When the message “Welcome to the domain”, the pc is successfully connected to the domain.
8. Click OK. Click the OK button again to close the System Properties window.
9. Click the Yes button to restart the computer.