Re: Access 2: Copy Records; Relationships

#1

Check out the Tools section to copy relationships from one MDB to
another

http://www.etechrecovery.com/001-AccessFAQ.asp#Tools

Trevor Best wrote:

Quote:

On Mon, 03 Nov 1997 14:49:42 -0800 in comp.databases.ms-access, David
Daye <ddaye (AT) postbox (DOT) acs.ohio-state.edu> wrote:
I'm a former dBase-dos/vms programmer just encountering
Access. 2.0 in Win 3.1. "M-m-m-m-mmmm!! Micro Soft!!"

1. Copy Records between identical tables.

I've got a 5-field table, I copied the structure-only,
now I want to copy individual records. I can append
the entire source table but can't use the copy and
paste or paste-append commands to add just 1 or a
few records. Error msg says "data too long for field."
??

Did you select the record before pasting? select the record using the
selector on the left otherwise it pastes everything into one field.

2. Relationships
Parent table with 3-field primary key, child table
with 4-field primary of which first 3 are same as
parent's. I want to relate parent to child on these
3 fields, one-to-many. Also Enforce Referential
Integrity, Cascade Delete Related Fields, and
Join Type 2 [ Include all parent records and only
those child records where joined fields are equal.]

I can only do this when the child table is empty.
With even 1 record, error msg says the child
violates ref. integrity.

I've verified that the 1 record has a record in
parent that exists for the 3 key fields in parent.

a) ??
b) Can Access identify and/or delete violations
itself? Can I open a table and append-from another
table?

Try copying the record to another table, delete it, create the
relationship then re-insert the record.
\|||/
/ \
C o o D
-----------------ooO--u--Ooo-------------------------------
To reply my mail, replace the "nospam" in my address with "trevor",
this was put on in defence of the spam robots that roam usenet.

MS Access FAQ now available on my site below.
http://easyweb.easynet.co.uk/~trevor/

RAM DISK is not an installation instruction.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Access 2: Copy Records; Relationships

comp.databases.ms-access comp.databases.ms-access

Re: Access 2: Copy Records; Relationships - 12-17-2004 , 05:45 PM