Acc2003 Relationship Problem

[katz]

Hello!
I realized that the database is not responding correctly and I did a
repair/compact and all the Relationships disappeared.
Is there a way to get back the relationships?
I never had this problem with access97.
I don't know why my customers push me to upgrade to Acc2003. It does have
some nice features like Conditional formatting, but over all, I have more
problems and more limitations, like cant open database exclusively, its not
more efficient or faster, SaveRecord doesn't work all the time, I lost a
record without any reason. I think its enough for know.
Abe

 

[Guest]

Hi katz,

Did you try opening the database relationships window and right-clicking
your mouse and selecting "Show All"?

Damian.

 

[Allen Browne]

Is this database split? It really needs to be (for multi-user purposes, and
so you can update the front end without overwriting their data.)

If it is split, did you compact the front end or the back end? The
relationships should exist in the back end.

If an index goes bad (not uncommon, since all decent databases cache
indexes), when you compact the database Access may delete the relation based
on the bad index. If that happened, you will have a new table with details
of what was deleted, and the creation date will tell you when.

If more than one relation was deleted by the Access repair utility, then
multiple indexes were bad. This suggests a serious problem with the way the
database is deployed, such as using it with unstable power, across an
unstable network, etc.

It is possible to configure Access 2003 to be at least as stable as A97.
Details in this article:
Converting from Access 97 to 2000 and later
at:
http://allenbrowne.com/ser-48.html

I'm not sure what you mean by "SaveRecord" doesn't work all the time. If you
are trying to save programmatically, try:
If Me.Dirty Then Me.Dirty = False
That explicitly saves the intended form (whether it has focus or not), only
when needed. Use error handling for the cases where the record cannot be
saved (e.g. required field missing.)

HTH