Recent content by miller1975

Hello Frederico, Lookign for a reponse to the invoice query please

Both the target and destination is the same machine and I am running OBCS based exe files and they work fine.. Only this one is giving this error.

Hello All, I had made a VB program to update some tables using ODBC connection. The VB codes works great when its ran from the VB mode. I want to make an exe out of it so I can make it a Scheduled process to run from Windows XP. When I made the exe, it created the exe successfully. But when I...

Hello, Can you elobrate on this solution you have mentioned And yes its the timeout issue (there are 2 networks, 2 firewalls involved in this process) thats causing the process to fail, if I dont use the incremental paramete.

Hello All, I have a Access SQL query that I am running from VB, but for some reason it doesnt come right from VB but the query works great from Access. Now I can run it from Access but the problem is the query fetches over 3.5 million records. So I had set a incremental run code in VB. Can I do...

The UR clause will sure go away..when its converted to Access SQL..as Access doenst support UR..

Frederico, Here is the full thing Check ur mail also... SELECT A.CUSTOMER_NBR, A.CONTRACT_ID, A.BRANCH_CO_NBR, A.BRANCH_NBR, C.BRANCH_NAME, D.DEALER_NBR, D.DEALER_NM, D.SOG_NBR, E.SOG_NAME, A.CNTR_BILL_ADDR, VALUE(I.LAST_NAME,'?') AS BILLTO_NAME, A.ACCT_PLAN_ID, A.SETUP_DATE, F.CONT_COLL_STAT...

Hello all, Here is a portion of query I am running from DB2. Would like to convert it to Access (Jet) sql. Please help SELECT A.CUSTOMER_NBR, A.CONTRACT_ID, A.BRANCH_CO_NBR, A.BRANCH_NBR, C.BRANCH_NAME, D.DEALER_NBR, D.DEALER_NM, D.SOG_NBR, E.SOG_NAME, A.CNTR_BILL_ADDR, VALUE(I.LAST_NAME,'?')...

Its set for 20 minutes now..on the server. I want to set this from the client side..

Hello All, I am working on a ASP application which connects to a access db to get user login information and store data. The connection timesout after 20 minutes once the user logs in a leaves the session idle. Is there anyway to increase the timeout range without changing anything on the IIS...

Got it..let me try this.. Thanks Frederico..

If we use this method INSERT INTO TBL_01 (fields list) SELECT fields list FROM yourPassthruQueryName then wont we have 2 select statements..I mean the PassthruQueryName also has a select statement right..

Hmm..Ok If if we are going by the scenario mentioned here..it should look like this INSERT INTO TBL_01 field1, field2..... SELECT A.CUSTOMER_NBR, A.CONTRACT_ID, A.COMM_CREATE_USER, A.COMM_CREATE_DT, A.COMM_ACTION_CDE FROM ACRP1.CONTRACT_COMMENT A WHERE A.COMM_CREATE_USER NOT IN...

So what you are saying is make a new new blank append query say APPD_QRY INSERT INTO TBL_01 and then add the pass through qry to this append qry.. But how will it work..I mean how will access run the ANSI version as a regular append query..

Hello PHV, My sql query is only doing select. How do I make it a append table. Is that allowed with pass through.. Note my pass through is in ANSI..and I am running it from Access..which you know uses JET.. How will it work in this situation.. This is sample of the code in ANSI (pass through)...