Microsoft Utility Database Mac

-->

2006-12-12  When a database is corrupt or damaged, data can be restored from backup or repaired using Eseutil. Eseutil is a command line utility that works with Extensible Storage Engine (ESE), database (.edb) files, streaming (.stm) files, and log (.log) files associated with. Then, long press the Option key & start the Mac Outlook 2011 application or open the Application Folder. Microsoft powerpoint error on mac. After that, click on the Microsoft Office 2011 then double-click on the Microsoft Database Utility app. Now, select the Database & click on Rebuild option.

Summary

This article describes some useful tools for Microsoft Outlook for Mac.

More information

Outlook Search Repair

The Outlook Search Repair tool repairs search results within Outlook.

Important

Due to some changes in macOS Mojave, this tool no longer works in 10.14 and higher. If you are on macOS Mojave (10.14), you can follow the steps below to reindex Spotlight for Outlook for Mac.

  1. Choose Apple menu, then System Preferences, and then Spotlight.

  2. Select the Privacy tab.

  3. In Finder:

    1. On the Go menu, select Go to Folder..

    2. Copy and paste the following location into the 'Go to the folder:' dialog box and select Go:

      ~/Library/Group Containers/UBF8T346G9.Office/Outlook/Outlook 15 Profiles/

  4. Drag the 'Main Profile' folder to the Privacy tab. Once added, remove the folder, and Spotlight will re-index the folder.

    You must perform this step for any additional profile folders you have.

See the following article from Apple to learn more: How to rebuild the Spotlight index on your Mac.

When to use the tool

Use this tool if search results within Outlook show nothing or return older items only. For example, if you search for an email message that you already have open and that message isn't displayed in the search results.

How to use the tool

  1. Download and open the Outlook Search Repair tool.

  2. Follow the instructions.

    Note The tool searches for duplicate installations of Outlook. If no duplicates are detected, go to step 3. If duplicates are detected, remove the duplicate Outlook installations, and then restart the system. After your system is restarted, the Outlook Search Repair tool may reopen. If it does reopen, exit and restart the tool.

  3. Select Reindex.

    Note The Outlook Search Repair tool displays a 'Reindexing, please wait' message while it works. Wait for this process to finish. This may require an hour or more, depending on the size of your Outlook profile. Outlook doesn't have to be open when the repair occurs. A spotlight search will be slower and may not finish while the index is being repaired.

  4. Exit the Outlook Search Repair tool when you receive the following message after the repair is completed:

    Done! Reindexing has completed!

OutlookResetPreferences

The Outlook Reset Preferences tool resets all Outlook preferences to their default settings.

When to use the tool

Use this tool to reset any customizations that you've made to Outlook by using the Preferences option on the Outlook menu. This tool also stores the settings for the Outlook window size and position. This tool shouldn't be needed most of the time. But it can be useful.

Note The Outlook Preferences file doesn't contain all the preferences for the application. Also, resetting Outlook preferences doesn't remove email messages or account settings.

How to use the tool

  1. Download and open the Outlook Reset Preferences tool.
  2. Click the Reset Now! button. This closes Outlook if it's open, and then resets the preferences to their default settings.
  3. Exit the Outlook Reset Preferences tool.

SetDefaultMailApp

The Default Mail Application tool lets you easily make Outlook the default mail application.

When to use the tool

Use this tool if you want Outlook to open a new email message when you click a mailto: link in an email message or on a website. Selecting a mailto: link opens the default email application. Outlook isn't the default email application until you change that setting.

How to use the tool

  1. Download and open the Default Mail Application tool.
  2. In the Default Mail Application dialog box, select com.microsoft.outlook, and then click Make Default.
  3. Exit the Default Mail Application tool.

ResetRecentAddresses

The Reset Recent Addresses tool lets you reset recent addresses that Outlook stores. This tool deletes all recent addresses instead of you having to manually delete addresses one at a time.

When to use the tool

When you compose an email message and add people on the To, Cc, or Bcc line, Outlook suggests names as you type characters. The list of names that Outlook uses is a combination of stored contacts, the company directory, and recent contacts. Recent contacts have an 'X' character next to each name. Without this tool, you have to click the 'X' on each contact to remove that contact from the Recent Address List. The Reset Recent Addresses tool cleans out all recent addresses at the same time.

How to use the tool

  1. Download and open the ResetRecentAddresses tool.
  2. Click the Reset Now! button.
  3. Exit the Reset Outlook Recent Addresses tool.
-->

