If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linked table
I am pulling information from a linked table SQL Database
into access 97. This table will be continually changing. How do I select a record and add it to another table? Thank-you in advance! |
#2
|
|||
|
|||
Linked table
Sara
If you already have the information in the SQL database, why do you need to "add it to another table"? (i.e., what business need are you satisfying?). Are you considering saving a copy in the SQL database or in an Access database? -- More info, please ... Jeff Boyce Access MVP |
#3
|
|||
|
|||
Linked table
The database links an apartment database to the health
club database. The apartment info is pulled an used for the contract in the health club. The SQL table is dynamic in that the residents move in and out. We want to keep a copy certain records from the apartment datbase that will eventually expire for archiving purposes in the health club database. I only need 4 records from the SQL database. Thanks! Sara -----Original Message----- Sara If you already have the information in the SQL database, why do you need to "add it to another table"? (i.e., what business need are you satisfying?). Are you considering saving a copy in the SQL database or in an Access database? -- More info, please ... Jeff Boyce Access MVP . |
#4
|
|||
|
|||
Linked table
Sara
Just because a resident moves out, doesn't mean the SQL database necessarily deletes that resident. If I were designing a "residency" database, I would want to keep information on former residents. You may wish to pursue this a little further, as you will run into potential synchronization issues as soon as you begin storing more than one copy of the same info. -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|