Results 1 to 5 of 5
  1. #1
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124

    How to Delete a Relationship in Microsoft Access

    I have a file mdb: http://www.mediafire.com/?l3qf5klijkubkpe
    Logon: admin/admin

    In the table: T_HangHoa
    I want to change Indexed (Yes (No Duplicates) to No) but can't
    http://www.mediafire.com/view/?5duw2zq3a7pgdq6#

    It have problem below:
    http://www.mediafire.com/view/?on2nt1u4x6wb8am#

    I selected Primary Key and remove but can't
    http://www.mediafire.com/view/?44d9jbfp5rmin3h#
    http://www.mediafire.com/view/?3w9dv2s9koh8adk#

    Could you help to fix

    Many thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Go to the relationships window (in acc2003 it is Tools-->Relationships)
    Select(click) the relationship you want, you'll get an option to delete/remove.

  3. #3
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    I'm using MS Access 2007
    Could you help to fix my file in the link below?
    http://www.mediafire.com/?l3qf5klijkubkpe
    Many thanks

  4. #4
    uronmapu is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2012
    Posts
    124
    Description error detail
    My file: http://www.mediafire.com/?g09b648dhv5q9ii
    Run file , Select Hóa Đơn

    Choose DaTH,

    Type info, It will have problem below
    Image has been scaled down 5% (800x197). Click this bar to view original image (836x205). Click image to open in new window.



    I tryed to fix:

    Select Table T_HangHoa

    Changge Indexed from Yes to No but can't, error
    Image has been scaled down 4% (800x230). Click this bar to view original image (831x238). Click image to open in new window.


    I try to delete primary key, but can't


    Please advices

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 08-29-2012, 11:00 AM
  2. Replies: 1
    Last Post: 09-13-2011, 01:52 PM
  3. Replies: 0
    Last Post: 10-13-2010, 03:28 PM
  4. Replies: 1
    Last Post: 06-20-2010, 05:04 AM
  5. Replies: 0
    Last Post: 12-31-2007, 11:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums