access2003 error opening a form

D

disc

Recently upgraded office2000 to office2003 when opening 1 database receive
msg 'an error occured while loading "form..." do you want to continue loading
the project ?'. Have successfully converted 4 other databases no problems
(all databases linked). Current service packs are WIN XP (2), Office 2003 (1)
and Jet 4.0 (8). Help needed !
 
A

Allen Browne

The database is partially corrupt.

Using Access 2000, decompile a copy of the database by entering something
like this at the command prompt while Access is not running. It is all one
line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then compact the database.

Now try these steps to build it in Access 2003:
1. Create a new (blank) database:
File | New

2. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

3. Set the minimal references you need:
Ctrl+G to open the Immediate window.
Tools | References
More info on typical references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

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

Check that the application compiles. If necessary, skip the bad form. You
may even be able to import it from an older copy of the database.
 
D

disc

Failed at stage 4 - when importing from database gives same msg "an error
occured while loading 'form...' Do you want to continue...' if I press 'No'
gives msg 'the visual basic for applications project in the database is
corrupt'
 
A

Allen Browne

Are you able to import all the other database object, e.g. all tables and
queries, and perhaps the other forms and reports?

If so, could you then import that failed form form anold back up?

If not, are you able to make a new (blank) database using Access 2000,
import everything into that, and then upgrade this copy?
 
Top