Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Strange table names (xp/2003)

    I have a table that is named "Main Names (all)" (Do Not ask why !![img]/forums/images/smilies/sad.gif[/img] ). It is the basis for a main form, but when I try to link a subform based on another table that has the ID of that darn table in it as a FK, I get a message "Automation Error no object Main Names (all)". Are the Parentheses throwing it off? If so is there a way I can globally rename that table?
    Thanks
    Zave Rudman

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Strange table names (xp/2003)

    I don't think the parentheses cause the problem. As a test, I created a table named "Main Names (all)" and another table linked to its primary key. I could create a main form / subform based on this setup without getting an error message.

    BTW, the excellent add-in Find and Replace lets you change the name of items throughout the database; you can download a free trial version.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Strange table names (xp/2003)

    Any other ideas what could be causing that? If not I will post a stripped down version to see if anyone can help
    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Strange table names (xp/2003)

    I think we'd need to see a stripped down copy of the database.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Strange table names (xp/2003)

    Here is the stripped down version
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Strange table names (xp/2003)

    1) The record source of the main form contains two fields named ID. This causes ambiguity.
    2) You had linked the subform on the ID field from Misc details instead of the ID field from Main names (all).
    See attached version.

    BTW, why do you have these two tables? They have a 1-to-1 relationship, so it would be much easier to use one table.
    Attached Files Attached Files

  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Strange table names (xp/2003)

    The reason there are two tables goes back to prehistoric times when this was written in Access 2.0 and not everyone in the main table has a record in the misc details, so this was to save space in other forms.
    It was linked to the ID details in misc details table, since I was trying anything to get this to work, but what you pointed is obvious as usual.
    Thanks Again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •