Search results for query: *

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.

(sigh)... I fully understand that the best way to resolve this issue is to upgrage everyone to the same SP level. However, the problem is that I'm not in the MIS dpt, even though I know more about it then they do. I have to provide evidence and reasoning so that they can spend the money to...

That seems to be the issue. The IT dpt. installed the original Office 2k, and then over time, newer versions of the same apps. So our oldest PC has Access 9.0.2720, while the newest (mine) has 9.0.6620. We also have several versions in between. Thus, there are compatability issues between...

I'm actually using Access 2000, not 2003. I'm currently on the Office site tho... I live to work and I work to live.

I'm developing on a new version of Access 2k. Our IT dept. has unfortunatley installed newer version as new people come to our department. What this means is that I have SP-3, however, several people in my department have 2, 1, or even original Access 2k Pro, no updates. Obviously, there are...

Ok... guys... I'm really confused... I thought there was ADODB (ADO) and DAO. Whats the difference between ADOR and ADODB? Should I post some code? Also, there are other issues at hand as well... some DAO stuff (from previous programmers) isn't working as well, but thats another issue...