Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I change Access file extensions from MDP to e.g., aaa

Discussion in 'Information Technology' started by garyf, Nov 10, 2005.

  1. garyf

    garyf
    Expand Collapse
    Guest

    I want to e-mail an access file to another computer which has security
    settings preventing its being received by Outlook. If I can change the MDP
    file extension to something like "aaa" it should go through. The file
    extension can then be changed back by the recipent to MDP. Question, how and
    I change the extension. Using rename doesn't seem to allow me to change the
    extension.
     
  2. Loading...


  3. Mr B

    Mr B
    Expand Collapse
    Guest

    I will assume that you are attempting to rename the file from the Windows
    Explorer. It sounds as if you are not seeing the extensions.

    Try this: From the Tools menu, select the "Folder Options" option. Then
    select the "View" tab. Locate a check box for the "Hide file extensions for
    known file types" option and uncheck this check box.

    You should now be able to see and change the file extension.

    --
    HTH

    Mr B


    "garyf" wrote:

    > I want to e-mail an access file to another computer which has security
    > settings preventing its being received by Outlook. If I can change the MDP
    > file extension to something like "aaa" it should go through. The file
    > extension can then be changed back by the recipent to MDP. Question, how and
    > I change the extension. Using rename doesn't seem to allow me to change the
    > extension.
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    I think the keyword you are looking for is Name (not Rename). Try the
    following line of code:

    Name "C:\My.mdb" As "C:\My.aaa"
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access


    "garyf" wrote:

    > I want to e-mail an access file to another computer which has security
    > settings preventing its being received by Outlook. If I can change the MDP
    > file extension to something like "aaa" it should go through. The file
    > extension can then be changed back by the recipent to MDP. Question, how and
    > I change the extension. Using rename doesn't seem to allow me to change the
    > extension.
     

Share This Page