didn't work for me (see my reply to Mr. Cox)
here's the SQL i'm using:
SELECT Residents.ID, Residents.*, Admission.*, Devices.*, Skin.*,
Property.*, [Physical and Structural].*, Vitals.*
INTO [Text; HDR=Yes; Database=C:\Archive.txt]
FROM (((((Residents INNER JOIN Admission ON Residents.ID=Admission.ID)
INNER
JOIN Devices ON Admission.Key=Devices.Key) INNER JOIN Skin ON
(Devices.Key=Skin.Key) AND (Admission.Key=Skin.Key)) INNER JOIN Property
ON
(Devices.Key=Property.Key) AND (Admission.Key=Property.Key)) INNER JOIN
[Physical and Structural] ON (Devices.Key=[Physical and Structural].Key)
AND
(Admission.Key=[Physical and Structural].Key)) INNER JOIN Vitals ON
(Devices.Key=Vitals.Key) AND (Admission.Key=Vitals.Key)
WHERE (((Residents.ID)=Forms!DeleteResident.ID));
Douglas J. Steele said:
Works fine for me.
What's the exact SQL you're trying to run now?
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
i put in this code: INTO [Text; HDR=Yes; Database=C:\].Archive.txt
it's says it can't find "Archive.mdb"
i'm not trying to save it to another database, it's just supposed to
be a
backup .TXT file of the data in the record they are deleting in case
they
change their mind after the delete. am i trying to be too nice to the
users?
the deleted data will probably never be needed again.
:
Just try making the suggested change and seeing whether it works.
If it does, you're fine. If it doesn't, post back with what didn't
work,
and
we'll see what we can do.
