• OLE field in UNION query

    I need to join 2 tables, each with a field with an OLE object data type, in a UNION query in MS Access, but I get the message that an OLE field cannot be used in the Select clause of a union query. Does anyone know a work-around?

    Mlwonio90 pointsBadges:
  • Moving file from Linux to AS/400

    how can i get a file from linux to my as400 use to do it with Client Assist but being told that does not exist in linux !

    WILBE5 pointsBadges:
  • SQL Injection in my network

    How can I protect against SQL injections and remove the injection point?  Also, how can I remove an injection that my antivir has detected?  My computer is running extremely slow and I'd like to know what information has been compromised.

    ML35 pointsBadges:
  • Free IT Book: The Official Ubuntu Book, Sixth Edition

    Take advantage of Ubuntu 11.04, and let The Official Ubuntu Book 6th Ed. get you up and running quickly. To win this essential resource, simply answer one of five questions and post the link to your answer in the discussion section below. PSOD with ESX 3.5 MIMIX replication issue What would you...

    MelanieYarbrough6,345 pointsBadges:
  • Open IT Forum: Did you buy a TouchPad?

    HP's decision to discontinue the TouchPad (and its subsequent steal of a price) has been all the buzz the past couple days. Did you bite at the alluring $99 price tag? Tell us what went into your decision, or if you couldn't care less about the TouchPad. Do you think hackers are about to have a...

    MelanieYarbrough6,345 pointsBadges:
  • DFS restrictions

    What are my restrictions for DFS? File limit? Replication Partner Limit? Can we use VSS on the DFS shares?

    TeachMeIT975 pointsBadges:
  • Access lists- host1 should not ping host2 but host2 can ping host1

    hello everyone i'm junell i'm currently studying access list right now doing exercises on packet tracer. i have made two vlans (vlan10 & vlan20). the policy is vlan10 should not ping vlan20 but vlan20 can ping van10. what hapened is  if i configure vlan10 unabe to acces vlan20 which is right. the...

    Junell5 pointsBadges:
  • Open IT Forum: How do you prepare your data center for severe weather?

    Every season has its share of weather threats, and we want to know how you prepare for them. The east coast is gearing up for Hurricane Irene's arrival, and we were wondering what steps you were taking (if any) to make sure your data center doesn't see much (or any) downtime. What unique conditions...

    MelanieYarbrough6,345 pointsBadges:
  • MS Access 2007 Date Query Question

    My question is 2 parts: 1) I need to build a query that will look for dates in a date field that are >= 4 1/2 years from a date specified by the user. For example, if the user enters Sep 2011 the query would return all records in the database that are 4 1/2 years older than the specified date...

    Smidkiff55 pointsBadges:
  • Free IT Book: Essential Skills for the Agile Developer

    The team at Net Objectives (including CEO Alan Shalloway) has compiled the essential skills for the Agile developer. To get this resource and guide to better programming and design, simply answer one of five questions and paste the link to your answer in the discussion section below. Ultrium 4,...

    MelanieYarbrough6,345 pointsBadges:
  • A question about system integration testing

    I have two development teams looking at integrating testers / test developers from traditional QA team. How should we best handle system wide integration testing that would include devices, firmware, and web software? Most books are written for software only teams. Our integration and regression...

    Cwatkins5 pointsBadges:
  • Open IT Forum: Will HP be a worthy cloud contender?

    HP announced its Cloud Services program in beta and we wanted to know initial reactions. Have you registered for the beta? Share your initial thoughts, whether or not you have, and we'll return to this in the next phase of HP's cloud services. Share your thoughts and we'll share 50 Knowledge Points!

    MelanieYarbrough6,345 pointsBadges:
  • SQL Server Help

    Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into.  Example: Select top 1 SerialNo from dbo.Serial --returns 'ASEEADL1234567' based on...

    Cdizl25 pointsBadges:
  • Querying against Views vs Tables

    I have a view that combine several tables, so that the view presents more information that each table taken individually. I want to write an "INSERT INTO ... SELECT ... FROM xxx" query. Should I use the View in that "FROM xxx" or should I expand what the view shows? What's better in terms of...

    Artaxerxes25 pointsBadges:
  • Visual Basic and SQL database design

    i have vb.net & sql  application sql database have one tabe with 37 column (there is no normalization) after runing the application more than three million of rows will enterd by users . I'm afraid  it Will give a bad performance  or have (out of memory massge) so i Made a solution (i...

    msmj8675 pointsBadges:
  • Free IT Book: The Python Standard Library by Example

    This week's free IT book is an essential addition to the developer's library. If you want to master the powerful Python Standard Library through real code examples, this is the prize for you. Simply answer one of five questions and post the link to your answer in the discussion section below. Good...

    MelanieYarbrough6,345 pointsBadges:
  • Windows Server 2003 user

    I set up ofline sync from the laptop and now found that the user on the server under users is missing although i see the user from the laptop as a share i can access the data.

    LRDeWet5 pointsBadges:
  • Separate SUM results on a single line

    Can DB2 return separate SUMfunction within one statement. If I have : SELECT BRANCH,SUM(AMOUNT) ,COUNT(*) FROM TableA WHERE BRANCH IN (180002,180092) gives Branch,Amount,Count 180002,+100,3 can I return two SUMs - one for positive values of amount and one for negative amounts so will get :...

    PeterWarren15 pointsBadges:
  • What is the best why to get started in DBA

    I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self sufficient as...

    CompEng1,185 pointsBadges:
  • Open IT Forum: Goals to round out 2011

    We're approaching the final quarter of 2011: What are some of your IT department's goals to finish out the year? What are some of the things you are implementing to position yourself for 2012? Whether it's updating your system documentation or updating your IT staff's certifications, we want to...

    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