Search results for query: *

Yes, after droping the table I have recreated the table. Then tried to insert records. I am able to insert records manually from MS access but not able to add new new records using VBA

How can I append rows to SQL server table from an MS access table? My module was working fine to insert rows to linked sql server table but since I have dropped SQL database table I am not able to append rows. Although I am not getting any error message

How can I append rows to SQL server table from an MS access table? My module was working fine to insert rows to linked sql server table but since I have dropped SQL database table I am not able to append rows. Although I am not getting any error message

I am trying to run a pass-through query as following. Set qdf = db.CreateQueryDef("") qdf.Connect = "odbc;dsn=oraacc;uid=msgdrss;pwd=gdrss;server=gdrss" qdf.sql = "BEGIN keepcompile(TO_DATE('" & Format(StartDateTime, "MM/DD/YYYY") &...

My table was read only, Changed access to table and it worked. Thanks

All these settings are same

I have copied a form from one data base to other. I changed to read only form and it is not allowing me to add or edit any record? How to make it wriable form?

Finally: It worked strIN = "INSERT INTO xdatafactorS( MeterID, DATE_, AFApplied, ISDefault, CALCDATETIME, PeriodGrpID) " & _ "VALUES (" & Meterid & ", TO_DATE('" & Format(dateset, "MM/DD/YYYY") & "','MM/DD/YYYY'), 1, 1, TO_DATE('" & Format(Now(), "MM/DD/YYYY HH:MM:SS") &...

It did not work. I think it has some issue with date format as I was able to insert a record if I try to insert string/varchar2 instead of ddate.

Now I am getting error runtime error 3146 odbc-call failed I tried both the syntax strin = "INSERT INTO xdatafactorS( MeterID, DATE_, AFApplied, ISDefault, CALCDATETIME, PeriodGrpID)" & _ "VALUES (" & Meterid & ",# to_date(" & dateset & ",'dd/mm/yyyy')#, 1, 1, #to_date(" & dateset &...

I am trying to indert record in oracle database and getting error run time error 3065: Can not execute select query Any idea? strIN = "INSERT INTO xdatafactorS( MeterID, DATE_, AFApplied, ISDefault, CALCDATETIME, PeriodGrpID)" & _ "VALUES (" & Meterid & ", to_date(" & dateset &...

How to insert records in oracle database from access? How can I pass present time to oracle date field?

How to create connection in access module?

Will you provide me vb code as I have already configured odbc connection?

How to set up connection with oracle database using odbc connection

I have migrated my MS Access database/sql server to Oracle but front end is still MS Access. I have created ODBC Connection. I need to change modulesso that it points oracle database insted of pointing to ACCESS /SQL Server database. I have couple of 1) When should I prefer to use linked table...