Question about Microsoft Office Access 2003 (077-02871) for PC

1 Answer

Update a record and save it in two or more tables.

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 242 Answers

First, make sure that the tables that you are using have some sort of Primary Key so that the correct records can be linked.

Next, choose 'Tools' -> 'Relationships' from the top menu.

Add the tables for which you want to link together. Drag the correct field from one table to the next table. A popup window should appear.

In the window that appears, choose the 'Enforce Referential Integrity' and 'Cascade Update Related Records' options.

Now, whenever you change the field in one of those tables, the corresponding filed in the other table should change as well.

Posted on Dec 12, 2012

Ad

2 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Ad
  • 1 Answer

SOURCE: update record with two table

have an Access 2003 database that appears to be very corrupt.
I was having a problem and did a compact and repair on it, and I
lost my network connection during the process. Now when I try
to open it (or access it via DTS, VB, anything I can think of),
I get

"The Microsoft Jet database engine stopped the process because
you and another user are attempting to change the same data at
the same time".

I have rebooted the machine that was accessing it, and no
help. I can't reboot the server now because it's a 24/7 file
server. Is there any way to get this database open? I have
searched and found a bunch of demo programs that will
"uncorrupt" it and show some data (but not save it), so I know
it's possible, but is it possible without buying one of those
programs?
thanks

Posted on Jan 09, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Bush dvr3006 will play audio disks but wont play any dvd ! just says load for ages then turns off or no disk ! help please ?


These are the formats your DVR will or will not play.
  • Blu Ray Playback: No
  • Blu Ray Recording: No
  • Compact Flash Card: No
  • DTS Decoder: No
  • DVB-C: No
  • DVB-S: No
  • DVB-T: No
  • DVD Audio Playback: No
  • DVD Player / Recorder: DVD Recorder
  • DVD+R Playback: Yes
  • DVD+R Recording: Yes
  • DVD+RW Playback: Yes
  • DVD+RW Recording: Yes
  • DVD-R Playback: Yes
  • DVD-R Recording: Yes
  • DVD-RAM Playback: No
  • DVD-RAM Recording: No
  • DVD-RW Playback: Yes
  • DVD-RW Recording: Yes
  • DVI Interface: No
  • DivX Playback: No
  • Double Layer Recording: No
  • Electronic Program Guide (EPG): No
  • Ethernet: No
  • Firewire IEEE-1394 Interface: No
  • HD-DVD Playback: No
  • HD-DVD Recording: No
  • HDMI Interface: No
  • HDTV: No
  • IPTV (Internet Protocol Television): No
  • Integrated VCR: No
  • MP3 Recording: No
  • MPEG4 Recording: No
  • Memory Stick: No
  • Multimedia Card: No
  • Number of Scart Interfaces: 1
  • PCMCIA Interface: No
  • Progressive Scan: No
  • Real Dolby: AC3
  • Secure Digital Card: No
  • Show View: No
  • Smart Media Card: No
  • Super Audio CD Playback: No
  • Super Video CD / Video CD Playback: No
  • Table / Portable: Table
  • USB Interface: No
  • W-LAN Connection: No
  • xD-Picture Card: N

May 24, 2014 | Televison & Video

1 Answer

Configure dhcp


1. select the MAC you want to remove
2. change status from Static to Auto
3. click SAVE

Sep 01, 2012 | TP-LINK TD-W8901G Router

1 Answer

PANASONIC DMR EZ47 WONT FINALISE


NEED DMR-EZ47 - 475 DVD Recorder RRT Firmware Update

