Solved

Linked Oracle table refresh question

Posted on 2009-05-14
1
247 Views
Last Modified: 2012-05-07
In my Access form, it's linked to an Oracle table, seems only when I close the access form, the current records are saved to Oracle table (they are linked), how to force save or synchronize the linked table? Thanks.
0
Comment
Question by:heyday2004
1 Comment
 
LVL 2

Accepted Solution

by:
michael1174 earned 500 total points
ID: 24388266
On your save button add:
    DoCmd.RunCommand acCmdSaveRecord
    Me.Dirty = False

On your exit button add:
If Me.Dirty = False Then
    DoCmd.Close acForm, "frmEdit", acSaveNo
ElseIf MsgBox("Save Changes?", vbYesNo, "Save") = vbNo Then
    If Me.Dirty = True Then
        Me.Undo
    End If
    DoCmd.Close acForm, "frmEdit", acSaveNo
Else
        DoCmd.Close acForm, "frmEdit", acSaveNo
End If

On your forms properties, set Close button to No.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now