Relationship view crashes DB - Access 2007

[Jeff]

I've built a moderately complex table relationship using Access 2007
and back-saving to 2003; my partner on the project has made edits in
Access 2003. Today I was unable to open Relationship view using 2007
- crashed the database, prompting to "restart and rebuild" after the
crash.

Tried:
- saving as 2007 (*.accdb)
- compact and repair (using both 2003 and 2007)
- removing all "subdatasheet" relationships

Still getting the crash.

Looks like this weekend's project is to export and rebuild the tables
and queries very carefully, but I'd love to hear your tips in the
meantime!

Regards,
Jeff

[lyle fairfield]

In most cases running the code found at
http://www.ffdba.com/downloads/Save_...ts_As_Text.dat
will either
1. create an error-free copy of the mdb
or
2. crash with a debug window that clearly identifies the offending
code or object.

In addition it should create the smallest possible copy of your mdb.

Doing so should take 47 hours 55 minutes less than a weekend.

On Oct 23, 6:48*pm, Jeff <[e-mail]:

I've built a moderately complex table relationship using Access 2007
and back-saving to 2003; my partner on the project has made edits in
Access 2003. *Today I was unable to open Relationship view using 2007
- crashed the database, prompting to "restart and rebuild" after the
crash.

Tried:
*- saving as 2007 (*.accdb)
*- compact and repair (using both 2003 and 2007)
*- removing all "subdatasheet" relationships

Still getting the crash.

Looks like this weekend's project is to export and rebuild the tables
and queries very carefully, but I'd love to hear your tips in the
meantime!

Regards,
Jeff