• access 2003 complex query

    Master table has fields: Report_No,Product_ID,Test_Date Detail table has fields: Report_Det,Report_No(Foreign key),Serial_No,Quantity,Result Results table has records: Pass,Fail,R&D,InProcess Detail table have 1,2 or 3 records with different result against each record in Master table. I want to...

    Isqureshi665 pointsBadges:
  • Free IT Book: Why New Systems Fail

    This week's free IT book is Phil Simon's insider's guide to successful IT projects, Why New Systems Fail. From the back of the book, "Organizations often lack the necessary framework to minimize the chance of system failure before, during, and after beginning IT projects." Get the know-how you need...

    MelanieYarbrough6,345 pointsBadges:
  • Database Diagram Tool

    Does anyone know of a free database diagram tool? I downloaded DBDesigner 4 (http://www.fabforce.net/dbdesigner4/), but it's not working the way I would like. I could just create them in Access but that isn't really ideal. I want to create diagrams of an existing database, not to create a new...

    sburkle0 pointsBadges:
  • Free IT Book: Securing SQL Server by Mrdenny!

    This week's free IT book is especially exciting because it was written by Denny Cherry, who you may know better as mrdenny. He's always providing quality and thoughtful answers, and we're excited to share a whole compilation of his knowledge in Securing SQL Server: Protecting Your Database from...

    MelanieYarbrough6,345 pointsBadges:
  • I just narrowly avoided getting scammed (corrupted files)

    I got a phone call from people impersonating some kind of tech support company. I was redirected to http://www.ammyy.com where I downloaded an .exe file which granted them remote control of my computer, and they then proceeded to use said program to run a scan for viruses, spyware and corrupt...

    0 pointsBadges:
  • Public folder database maintenance?

    We have a large contact database (3000+ records) in a public folder(Exchange 2003).  It has a custom form with many user-defined fields.  Does Exchange to any automatic maintenance on these databases?  Is there a maintenance utility I should be running on it? This database contains vital...

    btempleton220 pointsBadges:
  • Windows XP virus Query!

    Hi there, I actually has 2 problems! I`m running Win xp with service pack 2!Mcafee virus scan 2004 Home Edition! 1.Each time i reboot my pc it doesnt load the explorer shell!Only the background is visible but nothing else!What i then need to do is open Task Manager - Processes - and end...

    Wazzup0 pointsBadges:
  • Compressing Old Files

    Hello, I would like to know the option(Compressing Old Files) which comes up during disk cleanup in win XP and win 2000. Is it good or bad? I mean, If I do the compression regularly will that effect my system/files in a long run? Is it same to that option (compress drive to save space) in disk...

    BinooDas123410 pointsBadges:
  • Accessing Data from Dead Thumb Drive

    What do I need to access data from a dead Firefly Thumb Drive? - it contains a Toshiba Disk Drive MK2004GAL. Another number is HDD1422 A ZF03?

    Jacquester5 pointsBadges:
  • QAQQINI File

    What is the QAQQINI file? Does it have to be in every library? I saw someone mention ignore_derived_index and setting it to yes. My files don't even have that value. I have the file in QSYS, QUSRSYS, and one of our test libraries. Are there any other options I should worry about? Currently, any...

    Dcantwell470 pointsBadges:
  • Letting users upload pictures MYSQL Database

    What is the easiest way in DW to allow users to upload a picture to my website. I don't know much coding so ...how can it be done using the functionality of DW. I am using a MYSQL database.

    PBen5 pointsBadges:
  • Creating DB of stories from documents for a website

    I want to create and maintain a database for a personal library; if it works, I would like to make it available online. I know there are several already available but I’m trying to set up something specific – something for the fanfiction community. (For those not in the know, ‘fanfiction’...

    Juliearichards5 pointsBadges:
  • Backup database

    Can I backup database with exception tables?

    Bjet55 pointsBadges:
  • PL/SQL: How to use EXCEPTION statement before INSERT?

    Hi Experts how to use EXCEPTION statement before INSERT stm in PL/SQL Block Please help me with syntax or format is this option possilbe as well?

    Inprise610 pointsBadges:
  • Microsoft Access Date

    Microsoft Access 2003 I have a Today button that uses the command.. Private Sub cmdtoday_Click() 'Sets the Date From and Date To text boxes 'to Today's Date Me!OSJPQFrom = Date Me!OSJPQTo = Date End Sub To put Today's date into my From and To Date fields. The problem is I have these From and To...

    Vadle35 pointsBadges:
  • Open IT Forum: What cloud concern do you need addressed?

    Will all of the buzz surrounding the cloud - no doubt amplified by Vivek Kundra's push to the cloud - are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know...

    MelanieYarbrough6,345 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • DSNTEP2 output problem

    DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don't have ANY experience with REXX, so an example would be appreciated. Jon

    Jonty Walker105 pointsBadges:
  • oracle forms 6i, export, import

    I am a SAN architect. Our test Oracle 6i forms import exports fail intermittently and tables that should fill in 30 – 45 mins run for over 10 hrs without completing. Refreshing the tablespace seems to be the only way to clean this up. For me this is an egregious way of handling the import export...

    Bwright5 pointsBadges:
  • Free IT Book: Governing Shared Services On-Premise and in the Cloud

    This week's free IT book is from Prentice Hall: SOA Governance: Governing Shared Services On-Premise and in the Cloud. From the publishers: "[This book] is the result of a multi-year project to collect proven industry practices for establishing IT governance controls specific to the adoption of SOA...

    MelanieYarbrough6,345 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