Write Recordset to MSAccess(mdb) using VB6.0
How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance.

Answer Question   |  August 28, 2009  2:51 PM
Microsoft Access, Visual Basic, Visual Basic 6

MySQL vs. Oracle
what is the major two comparison of mysql5.0 and oracle 10g?

Answer Question   |  September 1, 2009  8:36 AM
MySQL, MySQL 5.0, MySQL vs. Oracle, Oracle 10g

Migrating C code db acess from sybase to sql server 2005 – newbie
I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i’m a bit confused … with ODBC and the use of sqlcli.h i write a simple C code that access the [...]

Answer Question   |  August 25, 2009  7:49 AM
C programming, ODBC, SQL Server 2005, Sybase

Function to find greatest numeric value across different fields
In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?

Answer Question   |  August 25, 2009  2:52 AM
Oracle SQL, WinSQL, WINSQL Numeric Function

Capture SQL Server logged in db User name in Access 2007 Accdb
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way to ”capture the SQL Server logged in user name” in the Access code?  Probably in [...]

Answer Question   |  August 27, 2009  11:14 PM
Access 2007, Access 2007 security, Microsoft Access, SQL Server 2005, SQL Server 2005 security, SQL Server security

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