Automation Error the doc file has been corrupted

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

I just tried that and this is what happened. When importing the forms I received the same error as above. Then a message came up saying "name conflicts with another module, project or library".
When importing the reports it said could not start transaction too many transactions already nested"
Any ideas?

Try to import the tables and queries first,
then the modules,
then the forms,
and last the reports.
Do simple testing after each import to isolate where the problem is coming from

Right, I'd try to set up one db for the tables and queries, one for forms, one for reports and one for modules

then finally once you get them all there import from those to a final blank db.

ASKER

I have imported the queries. All OK
I tried importing the forms and have three that give me the error "name conflicts with another module, project or library". How do I trouble shoot them?

ASKER

I set up one db for all items as suggested above. When importing those items into a new db I can get all in. When I try to import the forms I get the following errors: Microsoft Visual Basic error acessing File Network connwction may have been lost. The I get the original error "name conflicts with another module, project or library". As for the network connection I have all the files on my desktop there is no network connection. I do have archived versions of the database. Is there a protion that I can try importing from an old db that way fix list problem.

Yes it sounds like the forms are corrupt. If you can replace the three that are giving you an error message from a backup then you're in good shape.

Create Another blank db
Import all the three forms that gives problem.
then import the modules.
These will give an error, I presume
Open the VBA window
Debug> compile
This should point us to the conflict.

ASKER

Capricorn1,
When I import the form before I have imported module it immediately says I have a conflict. Is that possible. To have a conflict when the db is bloank and I have only added 1 form. I unfortunately have no programming training and have just learned what you guys tell me. So, I appologize for my lack of knowledge and thank you all for your help.

I'm getting curious myself of what is happening or what happened to that form.

btw. On the new db with one form, open vba window
Debug>compile
see what error we will get

I think it's safe to say that the form is just corrupt. Tracking down the specific corruption probably isn't productive. Grab the form from a backup! If there is no backup there are companies that specialize in access repair.

ASKER

When I attempt to import the form that is bad it gives me the automation error then does not import it. When I tried importing an archived form into the existing database I have the same problem. I tried importing the archived formula into a blanck db and tried compiling it gives me the network error.

I think where we left this your form was corrupt and I suggested restoring it from your backup db. Any luck with that?

ASKER

Long story short I went far enough back in backups and got it resolved. I think what happened was there was a point where my computer was losing connection with the server where the db is stored and I think it was corrupted then. I think the visual basic project resource was bad? I also dumped the switchboard manager because it was causing problems. The only other change is we changed to server 03 and I don't know if there are any bugs there. Regardless it apears to be stable at this time. Thanks Jim

Can I split the points? to Capricorn1 & kmslogic?

You sure can!

Thank you!