[AccessD] Replacing a Table in an Application

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







More information about the AccessD mailing list