Recent content by NCYankee1

Yes I tried your 'Run As' suggestion and it is a viable option. Thank you for that suggestion. The only problem with it is this: The MS-Access front end app needs to know who spcifically is logging in. And our DBA does not want to add/maintain a list of 80+ users' security on the SQL Server. So...

(I originally posted this in the Access forms forum by mistake. Sorry for the duplication) I have been given the task of converting an MS-Access 2003 application whose database currently resides on SQL2000 (mixed mode) and move the database to SQL2005. They want the database to reside on a...

Hi I have been given the task of converting an MS-Access 2003 application whose database currently resides on SQL2000 (mixed mode) and move the database to SQL2005. They want the database to reside on a Windows Authentication Mode SQL Server. This means that I would need to impersonate a...

That's the ticket! Man, what a mental block I had. Thanks for your help!

I have two tables: tblA =============== CustNbr int SeqNbr int Field1 varchar Field2 varchar tblB ================ CustNbr int SeqNbr int FieldX varchar I want to update Field2 in tblA with the values from FieldX in tblB where tblA.CustNbr=tblB.CustNbr and tblA.seqnbr=tblB.seqNbr. When...

Thank you!!! That worked! I knew you were giving me the answer in your earlier posts. but I was feaking too much to figure out how put it into the proper syntax. :) Thanks!

I see how you are checking to ensure the data is in fact numeric. That's cool. Is there a way I can incorporate that directly into my INSERT statement so i am either using the incoming BookQty value if it is numeric, otherwise insert a 0? INSERT into sm_InvBalanceRoot (LocCd, CatCd...

I am inserting data from an XML string into a SQL Server 2000 table. I have no way to assure that the data I assume is numeric coming in via XML is in fact numeric. So it is causing my insert to fail. Here is the insert statement: INSERT into sm_InvBalanceRoot (LocCd, CatCd...

I've searched the archives here and tried things I've found but nothing is working. Here's my problem: My Windows Service has to read the contents (1 line) of txt files. A source file comes in, I read it and process. Then I read the next source file. Sporadically I get the following exception...

That did the trick! Thanks for your help!

I am writing a Windows Service and I need to have the service perform some function at 10 past and 40 past every hour. How do I set up the timer to do this? I am assuming I would use system.timers.timer somehow? Thanks for your help.

Thanks, vongrunt. Your statement did the trick! Yes, AtomicWedgie, there is a PK, but it is an autokey so it is out of my way in this case. Thanks for your help!

I have a SQL table that has a number of fields including these two: EmpID char(6) EffDate datetime There can be 1 or many EmpId's. What I am trying to do is find a simple way to delete all the duplicate EmpID's except the one with the most recent EffDate. For example, if this were my data...

I think the curtain can come down on this thread. I got a new HD today and we are back up and running. I'm pretty cinfident that will be that. Thanks to all who offered assistance. And Shmoes, you said you posted that reply in the wrong thread but in fact you didn't. You were just ahead of your...

Well now I am pretty sure what the problem is. I just went to reboot and I am now getting this message: "WARNING: Dell's Disk Monitoring System has detected that drive 0 on the primary EIDE controller is operating outside of normal specifications. It is adviseable to immediately back up your...