Export form to different program?

[tsonnenl]

Hi-
I have a corrupt database that I need to get a few forms out of. When I try to open the file, I enter my password and then the file fails to open. Access itself stays open as if I had closed the database window and now no Access files are open. I have not found any information regarding this specific type of corruption, so I'm trying to pull what I need out of it in the mean time.

It does not allow me to import any objects into another Access database, but it does let me import the data into Excel. Is there a program that will allow me to import forms?

Thanks in advance.
Todd

 

[Rolliee]

Have you opened a new mdb and tried to import the forms and data from you old one? That is the first step. It is not an export from the old to the new but an import while in the new from the old.


rollie@bwsys.net

 

[tsonnenl]

Yup. Sorry if that wasn't clear. I can't import the forms from the old DB into a new one. After I browse for the old DB using the import function in the new DB and hit OK, the screen where you choose the objects in the old DB that you want to import never comes up.

However, I noticed that if you open an Excel spreadsheet and use the Get External Data function, the tables and queries do show up and I can import them. I would like to know if there's a program that I can import the forms into in the same way that I was able to import the data into Excel.

 

[Rolliee]

Can you go in the old mdb and save the form?


R

 

[tsonnenl]

I can't get into the old DB at all using Access. The only thing I have gotten to is the data through Excel.

 

[PHV]

Have you tried to launch ms-access in safe mode (/safe command line switche) ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[tsonnenl]

I've never heard of that before, and actually I couldn't find any info on the Safe Mode command line switch at all when I looked for it. I tried just slapping the /safe at the end of the command line anyway, and there appeared to be no change in opening the corrupt db or a working one that I tested it on also.

Is there something else that I'm missing? Where can I find more info on /safe?

Thanks for your help.
Todd