MacroScope your update query worked sort of. It turns out that some of the numbers are duplicate (mis keyed) or are missing so I did not get a clean sequential run. Is there anyway it could accept an entered value and then sequentally assign the values?
I would rather do a query but I don't always know the starting number. It may start with 1 or some other number based on a previous run. For example the first run may be 1...137 the second run may be 234...1896 etc.
I will go the programming route. I am changing the values in the 'value' field as they are blank and need a sequential number assigned based on their town.
I am trying to a simple update query. I have over 1000 records but I need to assign sorted records a sequential value example
------------------------------
Town | Area | Location |
------------------------------
01 | 04 | 01
03 | 01 | 02
06 | 09 | 05
01 | 03 | 02
06 | 01 |...
Resolved the problem. Issue was Symantic Antivirus 10.2 See http://support.microsoft.com/kb/961654 removed Symantic and used Mircosoft Security Essentials and no problems.
I currently use Symantic AV 10. Also the server does not have a static IP which I will change. The strange thing is i set up a VM on the server running WinXP Pro and it never looses its connection. I am planning on replacing the switch to see if it is a switch issue.
I have a Windows 08 Server Standard on a Workgroup. The workstations are WinXP Pro & Home. All of the workstations can access the share folder for about 10/12 hours then all of a sudden it stops. If I reboot the server I can reaccess the share folder. The share is set to full rights for...
The way we currently have it is email comes into a SPAM filter and then sends messages to either server. The problem is when one domain tries to send to the second domain it seems to get lost. I have added the second domain MX record in our DNS. Sometimes the mail makes it most of the tme it...
Is there a way to connect two exchange servers (2007 & 2003) that are on two seperate domains but are on the same network. ie Exchange 07 @ 172.16.17.49 & Exchange 03 172.16.4.11
Currently each user has limited access to their local drive and to network resources. The vendor is requesting that full rights be provided to the users to the %windir% folder. For what I dont know other than they claim that their application will not run correctly. I wish to tell them "No!"...
I nave a vendor who want us to grant administrator rights to the c:\windows folder on each of our workstations. I do not want to do this but I do not have a good reason to tell them so. If anyone has a explination as to why or if there is a Microsoft link to point me to to explain why
I am new to 03 but with in W2K setting up a users home path in AD was not a problem. In 03 I am having a problem. when creating a new user and home folder I am getting an error "The \\JDC\Home Folders\tuser was not created because you do not have create access on the server...."...
What about creating an .rtf file I don't see why an application must be available to create it's file. ie in foxpro you can create a .XLS .WK1 .TXT file and they don'd have to be available. I would assume you could create a .DOC etc file as well?
My exchange server seems to be working some what. Most of my users send and recieve mail but som clam that either it takes days to recieve mail or that they do the person sending gets a message "Mail undeliverable" any suggestions
My exchange server 5.5 w/Exchange service pack 4 and NT SP6 will every 24 to 48 hours will stop responding from the world. localy it will respond fine. If I reboot it it will work fine again. Any one with this problem if so what resolution?
Thanks
I have a group with 2 7316 and 3 7208s . The last three buttons are assigned : Station ID(Intercom#), Station ID (Intercom#), and Handsfree/ Mute. I would like to change the first Station ID to LINK (F71) When I try to change using F*3 and press the button I get a dial tone. Do I have to do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.