• Exporting a (.csv) file from SQL 2005

    Hi, I'm trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have heard that there is a...

    Jeager6640 pointsBadges:
  • Access 2007 DB Project

    Hello, I am setting up a database for a small airline. I have an 'Aircraft_Table' with the fields:

    PhilipG5 pointsBadges:
  • Replace data in a text file using Access 2007

    I need to replace data in a fixed length text file where the line number and position is always the same. Can anyone offer advice on this? Thanks in advance!

    rikkos12310 pointsBadges:
  • personal storage disabled?

    I get this message,"Pst (Personal storage) usage is disabled on this computer" when I try to import my personal files from Office 2003. Previously an Exchange program had been installed - I'm trying to disable it.

    Bolchad5 pointsBadges:
  • oracle

    how to find the difference between structure of the table?

    GOBIKKANNAN5 pointsBadges:
  • Trigger over table that uses transaction inserts

    I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the...

    KSC90 pointsBadges:
  • MYSQL DATABASE!!!

    Hello everyone! please help me about transfering MYSQL DATABASE from one computer to another..... I am a student and got to show a project on JDBC. I am using Windows 7 os and Mysql server 5.1.. Thank you.

    Shagy5 pointsBadges:
  • Writing to multiple fields with one text box

    I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not possible is there a way to...

    Manalyn35 pointsBadges:
  • vb.net development environment

    I am coming out of retirement and have a couple of projects I was going to do in VB6. After doing a little research it became clear that I needed to migrate my development environment from VB6/sp6 to VB.Net. My question is very basic,, what do I need to start VB.Net development? I do not have any...

    GlennSwett5 pointsBadges:
  • Link RDP in Microsoft Access to click computer name to remote control

    I have build a Microsoft Access 2007 database for trouble tickets and inventory.  I have a table called INVENTORY.  One fo the fields is DEVICE NAME.  Right now it is simpy a text field.  In this field we enter the comptuer name (example COMPUTER1234) We have forms which contain the DEVICE...

    Maxwellafb35 pointsBadges:
  • max query expression

    have a very basic table: dwg, dwg rev, rev date - what query expression do I write to show only highest rev?

    Mwatters5 pointsBadges:
  • access 2003 mdb file size increases automatically

    please if you can tell me why size of an access 2003 file automatically increase whereas no data is entered or very less data. it increases upto more than 1 GB. once the same data is imported into another file it is of the size of about 20-30 mb. strange? i have used anti viruses but in vain. plz...

    MKhalidM5 pointsBadges:
  • Select box and enter number into hidden field

    I am trying to find a way to either have the operator click a button or a checkbox and have it enter in a set number (depending on which they select) into a hidden textbox on a form. The reason I am trying to do this is because it is how I need the data set up for another program that we are using...

    Manalyn35 pointsBadges:
  • barcode entered, still dlookup not populating “item” and “price” in the form

    I have two tables, one is "inventory" and the other is "sale". I created form using the fields from "sale". in the "inventory" table, I saved barcodes of all items. Here, I want the form to populate the "item" name and "price" of the barcode I enter in the barcode textbox of the form. Currenty, it...

    Akarimfox5 pointsBadges:
  • 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:

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