Results 1 to 8 of 8
  1. #1
    sbrooks1763 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    5

    just getting started

    I have just started creating a new database in 2007 version. I am trying to establish relationship between two tables but the relationship button is faded and doesn't allow me access. So far, I haven't figured out how to make this control functional. Any ideas?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    No, never ran into that. Do you want to provide the project for analysis?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    sbrooks1763 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2011
    Posts
    5
    Being as I am new to Access (at least the later versions), I am also new to this forum. If I wanted to submit for analysis, how would I go about it?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    The Attachment Manager is below the Advanced editor window. Click Go Advanced below the Quick Reply window to open that editor.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    sbrooks1763 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2011
    Posts
    5
    It says my file is too large, even though I only have 3 small tables so far

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    Did you run Compact & Repair? If still large try zipping, up to 2mb zip allowed. I can open only Windows Compression zip.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    sbrooks1763 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2011
    Posts
    5

    here tis

    You are quite good at this.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,944
    I opened your project and the Relationships button is available. I see two tables in the Relationships builder with a link. Can't replicate your issue. Exactly what were you doing when the Relationship button appeared not available?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 5
    Last Post: 08-26-2011, 04:05 AM
  2. how to get started
    By scottsoo9 in forum Access
    Replies: 1
    Last Post: 11-18-2009, 04:13 PM

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