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

  1. Checking

    ODBC Driver needed to connect SAP (residing MSSQL Server) to MSACCESS

    We need to connect SAP Table(s) to MSACCESS in order to complete a dedicated application where read-only of live SAP data is required. Our SAP System data Component version = SAP ECC 6.0 The database system is MSSQL based release version 10.00.2531. Most probably we would be needing an ODBC...
  2. Checking

    How to ignore Excel Popup messages during Excel Book Scanning

    Briljant Remou! Works like a charm. The only remaining issue is when another user has an xls book open while the MSAccess code runs through the xls files. In that case a popup asks to confirm reading the file as read-only. Is there an easy solution to ignore, skip, or automatically accept ...
  3. Checking

    How to ignore Excel Popup messages during Excel Book Scanning

    Hi there, After setting up code to Scan and import Excel workbooks' Cell Data, I've ended up with one remaining issue here; My code scans workbooks in certain network directories, fetching new or changed celldata, populating data in MS Access tables. All of this is working perfectly, the only...
  4. Checking

    Get Gateway IP address

    Thanks very much PHV; works even better !!! Briljant. Rgds frm Belgium
  5. Checking

    Get Gateway IP address

    Found the answer in http://www.tek-tips.com/viewthread.cfm?qid=900140 Works Great !! Belgium
  6. Checking

    Get Gateway IP address

    Implemented MSAccess Application with Backend (residing on company's intranet)& FrontEnds (per User). I want to be shure that users only can connect to the backend when they are physically in the office (thus directly connected to the intranet). So, If they are in the office starting up their...
  7. Checking

    Compact on close or not!

    Hi there, Following triggers a back-end compact only when no user connected anymore. When using an exit button on the front-end, the application closes all forms & opens a kind of maintenance form. So no back-end tables are connected anymore. An 'OnOpenEvent' with following code will compact the...
  8. Checking

    AVG 7.0 will not update...

    I ran into the same prob few mths ago. Seems that 7.0 Free version updates from different server than Pro version. Since most users run free version, related server seems overloaded. Try following countermeasure: Edit the 'hosts'-file on individual PC's and add the 'guru' line below the...
  9. Checking

    ADO Insert into Oracle from Access query

    Yesss plzzz citychap26; could you post-it ? Thks Belgium
  10. Checking

    How to free RAM-mem in between coded query-steps (qdf)

    Thks again both of you & Tek-Tips ! Yr detailed info helped me a lot... & clears quiet some questions. .... The more you know, the more you know what you don't know .... Belgium
  11. Checking

    How to free RAM-mem in between coded query-steps (qdf)

    Thks so much LittleSmudge & VBslammer; altered Variants to more apropriate Dim's & removed obsolete Dim's and consequentially doubled avalable RAM after running procedure. At the end of the procedure, RAM however remains at the lowered level; not freeing upwards. Only closing database will free...
  12. Checking

    How to free RAM-mem in between coded query-steps (qdf)

    Herewith a processreport generated by above code to indicate the symptom: 9/02/2005 6:41:41 § Starting RMS-Refresh Procedure 9/02/2005 6:41:50 § Qdf1 Clearing tbl_Repairs, Time elapsed: 0:00:09, Curr dB-Size: 168.776 MB, RAM-AVA: 233.964 MB or 44.6 %, CPU Load returned to: 1 % 9/02/2005 6:45:31...
  13. Checking

    How to free RAM-mem in between coded query-steps (qdf)

    Thks LittleSmudge; I'll take the usefull information into account. Actually, I'm in the middle of reviewing an existing process (using traditional queries) to a more dynamic automated process. The whole process retreives lots of info from-out DB2 tables. Also within this process I marked heavy...
  14. Checking

    How to free RAM-mem in between coded query-steps (qdf)

    Hi there; after searching related threads (& having a headache now), I'm ending up in starting this thread. During running code (see below), I see my 'available RAM Memory' shrinking from > 300MB (physical 512 installed)to a very low level (< 30MB) and not freeing-up between steps. The thing...
  15. Checking

    RAM R/W TEST FAILED on cold bootup

    Right traycee! Now my pob seems solved !!! Though V-DATA 1GB-PC3200 RAM as originally sold SEEMS NOT COMPATIBLE WITH Asus MOBO P4P800SE/Asus VGA 9250ATI128. Replaced V-DATA RAM V-Data 1GB-PC3200 by the same type from same brand again (as the store suggested !?!) did not solve the prob. After...
  16. Checking

    RAM R/W TEST FAILED on cold bootup

    Yes you've got a point in that case paparazi, but I did ask for MOBO,RAM,VGA,P4-Processor,A-Drive,DVD-RW Drive,Keyboard at the same time and asked specifically wether all is suitable for building a PC. With the exact configuration I was able to show the problem. I already asked exchange by 2x...
  17. Checking

    RAM R/W TEST FAILED on cold bootup

    Yes BadBigBen, I tried with another PSU; same effect. As for the memory, I started trying with the default one (vs6) which I upgraded to vs7 to be shure. Further, the system is working perfect. It's just 20" after powering-up and only from a cold start that the RAM-Check stops at around...
  18. Checking

    RAM R/W TEST FAILED on cold bootup

    Thks for yr quick response braddds; that was my impression too. As for the concerned store, last time I was there I wanted to show the symptom by compairing the 'non working RAM' with the one from an ASUS-supported OCZ-RAM. Within 5' it could have proved with the problem fixed. The guy at the...
  19. Checking

    RAM R/W TEST FAILED on cold bootup

    [flame] New Hardware as follows: Asus MOBO P4P800SE/AsusVGA 9250ATI128/Single Memory V-Data 1GB-PC3200 wanted to buy another one afterwarts/Intel Prescott P4-3000/...This config seems hopeless. Following problem. At cold startups only and each powerdown-restart after 15', RAM memory checking...
  20. Checking

    Applying Dbase changes automatically

    Forgot to mention Trudye that when you hardcode the projectVersion you don't need any tables in the .mde Further, the code places (or overwrites) the full local copy Another issue, pls. consider an auto-compact method for the .mde which runs periodically of whenever size goes above a certain...

Part and Inventory Search

Back
Top