&Relationships Bug - workaround

[Ray Watson]

ACCESS 2000

Just a quick note to leave for future developers.
This problem has been well documented in previous posts, but this little
trick may help future poor souls.

The error is when you try to import a database. I have learned that it is
possible to cure corruption of databases by creating a new mdb, and
importing all the objects from the misbehaving mdb into it.

However, a problem can occur when doing the import process, the current
object name being imported, gets "stuck" at an object called &Relationships.

It hangs , and when you 'break', you find that no forms have been imported,
and you cannot import any forms. If you have just done a days work, and you
find none of your forms is accessible, its a bit disheartening to say the
least.

In a desparate attempt not to have to re-work an extra day, I went back to
the original (corrupt) mdb. I opened each form in design view, and saved it
again under another name. I then found, that I could import the re-saved
forms, without the error occurring.

For what its worth, after 6 years of access development, this is the last
major project I am going to do in Access. I have had so many stupid
corruptions, slow operations, bugs, workarounds, that I am investigating
either VB.net or Delphi as my development environment. I have already gone
exclusively to MS-SQL as a back end, that cured many of the miseries
associated with using mdb's as data repositories. Despite some comments to
the contrary I have read, ADODB, in conjunction with Stored procedures has
ben an inherently reliable and speedy solution for me. I am not here to
justify my opinion or defend my point of view, but if anyone else finds
themselves in the same boat, just know you are not alone!

[Wayne Morgan]

Thank you for the information. Could part of the problem have been
associated with this?

http://support.microsoft.com/kb/304548/
--
Wayne Morgan
MS Access MVP
"Ray Watson" <rw*****@oztell.com> wrote in message
news:df**********@nnrp.waia.asn.au...

ACCESS 2000

Just a quick note to leave for future developers.
This problem has been well documented in previous posts, but this little
trick may help future poor souls.

The error is when you try to import a database. I have learned that it is
possible to cure corruption of databases by creating a new mdb, and
importing all the objects from the misbehaving mdb into it.

However, a problem can occur when doing the import process, the current
object name being imported, gets "stuck" at an object called
&Relationships.

It hangs , and when you 'break', you find that no forms have been
imported,
and you cannot import any forms. If you have just done a days work, and
you
find none of your forms is accessible, its a bit disheartening to say the
least.

In a desparate attempt not to have to re-work an extra day, I went back to
the original (corrupt) mdb. I opened each form in design view, and saved
it
again under another name. I then found, that I could import the re-saved
forms, without the error occurring.

For what its worth, after 6 years of access development, this is the last
major project I am going to do in Access. I have had so many stupid
corruptions, slow operations, bugs, workarounds, that I am investigating
either VB.net or Delphi as my development environment. I have already gone
exclusively to MS-SQL as a back end, that cured many of the miseries
associated with using mdb's as data repositories. Despite some comments to
the contrary I have read, ADODB, in conjunction with Stored procedures has
ben an inherently reliable and speedy solution for me. I am not here to
justify my opinion or defend my point of view, but if anyone else finds
themselves in the same boat, just know you are not alone!