473,327 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Error Updating Oracle Table from Access Form

Hi, I have an Access 2010 Front End database linking to Oracle 11g tables. I have a form where the user sets a date value in an unbound text box and a 5 character text value in an unbound combo box field. The user clicks on a command button and a query runs to update the appropriate fields for the selected records with the values set on the form. The fields being updated in the oracle table have properties of Date/Time and Text(10).

I am receiving the following error:
ODBC--update on a linked table failed.
[Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column (#1461)

I have tried playing with cDate(Form!Field1) and cStr(Form!Field2) to resolve this but I keep getting the same error. I have also tried hard coding my values in a query and loading them that way and I get the same error. This is the sql for my query where I am hard coding the values:

Expand|Select|Wrap|Line Numbers
  1. UPDATE TBL SET TBL.APCESOURCE = "TCISP", TBL.APCEDATEAPPROVED = #4/30/2013#
  2. WHERE (((TBL.CACMNTH)=9) AND ((TBL.CACYR)=2013) AND ((TBL.PROJECTID)="TC365500") AND ((TBL.SUBPROJECTID)="TC36550002"));
  3.  
I am confused as none of my fields are LONG.

I am able to manually enter a date and text in these fields in the Oracle table so I don't think this is a premissions issue. Do you know how to resolve this?
Sep 24 '13 #1

✓ answered by time2hike

Circling back on this conversation. My IT shop looked into this issue and found that if we use the Microsoft ODBC for Oracle Connection instead of the Oracle Client 11G Connection the issue seems to go away. We are continuing to test this but preliminarily changing the connection is solving the issue and I have not found any problems that are created by changing the connection to the Microsoft ODBC for Oracle Connection.

2 5127
zmbd
5,501 Expert Mod 4TB
Double check the date format in the [TBL.APCEDATEAPPROVED] field. You have #m/dd/yyyy# as the data and your field could be expecting #mm/dd/yyyy# or some other date format.
Sep 24 '13 #2
Circling back on this conversation. My IT shop looked into this issue and found that if we use the Microsoft ODBC for Oracle Connection instead of the Oracle Client 11G Connection the issue seems to go away. We are continuing to test this but preliminarily changing the connection is solving the issue and I have not found any problems that are created by changing the connection to the Microsoft ODBC for Oracle Connection.
Nov 5 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Jon Ole Hedne | last post by:
My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary...
2
by: Josh Strickland | last post by:
I am attempting to create an Access database which uses forms to enter data. The issue I am having is returning the query results from the Stored Procedure back in to the Access Form. ...
1
by: Fred F. | last post by:
Here is my problem. From an ACCESS form, I run a C++ process reaching the same database in read/write mode via the ODBC driver. An error occurs: " The database has been placed by an unknown user in...
16
by: TD | last post by:
This is the code under a command button - Dim ctl As Control For Each ctl In Me.Controls If ctl.BackColor <> RGB(255, 255, 255) Then ctl.BackColor = RGB(255, 255, 255) End If Next ctl
2
by: marciful | last post by:
Hi, I am new to access, so pardon my question. After I created my form, I needed to make changes to my table fields. After doing so, the form does not update and show this field as it is currently....
2
by: Bower | last post by:
Hi, Im writing some code and need to update two labels on a form as per 2 labels on a previous form (still open). The code im using is: Private Sub Form_Load() lblFirst.Caption =...
13
by: smiler2505 | last post by:
Sub cmbEnt_NotInList(NewData As String, Response As Integer) Answer = MsgBox("add?", vbYesNo, "add?") If Answer = vbYes Then DoCmd.Close acForm, "frmOrd" ...
1
by: wrightgj | last post by:
Hello, I have a chart in an Access form that updates when the underlying table is updated, which occurs when a button is pressed. I also have the option of adding more records to the table, which...
0
by: NasirMunir | last post by:
I am trying to compare records from oracle table with a table in access. With oraDynaset, I have the option of .findNext function. I can use that to look for matching records from access to oracle....
2
by: Luting | last post by:
Hi, Is it possible to update oracle via Access forms? I am thinking maybe I could make a link table connnected with oracle database. And the form could be based on the link table. Does this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.