The bcp utility is available in the Microsoft ODBC Driver for SQL Server on Linux and macOS. This page documents the differences from the Windows version of bcp.

  • The field terminator is a tab ('t').

  • The line terminator is a newline ('n').

  • Character mode is the preferred format for bcp format files and data files that do not contain extended characters.

Note

A backslash ' on a command-line argument must either be quoted or escaped. For example, to specify a newline as a custom row terminator, you must use one of the following mechanisms:

  • -rn
  • -r'n'
  • -r'n'

The following is a sample command invocation of bcp to copy table rows to a text file:

Available Options

In the current release, the following syntax and options are available:

[database.]schema.tableindata_fileoutdata_file

  • -a packet_size
    Specifies the number of bytes, per network packet, sent to and from the server.

  • -b batch_size
    Specifies the number of rows per batch of imported data.

  • -c
    Uses a character data type.

  • -d database_name
    Specifies the database to connect to.

  • -D
    Causes the value passed to the bcp -S option to be interpreted as a data source name (DSN). For more information, see 'DSN Support in sqlcmd and bcp' in Connecting with sqlcmd.

  • -e error_fileSpecifies the full path of an error file used to store any rows that the bcp utility cannot transfer from the file to the database.

  • -E
    Uses an identity value or values in the imported data file for the identity column.

  • -f format_file
    Specifies the full path of a format file.

  • -F first_row
    Specifies the number of the first row to export from a table or import from a data file.

  • -k
    Specifies that empty columns should retain a null value during the operation, rather than have any default values for the columns inserted.

  • -l
    Specifies a login timeout. The -l option specifies the number of seconds before a login to SQL Server times out when you try to connect to a server. The default login timeout is 15 seconds. The login timeout must be a number between 0 and 65534. If the value supplied is not numeric or does not fall into that range, bcp generates an error message. A value of 0 specifies an infinite timeout.

  • -L last_row
    Specifies the number of the last row to export from a table or import from a data file.

  • -m max_errors
    Specifies the maximum number of syntax errors that can occur before the bcp operation is cancelled.

  • -n
    Uses the native (database) data types of the data to perform the bulk-copy operation.

  • -P password
    Specifies the password for the login ID.

    Mar 23, 2020  Microsoft PowerPoint 16.35 for Mac can be downloaded from our software library for free. The actual developer of this Mac application is Microsoft. The unique identifier for this app's bundle is com.microsoft.Powerpoint. The most popular versions of Microsoft PowerPoint for Mac. Jan 25, 2019  Download Microsoft PowerPoint for macOS 10.13 or later and enjoy it on your Mac. ‎A qualifying Office 365 subscription is required for Word, Excel, PowerPoint and Outlook. The PowerPoint app gives you access to the familiar tool you already know. Microsoft powerpoint 2015 free download - PowerPoint, Microsoft Office PowerPoint 2010, Microsoft PowerPoint, and many more programs. Microsoft powerpoint free download for mac 2015. Microsoft powerpoint 2015 free download - Microsoft Office PowerPoint 2010, Microsoft PowerPoint, Microsoft PowerPoint 2013, and many more programs.

  • -q
    Executes the SET QUOTED_IDENTIFIERS ON statement in the connection between the bcp utility and an instance of SQL Server.

  • -r row_terminator
    Specifies the row terminator.

  • -R
    Specifies that currency, date, and time data is bulk copied into SQL Server using the regional format defined for the locale setting of the client computer.

  • -S server
    Specifies the name of the SQL Server instance to connect to, or if -D is used, a DSN.

  • -t field_terminator
    Specifies the field terminator.

  • -T
    Specifies that the bcp utility connect to SQL Server with a trusted connection (integrated security).

  • -U login_id
    Specifies the login ID used to connect to SQL Server.

  • -v
    Reports the bcp utility version number and copyright.

  • -w
    Uses Unicode characters to perform the bulk copy operation.

In this release, Latin-1 and UTF-16 characters are supported.

Mac Microsoft Database Utility Location

Unavailable Options

In the current release, the following syntax and options are not available:

  • -C
    Specifies the code page of the data in the data file.

  • -h hint
    Specifies the hint or hints used during a bulk import of data into a table or view.

  • -i input_file
    Specifies the name of a response file.

  • -N
    Uses the native (database) data types of the data for noncharacter data, and Unicode characters for character data.

  • -o output_file
    Specifies the name of a file that receives output redirected from the command prompt.

  • -V (80 90 100)
    Uses data types from an earlier version of SQL Server.

  • -x
    Used with the format and -f format_file options, generates an XML-based format file instead of the default non-XML format file.

Microsoft Utility Database Mac Os

See Also