Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Corrupted Access (Access2000-03)

    While creating Reports I had raninto the issue.
    All of a sudden I needed to make simple change to the Report like altering a Title (label).
    It would not save. It would not close. I had to crush out of it and when re-opened - changes weren't saved.

    After struggling a few times I had imported Report from another backup mdb and made changes and tried to save it with correct name and it wouldn't let me overwrite old Report so I saved it with 1 at the end.
    Today I wanted to remove 1 (old one was deleted) and it wouldn't let me.
    Then I opened and saved as Original Name.

    I am affraid this mdb is got corrupted.
    How can I preserve my work (it is a ton of queries and Reports) - should I import it into another mdb?

    Thanks

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

    Re: Corrupted Access (Access2000-03)

    Yes, you should create a blank new database and import as many database objects (tables, etc.) from the problem database into the new one.
    Then set the startup options in Tools | Startup... as in the old database.
    Also, activate the Visual Basic Editor and make sure that the same references are set in Tools | References...

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupted Access (Access2000-03)

    I did thanks!
    But it is a bummer that Properties like numbers of the Queries ant such is not imported.
    Now I have to re-number 25 queries per Report!
    Is there way to re-import with Property numbers? It is very important!

    Thanks

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

    Re: Corrupted Access (Access2000-03)

    What do you mean by "numbers of the Queries"?

Posting Permissions

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