Lotus Approach and File Maker Advance Pro 10.0.3
Can anyone help me on how to migrate or import/export or open Ms Excel using these softwares Lotus Approach 2000 and File Maker Advance Pro 10.0.3 please thanks

Answer Question   |  August 25, 2009  8:28 PM
FileMaker Advance Pro 10.0.3, Filemaker Pro, Lotus Approach, Lotus Approach 2000, Lotus Approach and File Maker Advance Pro 10.0.3 softwares

General question about Database Performance Management Software
I was just told that Database Performance Management Software apps are always stand-alone applications. That doesn’t seem right to me. Are DPMS tools always stand-alone? 

Answer Question   |  September 24, 2009  4:12 PM
Access Database, Database performance, Performance management

can you explain what cluster shared volumes are? Is this a new file system?
Can you explain what cluster shared volumes are?  Is this a new file system? This question is from the 7/30 Microsoft Virtualization Chat on ITKnowledgeExchange.com

Answer Question   |  August 21, 2009  9:23 PM
Cluster Shared Volumes, CSV, Microsoft virtualization, Microsoft Virtualization Chat 7/30

Serialization: Mutexes vs. Semaphores
I am looking for a way to serialize access to a RPG program across multiple jobs. I have been doing some research on mutexes and semaphores and I am wondering what the advantages/disadvantages of each are. Also if there are any other ways to accomplish this. Thanks in advance for your reply

Answer Question   |  October 12, 2009  1:22 PM
iSeries, Mutex, RPG, Semaphore

AS/400 SQL BLOBS
I am trying to read data from a SQL table that contains a BLOB of 10MB.  Since the RPG field size is limited to 32KB, is this even possible?

Answer Question   |  August 20, 2009  6:13 PM
AS/400, AS/400 SQL, BLOB, SQL

mysqldatetime exception
mysqldatetime exception i am using MySql  with c# in my window application , In code i think everything is fine , when i made a latest patch for the given installer it throwing an exceptuon at client side ” Cannot perform ‘<=’ operation on MySql.Data.Types.MySqlDateTime and System.String.” when i run it in my application ,it [...]

Answer Question   |  April 13, 2010  5:00 PM
C#, MySQL

Access Query – Repeating fields
I have a file of 70K names. Some are dups. I want to create a indicator in Access to flag when the name is repeated indicate ‘Y’ else ‘N’. Any ideas on how to create a query to do this

Answer Question   |  August 17, 2009  5:27 PM
Access query, Microsoft Access

Using MS Acess SQL Passthrough To AS400 to find wholes in number sequence between to files
Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I [...]

Answer Question   |  August 14, 2009  5:17 PM
iSeries V6R1, Microsoft Access, SQL, V5R4

Why won’t my Access subform stay put?
Hi, I have a main form with a subform below it. The subform supposed to be invisible and 5″ from the top. When I click a button, it becomes visible and 0″ from the top. When I double click the button, the subform is supposed to go back to being invisible and 5″ from the [...]

Answer Question   |  August 17, 2009  4:26 PM
Microsoft Access, Microsoft Access subforms

ACCESS 2007 and SQL Server 2005 Schema Updates
We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP – that is, as reports are added, [...]

Answer Question   |  August 13, 2009  2:56 PM
Access 2007, Microsoft Access, SQL Server 2005

JDBC Connection from JAVA to iSeries DB
I have a simple class that resides on my local drive. I am attempting to connect to iSeries I5V4 environment and do “select” from one of the DB files. When I run my .class file in Rational Application Development I ghet a “class not found” exception. How do I set classpath in RAD? Should my [...]

Answer Question   |  June 30, 2010  6:39 PM
Java, Java Database Connectivity, JDBC, Rational Developer for IBM i

FXP FILES CONVERSION (TO PRG FoxPro program)
fOXPRO REL 2.6 (FOR dos) CAN SOMEBODY GUIDE ME AS TO HOW FXP FILES ARE CONVERTED BACK TO PRG (WITHOUT SPENDING MONEY) ?

Answer Question   |  July 4, 2011  10:36 AM
FoxPro, FoxPro 2.6, FoxPro 2.6 for DOS, PRG

T-SQL query to ACESS 2007 database
I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

Answer Question   |  August 11, 2009  6:32 PM
Access 2007, Access Database, SQL Server 2005, T-SQL, T-SQL Stored Procedures

AS400 File to MS Access by SQL Passthrough Query
I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM RDB.CARF1.INPFP100 INPFP100 Then would do a second query like this: (Query Two) [...]

Answer Question   |  August 11, 2009  1:03 PM
AS/400, Microsoft Access, SQL, SQL Pass Through Query, V5R4, V6R1

Microsoft Access table dropped primary key and index
I am using MS Access 2007 on Windows XP Professional. The main table in my Purchase Ordersdatabase has dropped its primary key and index (no duplicates). Previously, it worked without any problems, and caught duplicate values. Now, when I try to reset the primary key, I get the message, “The changes you requested to the [...]

Answer Question   |  August 27, 2009  4:43 AM
Access 2007, Access Database, Microsoft Access

How to add exchange cluster server to an exisiting exchange server?
I have an existing exchange server 2003 working fine but to add redundancy I want to put new exchange server in cluster mode using the storage EMC CX300 (available). Please let me know how to proceed & what precautions to take & during this process how users will get effected or is that any way [...]

Answer Question   |  August 12, 2009  4:59 PM
Clustering, EMC CX300, Exchange 2003, Exchange Cluster, Exchange server clustering

Forced Date Routine Processing
I’m trying to process a RUNDATE = 2009-08-07 into my COBOL code via a PARM-DATE Link. That date comes in… now I try to place it in the following piece of code: EXEC SQL SET :WS-PREV-WK = CHAR(DATE(TMP-DATE)- 7 DAYS) END-EXEC. What am I getting ’0001-01-01′ returned?

Answer Question   |  August 10, 2009  8:08 PM
COBOL, EXEC, Programming, SELECT

Form vs. table record order
Why doesn’t the record order for an MS Access form match the record order of the table (form keeps re-ordering the records)?

Answer Question   |  August 7, 2009  2:47 PM
Access forms, Microsoft Access

Crystal 8 & SQL problem
I created 80+ reports for the company intranet and they worked great. At the time the ODBC’s were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn’t [...]

Answer Question   |  August 5, 2009  2:19 PM
Crystal Reports, Crystal Reports 8, ODBC, SQL

Bachelor of CSE vs Certifications
Does a bachelor degree in computer science and engineering cover the contents of A+, MCSE or CCNA? If not, why and then what are basic fields of career of a graduate of computer science and engineering?

Answer Question   |  August 4, 2009  8:32 PM
A+, A+ Certification, Careers, CCNA, Certifications, IT careers, MCSE