Results 1 to 7 of 7

Thread: Access 2000

  1. #1
    New Lounger
    Join Date
    Mar 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2000

    I am a novice to Access and have constructed a database of client contact with their details from
    an imported dbf file received from a bureau that sells this info. They have now sent me updated info(access table) with a text indicator in one field that tells me if the info has been updated in the last six months, a year or is new, blank if has not been. How do I overwrite the data in my current database based on the criteria in this field ?
    Help !!!

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000

    Is there any reason why you can't simply replace the entire existing table with the new table?

  3. #3
    New Lounger
    Join Date
    Mar 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000

    Thanks for your response. No- as I have added other fields to the table.

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000

    Why not create a make table query to separate the fields of data you added along with the primary key ID and as long as the table you have received contains the same primary key ID you can create a query to include all the fields from both tables for data lookup and entry.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  5. #5
    New Lounger
    Join Date
    Mar 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000

    Thank you for your suggestion. I am not sure I follow what you mean - could you elaborate please. Sorry to be such a pain, but I am only a novice !!!!

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000

    Let's try this: first things first, back up your database. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    With that done, I'll operate under the assumption that each client has an ID of some sort that uniquely identifies them. Let's simplify things by saying that there are only 3 fields of information you originally received, ID, Name and City, and since then, you've added a field of your own called Rank. In a query, you can link your original table with the new table based on the unique ID field. At this point, you can change the query to be an Update action query, and choose to update your original table with data from the new table, but you get to control what fields of information are updated. Make sense so far?
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  7. #7
    New Lounger
    Join Date
    Mar 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000

    Thank you for your patience. I think it does, I shall try it and let you know how I get on !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •