Search results

I did actually, it worked but still extremely slow my query was SELECT a.KYOKUSYOCD, a.BUNSITUCD,a.REREKINO FROM TTOKUKMD01 b LEFT JOIN TYOKUMD01 a ON a.KYOKUSYOCD & a.BUNSITUCD = b.KANKYOCD WHERE b.KANKYOCD IS NULL Correct right? Well it worked but took 5-6 minutes to load up. I have 24K...

I did that but it was extremely slow, I coded it first using NOT IN and it took 6 minutes to load! I mean, WOW And the Unmached thinga a gigger, it took 5-6 minutes to loadf either

I have 2 tables TKYOKUMD01 and TTOKUKMD01. So Im supposed to get the records that aint found by this query in the TKYOKUMD01 table: SELECT a.* FROM TKYOKUMD01 a, TTOKUKMD01 b WHERE a.KYOKUSYOCD & a.BUNSITUCD = b.KYOKUSYOCD & b.BUNSITUCD Easy right? All I have to do is use NOT EXISTS Right? So I...

I want to open my udl files programmatically so users can do the changing in just one sandbox. But, the Shell() function seems to only supprt exe files. Is there other ways to do this? PLease help

Im doing this program for a post office and stuff, their DB is Oracle and they want to front end it in Access coz its free or bundled w/ office. Im using the almost fossilized Access 2000, the laptop Im working on is a2.6 ghz Centrino w/ 1024 MB DDR RAM abd 250 GB HD. Now, since that I am...