• Slow SQL Query

    when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where...

    Mxaxyogesh200230 pointsBadges:
  • Microsoft Access Audit Report

    I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...

    WayneW194720 pointsBadges:
  • External document used as an Access Form?

    I remember in Access 2000 you used to be able to import an external document and use it as a Access form after overlaying the table fields. We use a "User Request form" that I would like to use but I do not see where or how to accomplish this with Access 2007(??) If this option has been...

    Rmason345 pointsBadges:
  • Showing a substiute value in a report if conditions are met – Access

    In one of my tables, there is a date field which shows dates of an event happening (called "Issue Date"). This gets input through various measures. Input form or directly into the table or query. One of the reports I am trying to design is a report that will show all materials that have been...

    Gbullo70 pointsBadges:
  • DB backup is hung

    What are the different ways to know if DB backup & archive log backup process have hung. How can we know the average run time of db backup & archive log backup ? What are the advisable checks to be performed / steps to be taken if we observe the backup is slow (determined by average) or has hung.

    Jayeshmb15 pointsBadges:
  • table from gridviewwith sql vs2008

    hello, help, i have a access database with menu items--id, food items, description, price. with vs2008 i have connected to this database. and displayed on a aspx webpage using gridview, i can manipulate it with certain sql statements showing only certain things from the database, but the headings...

    Zpupster65 pointsBadges:
  • Mobile security and access controls

    Does anyone have any recommendations for server mobility software – that provides adequate access controls ensuring only the right people get to the right data?

    SearchMidmarketSecurityATE150 pointsBadges:
  • DO…LOOP and IF ELSE THEN statements

    I am writing a basic program where two types of data are added: 1. a salespersons ID and 2. an amount of cars sold within a month from that salesperson. I have found out how to set the code where the numbers will go where they need to, but adding extra ones does not work, and trying to add any more...

    Norphes5 pointsBadges:
  • With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?

    With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let's say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I'd like the Vendor name to automatically appear on the form when...

    Swd14420 pointsBadges:
  • How do I overcome the “Could not find installable ISAM. Excel 2007″ Error? Ex

    I got the "Could Not find installable ISAM error" while uploading an Excel file in my application.This seems to be happening at the "connection.Open()" code line. -- Web Application -- .Net 2.0 -- Testing using IIS 7.0 on Vista Ultimate -- Office 2007 Enterprise Installed on machine. Code works...

    Donnybrasco10 pointsBadges:
  • Dos attack

    I have been receiving security alert messages from our firewall nearly everyday. e.g TCP Packet - Source:144.120.8.89,39341 Destination:192.168.1.1,25 - [DOS] TCP Packet - Source:210.7.0.36,3473 Destination:210.7.12.23,135 - [DOS] Thu, 2006-10-19 16:30:03 - UDP Packet -...

    92220990 pointsBadges:
  • Microsoft 2003 Access relationship window

    The relationships window is displayed, and you notice that one of the tables has two feilds shownin bold. What does this mean?

    Rmrj5 pointsBadges:
  • Data integration

    I want to import a table from dbase III to Sql server 2005. I also want to automate this process and run it after ever one hour. Is there a simple way to do this task.

    ShSyed5 pointsBadges:
  • SQL embedded in RPGLE

    RPGLE program with five modules updating different set of files. Main module calls others each time a customer is being processed to change some specific detail in many files. There are many customers, so the modules are called many times (LR is set on only at the end of the whole process). Each...

    Mawc10 pointsBadges:
  • FileMaker Pro v8 SAN Backup

    We are running a mission critical application on Filemaker. The FileMaker server, a Dell Poweredge 2650, is configured to conducts scheduled backups 5x daily. However, the backups are saved on the server itself. We want to move the backups to the SAN and conduct the backups at non peak usage times....

    MPDIT55 pointsBadges:
  • dlookup

    how does dlookup work?

    Davva10 pointsBadges:
  • cpytoimpf CSV file showing garbage

    I have an application that does 3 CSV files to import to Excel. All three use the same cpytoimpf program/command, 1 is working correctly and 2 are not. I debugged and do not see a difference. I can view the data just fine with dsplnk on the iSeries/AS/400 but the Excel is all @@@@@@. Does anyone...

    VGP300 pointsBadges:
  • Career matchmaking – program development

    I am interested in making software that allows potential employees to find employers who are offering what they are looking for in a job (be it salary, benefits, location, a specific job, etc). I also would like to have the vice versa of the scenario where the employer can look for a specific type...

    Chister015 pointsBadges:
  • 0 Row affected

    Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM],

    GPNel200675 pointsBadges:
  • How to show two query results in one Microsoft Access report

    I have two queries saved, one shows the record that match a criteria and the othe query shows the record that do not match the criteria. ie. query1 in the feild lastname the criteria is "jones" in query2 in the feild lastname the criteria is Not"jones". What I want to have is a report that shows...

    Leilo5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following