jeffrey.demulling at usbank.com
jeffrey.demulling at usbank.com
Fri Oct 3 15:06:30 CDT 2003
About ready to leave for the day but how about this series of events:
1 - Remove old information from table in db
2 - Append new data information into table in db
Just a quick thought.
"Tesiny, Ed"
<EdTesiny at oasas.state.ny.u To: accessd at databaseadvisors.com
s> cc:
Sent by: Subject: [AccessD] Replacing a Table in an Application
accessd-bounces at databasead
visors.com
10/03/2003 02:36 PM
Please respond to "Access
Developers discussion and
problem solving"
Hi List,
Quiet day, good time to ask what is probably a simple question. I have a
table in an application that contains information about agency Executive
Directors, Program Directors, phone numbers, etc. This table has a
relationship with other tables. I would like to get an updated table every
month so the info stays current. How does one go about replacing the old
table with the new one without deleting relationships and recreating them
after importing the updated table. I know this must be a common task but
not sure how to accomplish this. Any ideas late on a Friday afternoon....
TIA
Ed
Edward P. Tesiny
New York State OASAS
Evaluation and Program Monitoring
1450 Western Ave.
Albany, New York 12203-3526
Phone: (518) 485-7189
Fax: (518) 485-5769
EdTesiny at oasas.state.ny.us
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com