By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,400 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Relationship view crashes DB - Access 2007

P: n/a
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
Oct 23 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 <jnorvi...@gmail.comwrote:
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
Oct 24 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.