You cannot send an Access database table as an XML attachment (280894)


The information in this article applies to:

  • Microsoft Outlook 2002
  • Microsoft Access 2002
This article was previously published under Q280894

SYMPTOMS

When you try to send a Microsoft Access database table (.mdb) as an .XML format attachment by clicking Send To on the File menu in Access, you may receive the following error message:
Microsoft Access Can't Send this format in a Mail Message.

WORKAROUND

To work around this behavior, export the database table (.mdb) file as an XML document (.xml) file to your local system and attach it to a new message.

How to Export the Access Database to an .XML Format

  1. In Access, select the database table that you want to format to .XML.
  2. On the File menu, click Export.
  3. Select the location to which you want to export the file on your local system, and then type a descriptive name for the file.
  4. In the Save as type box, click XML Documents, and then click Export.

How to Attach the .XML File to a Message

  1. Start Outlook.
  2. Click New Mail Message.
  3. On the Insert menu, click File, locate and click the .xml file that you saved in the previous steps, and then click Insert.
This attaches the .xml file to your message in a form that can be sent.

MORE INFORMATION

The .mdb file name extension is considered an "unsafe" extension and is inaccessible because of the Outlook security features.
Modification Type:MinorLast Reviewed:10/7/2004
Keywords:kbExport kbtshoot kberrmsg kbpending kbprb KB280894
©2004 Microsoft Corporation. All rights reserved.