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

1 Answer

Update record with two table

Update a record in one table from another table base on one same field

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

Ad

1 Suggested Answer

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.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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


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.

Dec 11, 2012 | Microsoft Office Access 2003 (077-02871)...

1 Answer

How to invoke a ms.access using parser


To parse a Text field that contains two words separated by a comma, follow these steps:
  1. Open any existing database.
  2. Create a table with the following structure: Table: Parse2Words
    ------------------
    Field Name: Empl
    Data Type: Text
  3. View the Parse2Words table in Datasheet view and type the following three records in the Empl field: Smith, John
    Callahan, Laura
    Fuller, Andrew
  4. Create the following query based on the Parse2Words table: Query: QueryTest
    ------------------------------------------------------------------
    Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1)
    Show: True
    Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1)
    Show: True

    NOTE: You can modify the QueryTest query to account for spaces between the two parts in the Empl field. For example, if the text in the Empl field is "Smith,John" without spaces, remove the -1 from the FirstName field expression.
  5. Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below: FirstName LastName
    --------------------
    John Smith
    Laura Callahan
    Andrew Fuller

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

1 Answer

Trouble inserting a different picture for each record. Want to link to file on another drive, and want the pictures to show up in a report.


A bound object is an object displayed within a field of a record in a table. Access can display the object in a form or print it on a report. A Bound object is bound to an OLE object data type field in a table. If you use a bound object in a form, you can add and edit pictures record by record.
An Unbound object is not stored in a table, it is placed on the form or report. An Unbound object control is the equivalent of a label control. To display the object for each record, you must place that field in the Details section of the form or report. Does this help?

May 30, 2009 | Microsoft Access 2002 for PC

1 Answer

Want to populate a form with data from a table, the Id number is keyed into the form and once it's matches with the Id in the table I want the other fields on the form to be populated with the data from...


Create a Form from the main table with a subform based on the other data you will want populated. You put the fields in the subform that you want populated from the main form. Go to the properties for the subform and select the data tab, In the data tab, select the Link Master Fields and choose the field you want linked. When you type the ID number in the main form, the other firlds you have in hte subform should populate from the data inthe table.

May 14, 2009 | Microsoft Access 2003 for PC

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

Mysql database tables+find new inserted or update row using java


After you add the new record into table A, you can use the LAST_INSERT_ID() function to retrieve the value of the auto_increment PK field. Look here for more information on this function: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html

Mar 02, 2009 | Sun Java Programming Language (cdj-275)

1 Answer

Time based triggers or procedures


Syntax to create Triggers in SQL are :

Create Trigger trigger_name // "trigger_name" : Give name to the trigger
on
table_name // "table_name" : name of the table on which trigger has to created
for Update
as

Begin

// Here Query has to be written here

End


Dec 18, 2008 | Microsoft Computers & Internet

1 Answer

How to create program in delphi


i wants to create form for data input
with the condition

Mar 13, 2008 | Computers & Internet

1 Answer

Restict closing the main form when some controls on the subform are empty


Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

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

Related Topics:

85 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2983 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

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

Answer questions

Manuals & User Guides

Loading...