Report is not displayed, but still exists? 1

[handlebars]

I have tried exporting a report to a database and I have ended up without a visable report, although it does seem to exist (ie I cannot rename another report to that name)!.

Does anyone know a workaround to this?

Andrew

 

[RoyVidar]

Sounds like some kind of corruption. If so I would try the /decompile option (see Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times for step by step instructions)

If that doesn't solve it, I'd try creating a new database, and import everything to that.

Roy-Vidar

 

[handlebars]

Thanks for your reply roy, what i have noticed is that when the db is opened the initial vba error is module not found. This is only when opening the main form - i have tried cutting all code from this form and opening, but the same error occurs.

Not really sure what is going wrong (I was making some changes by exporting objects from another copy of the database into the live system (not good housekeeping!).

I ended up taking your advice and importing all the tables from the live db into the copy that i was working on, but still would be interested if this is in anyway related to the above issue with the mysterious report.

Thinking back, my copy hung when importing the report (so maybe it was deleted, before imported object was formed in the new db.