Search results for query: *

I have a bat file that is using a "send keys" object. I am trying to automate this but when I put it in the scheduler for Windows 2000, it is ONLY RUN AS A BACKGROUND PROCESS. For XP, it seems like it is run as a foreground process. Is there a way I can create the job so that its run in the...

Here's one that has our whole company stumped. We cannot figure this out for the life of us. Any assistance would be appreciated. We have all Win 2000 servers, and I am trying to place a vbs script that creates a text file from a database and ftp's it to our main server. The process works fine...

Maybe I'm having a brain disfunction, but I'm just trying to map this out in my mind...Seems simple enough tho... I have some records in Excel that have certain columns belonging to two different tables that I need to import into a SQL server database. For example Col1, Col2 go in Table1, and...

Maybe I'm having a brain disfunction, but I'm just trying to map this out in my mind...Seems simple enough tho... I have some records in Excel that have certain columns belonging to two different tables that I need to import into a SQL server database. For example Col1, Col2 go in Table1, and...

A laptop was stolen about a month ago at work - had to be a co worker because its on a secure floor...I had to file a police report etc. Anyway, Just to check i thought I would see if pinging the computer would help...if it was still around on the LAN. I wrote a small .bat program i would...

Hi, I was just wondering if any one has any familiarity with running an export to Excel automatically (perhaps on an ONOPEN function in VB) from a Business objects report upon running? The client I am writing this for is basically using BO as a data extraction tool and would really just like...

I have converted a Access 97 database to Access 2000. When finding records in my form, there used to be an option to "Find First" record or find the first occurrance. Access 2000 doesn't seem to have this option any longer. Am I missing something like a disabled option or anything?

I've done alot of research and I'm not coming up with very much. I have upsized a Access 2000 database to SQL Server, so I can use the Access application as a front end. I notice some serious performance degrade. I have a rather lengthy query (I've attached below one of the slower ones - it is...

I am recieving an error: Unknown Token Recieved from SQL server after running this simple update below. What the update does is take 1 table holding old and new account numbers I am trying to convert, and searches another table and updates it with a new number if the account is found. There are...

I'm working on getting data loaded into a database table on SQL server. I've got 2 Access 2000 databases - 1 has 2003 information in it and the other has 2004-05 info in it. I was having some issues with combining the two, mainly because both Access databases use an Order Number field which is...

I've got such a confusing issue. I've been researching for weeks but cannot find any commonality. Maybe someone can shed some light... I have a client at another company that I interact with via email. They have Outlook installed. I have Lotus Notes on my computer. They always recieve my...

I have about 90,000,000 records in a table I'm trying to update. The log file is expiring though on the SQL server because it is growing too large with information on every update. I was told I need to commit every 100,000 rows or something in order for it to work. Is there a way to specifiy a...

Hi all, I've been searching and I cannot find a reasonable answer. it seems very basic solution, however I just cant seem to find it. Basically what i'm trying to do is I have a table and I need to check a column Accountnumber and if it contains an L in it, update another column named (Desc)...

I have a table(AccountLookup) with a list of accounts that need to update another table(AccountDetail) with a new account number. BUT Not every record in the AccountLookup table has a match. I need to find a way to count Match/Unmatched accounts. The way I am updating is just a simple update...

I have 2 databases, one for the West Coast and one for the East. They are exactly identical in Table Structure and names. There are about 30 tables. The problem I am facing is that we need to bring all the data into ONE database. I've found the Import functionality helpful, but i am unsure how...

Hi all - Is there a way to log if a user has accessed a file? I know I turned auditing on and went into Event Viewer but it does not give me the name of the file the user accessed, just the fact that there was some activity. Any ideas? Thanks!!