referential integrity

  • Thread starter Thread starter Phred Bear
  • Start date Start date
P

Phred Bear

I have a small group on a LAN using split db format but with some off site
machines which can't access the data. I have a seperate stand alone version
of my db which I email every so often with the latest data. To do this I use
VBA to remotely empty the stand alone tables, compact the DB to reset the
seed of the index to zero and replenish the tables from the back end. All is
well except for two tables which are linked to enforce referential
integrity. My append queries won't stick without previously disconnecting
the link, running the queries then re-connecting the link. It is all a bit
of a mess. Any ideas on a work around. I can't find anything in any of the
related forums.

Many thanks
 
Why do you care what values the Autonumber field has? Autonumbers exist for
one purpose only: to provide a (practically guaranteed) unique value that
can be used as a primary key. That purpose is served by 354765, 354767,
354768 just as well as it is by 1, 2, 3.

To get around your problem, though, presumably you need to load the Parent
table before you load the Child table.
 
Thanks for that speedy reply but, since it had nothing to do with the
question, I should'n have bothered if I were you.

My tables are linked through a commond field of references. One reference
number per record in main table, several records of the same reference
number in secondary table. Both tables are secondary indexed on this field.
Certainly, both tables use the autonumber field as a prime index but this
not used in the link. The reason I want to re-set the autonumber field is
just cosmetic because after a few updates, it will start to look like a
telephone number. I understand there is an inherent problem in Access
related to large Autonumbers, amonst many others, which can crash the DB.

Anyway, what I asked is what I want to do whether I care or not.

Many thanks.
 
Are you saying that the suggestion I made for getting around the problem
didn't solve the problem, or did you not understand what I was saying?

And, for what it's worth, Autonumber fields are seldom, if ever, shown to
the users. There are no problems that I've heard of with them becoming too
large.
 
Back
Top