Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rkinfo
  • Content: Threads
  • Order by date
  1. rkinfo

    append records in sql Server table from MS access table

    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
  2. rkinfo

    Insert rows into SQL server 7 using MS Access 2003

    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
  3. rkinfo

    call oracle procedure with in out parameter from ms access

    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") &...
  4. rkinfo

    Read Only form

    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?
  5. rkinfo

    run time error 3065: Can not execute select quer

    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 &...
  6. rkinfo

    insert recordin oracle from access database

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

    Access front end Oracle back end

    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...

Part and Inventory Search

Back
Top