Access

Deleting Blank Lines

I have more than 2500 record and apprx 400 blank records here and there (i.e. not continuous)..How can i delete these blank records in one command

ms access database

I have a ms access database with records that I have uploaded to windows server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It seems...

SECURE FTP SITE ON Windows 2003

We have a Windows 2003 IIS server setup behind our firewarll which is a PIX firewall. What is the best method to establish a secure FTP site on this IIS server? I have reviewed this topic on the internet and actually talked with somebody from IPSWITCH and the best method available is to purchase...

Roaming profiles from hell

I'm trying to setup roaming profiles for a couple of users. I have the documents and read on how to set it up, which seems real straight forward. I made a directory on the server c:profiles edited the user profile path in ADU&C to point to \myserverprofiles%username% setup a system that I want...

Linking Tables with mdb files(Access 2000) by means of connection information stored in a DSN

I have used the following code but it does not seem to work but hangs up at the point where the Dao is initialed. Help!!!! Public Sub pCreateLinkedTable() Dim strDSNName As String Dim strAppName As String Dim strDatabase As String Dim strUID As String Dim strPW As String Dim strRemoteTableName...

Network Connection Freezes

For some reason, at random, among 20 PCs on my network, in the morning or during the day, the network connection stops responding for both intranet and internet communications. The only solution thus far is to remove the NIC from the Device Manager, reboot the PC, and let Windows XP Pro find the...

SQL SERVER FAILED LOGINS

I'd like to capture failed SQL server logins (all windows accounts based) and auto generate an e-mail to the user. I can't see that these are actually written to any system tables but I do have them in the error log. Any ideas?

Two Domains in one Windows Server

Hi, Can I configure two domains in one windows server

information about sms 2003 server

hello friends, i want to know about SMS 2003 server in telecom company. what is the basic requirenment ? how to install and configure it ? how does it works ? Thanks and regards, jigar vyas (Telecom and Network engineer)

Queying oracle database with MS Access

I am new to Oracle. I am trying to create a query in MS Access on linked oracle tables that use a date range like this: Between FormatDateTime(Now()) And FormatDateTime(DateAdd("yyyy",-2,Now())) This works as long as I dont connect any other tables and add other parameters in other attached...

Network Resource Allocation cum Planning cum Technical Problem

This is the real commercial problem face by my company. Well, the reason I ask this problem is I salute and respect all of you as I believe all of you are as good as network solution company out there, or even better!! Lets me rephrase the entire problem again. Company expand so fast that the...

Database BackUp

Hi e'rybody! I have recently started my new task as a Database Administrator in SQL 2000 after attending a week course DB administration. Well, we have our back ups running through the DB Maintanance and have noticed that some back ups increase too quick in size and as a result an average database...

Batch file execution on win2003

Hi, Is AT command valid for windows 2003 batch files? Is there any delimitor to be used after each statement in batch files?(when run on Windows 2003 platform) Best regards

route mail with fax service in sbs 2003

i have a sbs 2003 on my network and i configure him to get all the fax of my company, the only problem is that when i configure him to route all the incoming fax to some mail it does not seem to work, i check the event log and i get error 32083 and with this massage: Unable to route fax...

Active Directory

Hello everyone!!! I am an IT Administrator for our company and i am looking for a tool that i can use to assist my helpdesk personnels. Every morning users call help desk to notify them that their passwords are locked and help desk just unlock them. Is there no script or anything that I can run to...

Exchange 2003 SP2: Error during install

Hi There, I have installed (tried to) SP2 for Exchange 2003 on a Windows 2003 Srv Std Ed. The install failed first because I had Intelligent Message Filter v1 installed. So I uninstalled it and rerun the SP2 setup program. It failed again on the "Microsoft Exchange Messaging and collaboration...

Start-up Needed for DB design for workflow for BPO company

Can any one give some usefull and urgent tips about database design example where i get for designing BPO company work flow parts...

Microsoft SQL Server Access

We are running Sharepoint with Microsoft SQL Server on a Windows 2k3 Server. At some point the raid controller failed. After being replaced we found the database was marked "suspect" and will not open. There seem to be three parts to the database: dbname_PROF, dbname_SITE, and dbname_SERV. The logs...

Windows admin scripts

Hello, How can I get sample Windows admin scripts? Do anybody know the sources / url's...?

Reg. POP3 Service....

Hii Everybody, I have installed Active dir. with win server 2003 and Exchange server, in my home PC for practice purpose using loopback adaptor.... My problem is that using microsoft webmail i am able to send and receive the mails, but using Outlook express i can not..... i checked POP3 and...