Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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