none
Linked Table - Sub-form - Edit Record And Screen Freezes, Access 2016 RRS feed

  • Question

  • All,
    Thanks in Advance. A very very strange one... 
    I am linking to an Oracle Table 1000 Rows, 60 Columns. A Report Inventory. No field is larger than 250.
    Created a Subform Grid, can Add record, and then edit that same record. But, If I move to another record, and attempt to edit and move to another row, form is forzen. 

    Also, tried in a New database in Access 2016 O365, and linked to ORacle DB, and attempted to Add record without form via Table UI. Can Add, but Edit I see same exact issue.

    I have coded similar forms before, and never had this issue before. Any insight or suggestions greatly appreciated. 

    Tried Linking Oracle Table with both ODBC with Oracle Driver and DNSLess Connections for Linked Table. Same issue under both.  Also tried MS for ORacle Driver - same issue. 
    Tried earlier version of MS Access also... 2007... Same issue. 
    Friday, September 16, 2016 4:31 PM

Answers