Version RRT
  • Compatible Models DMR-EZ47VK, DMR-EZ475VK
  • Issues Addressed Issues Addressed
    1. Enables the DVD Recorder to download the new V-Chip Regional Rating Table Data Stream.
  • icon-download.gifDownload
    http://www2.panasonic.com/consumer-electronics/support/Video/DVD-Recorders-Players/DVD-Recorders/Drivers-Downloads/model.DMR-EZ47VK.D#ts
  • Sep 14, 2009 | Panasonic (DMR-ES45VS)

    1 Answer

    The Olympus people told me to to to


    Copy & paste the link they gave you (everything within the 'www' to the '.zip') and paste it in your address bar at the very top of your browser (not your search engine field). This is a direct link and will prompt you to open or save the file. Choose 'Save' and then save it to your desktop. You'll have to extract the .zip file once you've downloaded it.

    And I assume they gave you another link for the Vista/XP2000 update? Do the same thing as I mentioned above.

    Sep 11, 2009 | Olympus DS-330 Digital Voice Recorder

    1 Answer

    Application and example of relationship in access


    Relationships

    After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

    A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

    Having met the criteria above, follow these steps for creating relationships between tables.
    1. In the database window view, at the top, click on Tools ---> Relationships
    2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
    3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
      relationshipdrag.jpg
    4. Select Enforce Referential Integrity
      refintegrity.jpg
      • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
      • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
    5. Click Create and Save the Relationship

    Apr 09, 2009 | Microsoft Computers & Internet

    1 Answer

    Selecting a custom recording.


    I was told that the day and night settings in the local applications must be the same. It is in your night call routing table that you need to place the extension in order for the system to know which recording to play when. Then, your system will play the application when it is set in night mode. Hint: When you place the extension in the call routing tables make sure the extension is placed ABOVE the +ALL CALLS line, if applicable, and your ring-in-destination is set to your appropriate application recording. I hope this helps.

    j

    Dec 15, 2008 | Inter-Tel Axxess Corded Phone

    1 Answer

    Access 2003 subform won't scroll


    Check microsoft.com/office for any updates.

    Convert you database to Acess 2000 and see if the problem goes away.

    Oct 20, 2008 | Microsoft Office Professional 2007 Full...

    1 Answer

    Update record with two table


    have an Access 2003 database that appears to be very corrupt.
    I was having a problem and did a compact and repair on it, and I
    lost my network connection during the process. Now when I try
    to open it (or access it via DTS, VB, anything I can think of),
    I get

    "The Microsoft Jet database engine stopped the process because
    you and another user are attempting to change the same data at
    the same time".

    I have rebooted the machine that was accessing it, and no
    help. I can't reboot the server now because it's a 24/7 file
    server. Is there any way to get this database open? I have
    searched and found a bunch of demo programs that will
    "uncorrupt" it and show some data (but not save it), so I know
    it's possible, but is it possible without buying one of those
    programs?
    thanks

    Jan 08, 2008 | Microsoft Office Access 2003 (077-02871)...

    1 Answer

    Table not gettin updated


    Generally database updates either require a commit to have the database perform the appropriate checking and actually flag the rows as part of the database. That Commit can occur in two ways -- some databases can be setup with an auto commit or auto rollback when the database is disconnected. The first means the programmer needs to do nothing. The second means if the programmer does not commit the updates are backed out of the database. To commit is generally considered bad because if there are any data errors partial transactions and logically inconsistent contents can exist in a database. For example entering an order for merchandise requires a single header row to identify the customer and multiple items rows to indicate what was ordered. If the third item record added to an order had an error and the application did not rollback and the database auto committed and incomplete order with only two items would be saved in the database. Traditionally databases with an automatic action at shutdown are set to rollback to assure such partial information is not saved. Even with auto rollback good programs detect errors and rollback themselves and allow users to continue.

    The net result of the above is the probability that if the inserts actually occurred as you believe the there was a missing commit to confirm their addition to the database. and an automated rollback kept them from being completely added to the database. Another alternative is that the insert was not error checked in the program code and it failed meaning despite the program counter claiming rows were inserted in fact they were not.

    Dec 07, 2007 | Computers & Internet

    1 Answer

    How to activate command buttons II


    Hi Lensa, The code is fine there should not be any problem with it. Do not change anything on it. In my opinion the buttons and code has nothing to do with it since they are done automatically and usually work fine. When you press the add new button you are not just creating a new record you are also updating the last record. This button just send you to a new empty record for you to fill. From my experience the error message is due to 3 major reasons: 1. Your record source for this form is a query that cannot be updated 2. You don't have writing permissions to the database. Check and see if the file is locked or its on read only, Check security options and see if the database is read only etc. 3. Your records are locked by the table setting for some reasons, primary key fields might create duplicates. If its just a table try updating the table without a form and see what happens. As I wrote above the problem is with the record source or the database and since I can't see what you have there I can't help you further. I would also suggest you should practice with a simple table first before going into advance queries. Create a table with some simple fields like: ID - Primary key - Auto Number First name - Text Last name - Text Then create a form of that table and start filling in the names and test all the buttons, that will give you an idea of each button and I am sure it will be easier. Good luck Daniel

    Aug 16, 2007 | Microsoft Office Standard for PC

    Not finding what you are looking for?
    Microsoft Office Access 2003 (077-02871) for PC Logo

    44 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2774 Answers

    Piyal Perera
    Piyal Perera

    Level 3 Expert

    528 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18394 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...