Recent content by cas85

Thanks. You are correct. I figured it out.

I downloaded 10g from Oracle download site. Everything installed fine. I created a DB and loaded it with data. I went to Net Manager and setup my listener. When I try to set and test my service I get the 12541 error listener not found error. I went to my computer's services and there...

Correct Access does Work. The trick is how do thrid party software get to Access

No problem starting with basics. As far as I know nothing has changed ( yet of course something has). The mdb files have not moved or been named. Correct the application use the Access database (mdb files) to store the data.

I use a package that uses Access as its db. All of a sudden the application cannot find Access. I can open Access directly. Does anyone know how Applications access Access and how to repair corrupt or damaged drivers?

I guess the question I am asking is if the driver some how became corrupt does anyone know how to re install them?

I use a package that uses Access as its db. All of a sudden the application cannot find Access. I can open Access directly. Does anyone know how Applications access Access and how to repair this issue?

Hi Mufasa, Thanks for the help. I was rushed before but I see how your code works. Thanks!

Hi Mufasa, No problem with the lateness. I appreciate the help. I think I've got it. I tried to implement the code you sent but it did not work. Did I miss something? See below: update RqDocuments set RqDocuments.FileDirectory = 'c:\Projects',VersionNumber = VersionNumber +...

Hi Mufasa, You explained the point well. I get it. My exits statement is alwasys true so I update every record. Could you explian what the value X should be? My guess would be b.ID

My database has the following 2 tables: RqProjectDocuments RqDocuments Id DocumentId ID 12 10 10 12 11 11 12 12 12 12 13 13 13 20 20 13 21 21 13 22...

Thank you all for your posts. I am using all of the suggestions and code samples. Your pointers have saved me weeks of development time and testing.

On Windows 2000 Could someone outline the basic steps I should follow to do the following. 1) I need to get 128 records out of one table in Oracle. 2) I need to bring in the 128 records into another database. 3) When bringing in the 128 records there are 18 records that are duplicate that I...

If anyone is listening have a simlar question. Could someone outline the basic steps I should follow to do the following. 1) I need to get 128 records out of one table in Oracle. 2) I need to bring in the 128 records into another database. 3) When bringing in the 128 records there are 18...

Will this work if I need to mix a column value with constant values? Insert into Mytable (ID,"1.0000",Null,36,"Repaired Record") Select ID from Table2 where ID > 10 Still looking for joy :-)