Access 2002 Hangs up when trying to view code

  • Thread starter Thread starter tomolson7
  • Start date Start date
T

tomolson7

Have created a MDB project with plenty of code behind the
forms. All of a sudden I cannot view the code. The
application hangs upon trying to go into the code.

Project runs, but cannot upgrade or look at the code.

Using Windows XP Pro.

Even tried deleting last form built, but no success.
 
Does this happen with all databases, or just the one?

If all, reinstall Access.

If just one, try this:

1. Make a backup of your mdb file while it is not in use, and without
over-writing previous backups.

2. From the Tools menu | Database Utilities, choose Compact.

3. Close Access, and decompile your database by entering something like this
at the command line. It's one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\My Documents\MyDatabase.mdb"

4. Compact the database again (to remove the previous compilation).

5. Create a new (blank) database database. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.
More info on Name AutoCorrect problems:
http://allenbrowne.com/bug-03.html

6. Press Ctrl+G to open the Immediate window. Choose References from the
Tools menu. Uncheck the references you do not need. More info on references:
http://allenbrowne.com/ser-38.html

7. Import the objects from the problem database: File | Get External |
Import.

You find that some forms cannot be imported at step 7. However, you should
find you can resuscitate most of the database, and it may be possible to
import the problem one(s) from an older backup.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Back
Top