I need to keep a few users with windows 98 on an NT 4 network from browsing the internet. Also, they have to be able to send and recieve mail.. Is there a policy i can setup, or a way to block port 80? I need to know.. Or is there a way I can set up a group that is allowed to use internet and...
I have a client who wants to be able to keep certain users from browsing the web, but still be able to retrieve emails. It has been many moons since I have messed with setting system policies on NT 4.0. Is there any way using the policy editor to keep these people from using Internet Explorer or...
I have a win2k terminal server set up that 3 of our users authenticate to to run certain apps. When ever they try to print from either app, it keeps asking them for their user name and password for the printers. The printers are Canon imagerunner printers and each person has a unique user id and...
Hey y'all me again.. I got a massive problem. One of the 2000 servers on my domain is setup to be an ftp server. I have gone into IIS 5 and created the FTP site, set permissions properly on the default folder for that site. My problem is when I try to log on to test it, i cannot logon. The...
I am wanting to be able to send administrative messages to people on my 2000 network. I would use email, but alot of people dont check it often. Is there a way that I can reach all users using the net send command or isthere a better way to reach them. I want the message to pop up on their...
I am wanting to be able to push out administrative updates for win 2k and other apps. How can I package something like a critical update to push out to my end users when they log on? All updates and installs have to be administrativly done
I am designing a web app to resemble a database app i designed in Access. The main page in access shows all the information regarding to providers. there are tabs at the top which take you to different information. Like the first tab gives you all of the location information, and the next gives...
I have an Access crosstab query that I need to make into a stored proc in SQL. My query looks like this:
TRANSFORM Count(Programs.Unit_No) AS [The Value]
SELECT Programs.LicNo, Count(Programs.Unit_No) AS [Total Of Unit_No]
FROM Programs
GROUP BY Programs.LicNo
PIVOT Programs.Program_No;
SQL...
I have created a default value and have bound it to the column. But, it won't put that value into the column when there is a null value.
Here is the select statment I am using for this problem
Select ' ',Count(Sites)
Can Any one tell me why this won't be working, and how should I have the...
I have a set of tables that Gather totals depending on the type of funding (eg. Y, N, M). For those totals I gather that have a null value, I want a 'T' placed in the column next to the count. My question is HOW DO I DO THIS? I am so agitated cause I cannot figure it out.
I have recently run into an issue regarding the ability to compact my database. I have several linked tables to my application. Whenever I try to compact the database, It gives me an error and then won't finish. Could this occur from haveing too many tables with similar of the same column names?
Another Option. I am convinced that What I wanna do is possible using an INSERT INTO with values, I can get the T to populate the proper column. How could I get the count to then populate the other column?
I am doing a Select Count statement and I want to exclude everything in the column ending in an 'x' or an 'e'. With my limited knowledge of this stuff, I would appreciate any help.
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.