Two possible methods;
1. Compact and repair the db into a new db instance by opening Access. Go to
the tools and then compact and repair the old db to a new db.
2. import all of the old objects into a new db instance and then try
repairing.
2a. Import each object one at a time to find the offending object, or simply
exclude the object you were working on when the db crashed.
Commerical tools exist to fix the db as well, but they have a tendency to
remove all of the keys and indexes from your native tables.
TJ
--- bitschon <[EMAIL PROTECTED]> wrote:
> I'm beginning to have my doubdt about accsess
>
> In the middle of doing some VBA, it crashed. When I reopen, I get
> messages that I have to compact/repair the DB. When I try to, it tries
> to open a report and flashes the warning message at me, never letting
> me actually do the repair
>
> Is it possible to do something else to fix this?
>
> Very important...
>
> Thanks
> John
>
>
>
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
