Crashing: Sudden & Wierd

Rather a long saga.

I recently converted an Access 97 db to 2003. The FE links in tables from db1 & db2. All was working fine. Then, out of the blue (about an hour before I was due to give a demo), I opened the FE and it crashed. All the usual things - decompile, importing, etc, did not help. I retrieved a backup from a few days back and, to my surprise, the same thing happened. Took a backup from a month ago and - same thing.

So it wasn't the FE. Must be the data. I took two '97 version copies of db1 & db2, converted them - still crashed. (Same thing happens on a second PC.)

The crash *seems* to be caused by any combo control. When its rowsource is a *saved query* which is a join between two certain tables, then it crashes. When I paste the same sql statement directly into the rowsource, it doesn't cause any problems.

In a test database, I recreated the two tables (copying & pasting the fields wasn't good enough) and that seemed to fix the problem. However my db has about 50 tables and I'd rather not have to re-create them all.

When I try importing the objects from my original 97 database into a new 2003 database, it crashed as well. If I delete the linked tables first and then try to import, it succeeds.

In short, I'm rather stuck. There seems to be some data-related problem. I do finally have a working version, but there is a problem somewhere and I don't want this happening once again.

Does anyone have any suggestions?
--
Zippy S
.

Relevant Pages

  • Re: Microsoft vs Mac
    ... Database of Doom. ... I had problems with Enrage X and Enrage 2004 using databases considerably ... the database from the nightly backup, checked the system with Disk Utility ... And after it crashes its database is unreadable, ...
    (comp.sys.mac.apps)
  • Access crashes on load
    ... Whenever I try to open a database I've been working in, it prompts me to save ... it crashes with the error "Microsoft Office ... If I cancel saving the backup and try to open the database I get the same ...
    (microsoft.public.access.adp.sqlserver)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)