Search results for query: *

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...

bcastner: Thanks for the thread. But it isn't working for me. When I enter repair mode I just get a c:\ prompt. It doesn't ask what installation I want to log into or anything. And it recognizes no folders. And even if I do a dir it tells me an error occurred during folder enumeration. When I...

I have a 3 year old Dell Dimension 8100 (1.8GHz processor, 512mb ram, 60gb Ultra ATA/100 Hard Drive, 32mb NVIDIA GeForce2 MX 4X AGP graphics card, 48x cd drive)that had run W2K Professional through its entire life. Over the past few months it began to have problems (hanging when trying to...

Yuck. I sure don't like the sound of that. The XP machine is the one machine on the network that is used for business purposes. So a repair reinstall sounds risky - especially if I am not guaranteed it will fix the problem. I am going to upgrade one of the W2K pc's to XP Professional and see if...

Rrrrrr. I verified everything in your checklist and I am still getting the same error message. Is here something I should be looking at/changing on he W2K boxes?

First, thanks for your assistance. I really appreciate it. Unfortunately, I am still getting that error message saying my workgroup is not accessible and all of that. The changes I made this time were: - I unchecked 'use simple file sharing - recommended'; - Under Internet Protocol TCP/IP...