Results 1 to 7 of 7

Thread: MS Access 2003

  1. #1
    Join Date
    Jul 2009
    Posts
    28

    Question Unanswered: MS Access 2003

    I have a rogue table which I cannot get rid of.
    If I right click on it, and select Open or Design View or Delete or Rename,
    I get “Microsoft Office Access has encountered a problem and needs to close”.
    I could just ignore it, but I need to use the name of the table when exporting.
    Are there any tricks that I can employ to remove it ?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Try:
    1) Backup
    2)
    Code:
    DROP TABLE myTable
    in a query and run
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2009
    Posts
    28

    Red face MS Access 2003

    Thanks for the suggestion pootle flump.
    Unfortunately, I get the same “Microsoft Office Access has encountered a problem and needs to close” message when I run the delete command, and the table is not deleted.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    If I asked you to enumerate the tables in DAO would you know what I mean? If I asked you if you have decompiled the application, would you know what I mean?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jul 2009
    Posts
    28

    MS Access 2003

    I am afraid I am new to this software, and am not aware of either of your entities.

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    On a copy of the database do a compact and repair then follow this link:
    Decompile or how to reduce MDB/MDE size and increase startup performance

    Sometimes corruptions can be sorted out with these processes. Often not.

    Another low tech fix people often use is to create a new, blank database and import all the objects you want to retain in to it.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Jul 2009
    Posts
    28

    compact and repair

    Thanks Pootle Flump.
    It'll be tomorrow morning before I can try this.
    Many thanks for your continuing assistance.

Posting Permissions

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