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 gkittelson 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: *

  1. deb331

    Virtual Memory error MSaccess with Oracle 9i client

    The Oracle9i client requires a minimum of 128mb of RAM (although 256mb is recommended) whereas 8i requires a minimum of 32mb RAM. This access application had no memory issues with 8i.
  2. deb331

    Virtual Memory error Access with Oracle 9i client

    I have an access 2000 DB front end with Oracle back end. Recently upgraded from 8i to 9i client which requires more memory (32k to 128k). User has been getting virtual memory errors after using app for a few hours. Upgraded to 512k and the problem is still occuring, so now at 256k with...
  3. deb331

    Virtual Memory error MSaccess with Oracle 9i client

    I have an access 2000 DB front end with Oracle back end. Recently upgraded from 8i to 9i client which requires more memory (32k to 128k). User has been getting virtual memory errors after using app for a few hours. Upgraded to 512k and the problem is still occuring, so now at 256k with...
  4. deb331

    runsql update fields from form error occurs when dates are null

    I changed the format for the dates on the form to short date and in the sql statement changed the # to '. It updated the Oracle tables even with null dates which is just what I wanted. Now I have a new problem- when I click on add on the form (to add a new record) all date fields display as...
  5. deb331

    runsql update fields from form error occurs when dates are null

    Shanti, Thanks for the info Debbie
  6. deb331

    runsql update fields from form error occurs when dates are null

    I have a form based on a query joining two tables. The tables can be updated individually - so I am using a loop to check for changes in either table. When I update I first write a history record and then update the table. To update a table I am using docmd.runsql update table1 set...

Part and Inventory Search

Back
Top