• Data Extract

    What is the easiest way to extract data from a pipe-delimited text file?

    farmgirl165 pointsBadges:
  • Deduplication Backup strategy

    I'm looking for a hardware base dedupe backup solution that does not require additional licensing. 

    Mgtow5 pointsBadges:
  • Outlook 2007 templates in Access

    I am trying to call an Outlook email template from Access app. and I am not sure what I am doing wrong. I can get an email to come up with TO, CC, Subject, and Message text variables when using the DoCmd.SendObject. However, I can not get the Outlook template to come up that I want to use. I have a...

    Rdd111115 pointsBadges:
  • Crystal Report Writer DB Connector error

    What does this error mean? Database Connector Error: '42S02:[DataDirect][ODBC XML driver][XML][Closed Integrator Base] A provider error occurred while calling the underlying provider. IOpenRowset::OpenRowset[Closed XML ADO Provider] returned 80040E37[The table...

    Splows5 pointsBadges:
  • PHP functions

    how do multiple functions work

    SGB35 pointsBadges:
  • tutorials

    hi all. i wanted to ask if anyone knows any sites where i can download free ebooks or free tutorials. thx.

    Mmm5550 pointsBadges:
  • How do I use primary keys in SQL server?

    I have a table called course,and course_id is primary key in this table. I created another table subject.I mapped these 2 tables by course_id as foreign key,I  created another table teacher,i want to map this with subject, only subject_id to teacher_id mapping is required,how i mapp this,can i...

    Shamu75 pointsBadges:
  • docmd.sendobject – “FROM” variable

    I am trying to get Access to send an email from an email address, "response folder", other than mine or anyone else who might be sending an email from the database.

    Rdd111115 pointsBadges:
  • Merging Excel or CSV file to Active Directory

    How can I automatically add users email addresses to their active directory profile? Their email address is their first initial followed by their last name at our domain dot com. I can create an excel or csv file with the data necessary but how can I merge it into AD?

    NewnanIT1,110 pointsBadges:
  • Display External File Properties in Excel

    I have an MS Access database that uses two tables (tblOrders1 and tblOrders2) that are linked to two MS Excel spreadsheet files (Orders1.xls and Orders2.xls). The Excel spreadsheet files are occasionally updated by being replaced with new files with the same file names. I want to continuously...

    OdeMitch35 pointsBadges:
  • Running Profiler, an update statement show reads but no writes?

    Example: last 3 columns are write, rowcount,reads [table] [tbody] [tr] [td]75072[/td] [td]SQL:StmtCompleted[/td] [td]UPDATE UserHdr SET LastActivity = '29-Aug-2010 01:23:24 AM' WHERE UserKey = 'M'[/td] [td]205[/td] [td]2010-08-29 01:23:24.393[/td] [td]The FactorSoft Program[/td] [td]12695[/td]...

    Manodak15 pointsBadges:
  • Substring A Packed Field

    Hello I have a flat record format that I move into an external data structure. Within the external data structure, I have many packed fields. Rather than refer to each of pacekd field by external field name, I would like to be able to substring each packed field out, and then, move the value of...

    Piano520 pointsBadges:
  • Special character in a PF

    Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any of these in iseries

    Rockleadme385 pointsBadges:
  • DB Table/Query Layout for Ranking System

    Hello, I'm building a Membership DB where Members can achieve certain ranks (Rank1 - Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them....

    Artificial15 pointsBadges:
  • In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones?

    In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones? Thanks

    Kadiddlehopper5 pointsBadges:
  • Connect JasperServer and Sql 2008

    i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program...

    Edkettavan5 pointsBadges:
  • how to limit data access on AS400 through ODBC, client access or Sequel viewpoint product

    [strong]User profiles are assigned a group on our iSeries, and the group has object authority to the data files. What data they can actually see and update is controlled by the application, limited by menu travel and other security parameters built into the system. My issue is with Client Access,...

    RSB5 pointsBadges:
  • Network Connection Freezes

    For some reason, at random, among 20 PCs on my network, in the morning or during the day, the network connection stops responding for both intranet and internet communications. The only solution thus far is to remove the NIC from the Device Manager, reboot the PC, and let Windows XP Pro find the...

    DboiSOBE0 pointsBadges:
  • Updating database index

    when i create a table with nearly 100 rows, database index gets update to accomodate those 100 rows. Can i find out the time taken by the index to get updated from previous state to a state to accomodate those 100 rows?

    Ravikanthtodeti5 pointsBadges:
  • What is Referential Integrity in DB2/400?

    What is referential integrity in DB2/400? & What is field reference file in DB2/400?

    40619805 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