Help - corrupted file

  • Thread starter Thread starter mscertified
  • Start date Start date
M

mscertified

I have been working on this Access DB since early this morning and now
somehow the file has become corrupted. I cannot run a compact and repair. I
ran Jetcomp and it created a new file but the corruption is still there. I
cannot export or import the modules to a new database. I have a backup but it
ran several hours ago and I've made lots of changes since then. It will take
me hours to recreate the changes. I've mainly been changing a form and a
report. I can see both in design view but cannot get to the code which is
what I need to do a cut and paste. Is there any way to display the code so at
least I can copy the changed sections?????
 
I have been working on this Access DB since early this morning and now
somehow the file has become corrupted. I cannot run a compact and repair. I
ran Jetcomp and it created a new file but the corruption is still there. I
cannot export or import the modules to a new database. I have a backup but it
ran several hours ago and I've made lots of changes since then. It will take
me hours to recreate the changes. I've mainly been changing a form and a
report. I can see both in design view but cannot get to the code which is
what I need to do a cut and paste. Is there any way to display the code so at
least I can copy the changed sections?????
Click to expand...

You can *try* creating a new database and using File... Get External Data...
Import to import whatever is salvagable. Also see the resources listed at
Tony's corruption FAQ:
http://www.granite.ab.ca/access/corruptmdbs.htm

You're lucky you *HAVE* a backup... lots of folks learn that lesson too late!
I wish I could be more encouraging, but if the VBA is corrupt (as is likely)
you're not going to have much chance of getting it back.

John W. Vinson [MVP]
 
cutting and pasteing subsets of tables can often get you most of a bad table
when importing won't work.

If your logical about it you can often zero in on just a few bad records
:)
 
Hi -

You might try the *undocumented* SaveAsText feature, which saves the
description of a msaccess object (including all code) to a standard text file:


saveastext acForm ,"FormName", "TextFileName"

There is an equivalent command to import an object from a text file; but I
forget what it is, since I never use it.

Why MS does not document this is beyond me.

John
 
mscertified said:
I have been working on this Access DB since early this morning and now
somehow the file has become corrupted. I cannot run a compact and
repair. I
ran Jetcomp and it created a new file but the corruption is still
there. I
cannot export or import the modules to a new database. I have a backup
but it
ran several hours ago and I've made lots of changes since then. It
will take
me hours to recreate the changes. I've mainly been changing a form and
a
report. I can see both in design view but cannot get to the code which
is
what I need to do a cut and paste. Is there any way to display the
code so at
least I can copy the changed sections?????
Click to expand...


Try this:

1. Open the database and import a different, working form (with code
behind it) into the database.

2. Run that form.
3. While its running, Hit Ctl-Brk (to break into the code).
4. Click on the Debug button.
5. Click on the Project Explorer icon under the top menu.
6. In the left side Project Explorer pane, Select the corrupt
form/report to view its code.
7. On the top menu, Click Debug-> Compile.
8. Close and save the form/report.
9. Close and reopen the database.



Then run that form and while its running, hit Ctl-Brk.
Hit the Debug button.
Go into Project Explorer
go into

--
 
mscertified said:
I have been working on this Access DB since early this morning and now
somehow the file has become corrupted. I cannot run a compact and
repair. I
ran Jetcomp and it created a new file but the corruption is still
there. I
cannot export or import the modules to a new database. I have a backup
but it
ran several hours ago and I've made lots of changes since then. It
will take
me hours to recreate the changes. I've mainly been changing a form and
a
report. I can see both in design view but cannot get to the code which
is
what I need to do a cut and paste. Is there any way to display the
code so at
least I can copy the changed sections?????
Click to expand...


Try this:

1. Open the database and import a different, working form (with code
behind it) into the database.

2. Run that form.
3. While its running, Hit Ctl-Brk (to break into the code).
4. Click on the Debug button.
5. Click on the Project Explorer icon under the top menu.
6. In the left side Project Explorer pane, Select the corrupt
form/report to view its code.
7. On the top menu, Click Debug-> Compile.
8. Close and save the form/report.
9. Close and reopen the database.

Sorry for the repost - previous post had some garbage on the end.



--
 
Back
Top