Recent content by CptCrusty1

I can find info saying that it can be done, just now how. Any help is appreciated. I live to work and I work to live.

Ed, Bandwidth could very well be a problem, however, we are all on the same switch. Wouldn't that eliminate that issue? As far as network ID's are concerned, my manager confirmed that only 3 of us are pretty much unrestricted in terms of the user profile. In other words, I have admin rights...

I have a process that runs on Access2k build 9.0.0.6620 that runs in about 27 minutes on average. When I run this on a different pc with build 9.0.0.4506, the process runs in about 1.5-2 hrs. The PC's are identical in terms of hardware, i.e. 1GB RAM, same CPU, HD's defraged. My biggest issue...

All, Thanks for your input. You have some great ideas. MichaelRed has the right idea, i.e. St, Rd, Ct., Ave, bla bla bla. I've put several "iterations" per Crowley16's suggestion (and my simulatious idea) and it appears to work "OK" for now. Soudex is something worth checking out for...

I was doing that just now.. just wasn't sure how many iterations I was going ot have to make.... I live to work and I work to live.

I have two address fields "BNA" (means Borrower New Address) and MADDR1 (mailing Addr). The BNA is returned by my vendor and I need to compare it to the MADDR1 field. If the address is different, they've given me good info and can bill me. If not, no charge. My problem is I can only get so...

Is it possible to export a query or table as a pipe delimited text file? I live to work and I work to live.

NOt yet. I'll give it a shot tho... I live to work and I work to live.

Thanks Dhookom... I write pass-throughs all the time, however, I want to execute a stored procedure the same way. In oracle, I would call it in a package, or another store procedure. My procedure is called sp_TEST, and the language to call it would be: begin sp_TEST; END; However, if...

Is it possible to run an Oracle STored Procedure from Access? I live to work and I work to live.

Is there a forum, group, location, etc., where I can find help on SQL Navigator? I'd like some instruction on building Stored procedures to run queries, however, I'm not having any luck finding anything. Thanks Crusty. I live to work and I work to live.

Golom, I'm going to have to try that out. My problem probably stems from the fact that the PC for the application has ADOR 2.5 and I have 2.7. Maybe if I disable it totally, it will still work... I live to work and I work to live.

NOT! We have a term here.... Software Hindered by IT.... make the acronym.... Again, Any help is appreciated... I live to work and I work to live.

Remou, thanks for the information, really, thanks... above and beyond. I have 5 different versions of Access in my group. STuff I develope isn't working on the other pc's because of ADO AND DAO reference library differences. In most cases, I select (for example ADO v 2.7) the version I have...

I'm looking for the Oracle equivilant of the NZ() function so that I can use it in a Passthrough to Oracle, OR, so that I can create a view in Oracle and call it in Access... either way... what does Oracle call NZ()? I live to work and I work to live.