Hallo,
Ive got an ACCESS-Database with active referential integrity rules.
The task is it to select some records (dynaset) and create a new DB.

First Problem:
How Can I preserve the relations by Counter-fields if I can't
update the Counter-field manually?
(Field isn't filled with continous numbers)

Second problem:
Which tables can be transferred (first and so on) without violating the
integrity rules?

Is it possible to delete all relations, indexes and counters and
do this by ACCESS, controlled or invoked by VB?

Do You know a better or simpler way to do this?

Please answer soon.

TIA Uwe

Live long and prosper!

1) Define your append queries in Access.  Test them.

2) In VB, create a QueryDef object for each of the queries.

3) Execute the queries in the proper order:  "one" side first, then "many"
side.

Hope this helps.

Bob Rossney

What you're talking about here is like replication performed by SQL
back-end databases, and can be quite difficult, depending obviously on the
complexity of the database(s).

What you could possibly do is something like:

Open the table in db (A), append to table in db (B), have a field in db (B)
table that holds what the old value of the counter field was in db (A),
then relate that old ID to the next table you do, and continue the
excercise on down the line (You obviously need to do it from higest level
to lowest level IE One side to the Many side)

I've seen groups try and fail, and I've had varying success with trying to
do replication myself, products like Access 95 onward, and SQL Server can
handle that for you (in SQL Server there's actually a full on replication
Server to handle that). If you've only got a couple of tables, you
shouldn't have much problem.

Anyway, hope this helps.

Cheers,

Nathan.