Join for merging records
I’m trying to figure out what the best type of join I could use in TSQL for merging records in about 6 tables where there is a match. So I have 6 different tables where there are many matching records. So I figured that I would use a left join in my first join, keep [...]

Answer Question   |  July 12, 2010  12:08 PM
JOIN statement, SQL Server 2005 Express, SQL Server 2005 merge replication, SQL tables

How to connect db2 to rad 7.5
how to connect db2 to rad 7.5

Answer Question   |  June 30, 2010  7:40 AM
Database configuration, Database connectivity, DB2 administration, DB2 configuration

DB2 / ODBC file availability
We have a new web app that we want to be able to run 24/7. My question from our web staff is  “when the data is available? “. There are 2 situations I can think of that will pose an issue. 1. when we are running file back ups, it most likely will not be [...]

Answer Question   |  July 2, 2010  2:50 PM
AS/400 High Availability, DB2, iSeries, ODBC

Sponsor Post: Cloud Migration Pros and Cons Live Chat Today
Today’s live chat from 1-3 pm EST provides an exclusive opportunity to get your cloud migration questions answered directly from industry experts. Get tips on how to improve your ability to recover in any type of loss or disaster while keeping your budget in check and gain insight into: Data protection requirements Cloud vs on-premises [...]

Answer Question   |  July 8, 2010  2:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Developement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Index with page numbers in Access
We have created a form that we use for a directory in Access. We have created an index as well, but how can I add page numbers that correspond to the correct person/record?

Answer Question   |  July 8, 2010  2:07 PM
Access Forms Database, Access Functions, Document management

How can I write a SQL query to get the database name ?
How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

Answer Question   |  June 30, 2010  11:35 AM
Database name, SQL 2008, SQL Database, SQL Query

Linking users of Access 2003 to SQL Server 2008 database
We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

Answer Question   |  June 28, 2010  8:03 PM
Access 2003, SQL Server 2008, SQL Server database, SQL Server Management, SQL Server Migration Assistant

Sponsor Post: Fear the Cloud? Migration Pros and Cons (on-demand chat from 6/29/2010)
Organizations need to able to quickly recover failed servers and their data in the event of an outage. Deploying a server recovery solution can save a company tens of thousands of dollars in lost productivity and lost business. This live chat on June 29th from 1-3 pm EST provides an exclusive opportunity to get your [...]

Answer Question   |  July 22, 2010  2:05 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

ORA-00902 invalid datatype when trying to create a table with primary key based on two columns in Oracle 10g
I was trying to create a table with primary key based on two columns. Here is the create table statement: CREATE TABLE SECURITY_PASSWORD ( USER_NAME VARCHAR2 (25 BYTE) NOT NULL, USER_PASSWORD VARCHAR2 (25 BYTE) NOT NULL, CREATED_DATE DATE NOT NULL, CONSTRAINT security_password_pk PRIMARY_KEY (user_name,user_password) ); Unfortunately I keep getting error message: ORA-00902 invalid datatype.This is [...]

Answer Question   |  June 26, 2010  5:12 PM
CREATE TABLE statement, Database issues, Oracle 10.2.0.4, Oracle 10g error messages, Oracle Table

In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?
I have some data with a list of Product IDs and I want to assign the Product IDs a category name based the criteria below.  <br><br> IIF Product ID = #*C#* then category name = Cable <br><br> IIF Product ID = 00#* or 497* then category name = Component <br><br> …  <br><br> I can get [...]

Answer Question   |  June 25, 2010  1:52 PM
Access 2003, Access Tables, IIF function, IIF statement, Microsoft Product ID

Print Preview in Access 2007 Database
How can you set up print preview to preview last record in a form. Right now it automatically previews the first record.

Answer Question   |  June 24, 2010  6:38 PM
Access 2007 functions, access 2007 preview and printing, Access 2007 printing, Access Database, Print management

Tattoos in the IT workplace
Is the IT work environment comfortable with tattoos that show, or would it prevent me from acquiring a job?

Answer Question   |  June 28, 2010  6:01 PM
IT career planning, IT careers, IT professional

Linking Carrier and Products in Access 2003
I have a carrier table and a product table. The Carrier table i have CarrierID and Carrier Name. In the Product Table I have ProdID,Carrier, and Product name. What I want to accomplish on a form is when I select a carrier in a combo window and then select Product in another window , I [...]

Answer Question   |  June 24, 2010  5:17 PM
Access 2003, Access 2003 forms, Access Datasheet, Access Tables, Microsoft Access ComboBox

How can I ensure that the invoice data goes to the correct record on the subform datasheet?
I use a form to hold the details of a client. The form has a subform [datasheet] which details each visit that the client makes. To do an invoice for the visit I have a pop-up form. I would like information from that pop-up form to be transferred to the datasheet subform. How can I [...]

Answer Question   |  June 24, 2010  8:46 AM
Access Datasheet, Access forms, Microsoft Access subforms, Visual Basic Data Report

Report Page Header tied to Field in a Make Table in Access 2000
In Microsoft Access: How do I write the control in (properties) of an unbounded box created in a report header to display the a month I query (Criteria -Enter: Month) which then converts to a Make Table?  When I run the query and am asked, “Enter: Month” and I type in “May”, I want May to show up in my report page [...]

Answer Question   |  June 24, 2010  1:54 PM
Access 2000, Access query, Access Tables

MS Access DATABASE and combobox in VB6.0
hellooo plz i need help  i am new to VB6.0 and i’ve learned alot now i have a database in MS Access and i want to create a combobox named (Combo1) that will be populated from the field (Name) in table (Customer) in the database (weighbridge.mdb) and then when i choose a name in the [...]

Answer Question   |  June 23, 2010  8:01 AM
Access Database, ComboBox, Microsoft Access, VB 6.0, Visual Basic

Flat file or Physical file in as/400?
How to know whether a file is physical file or flat file in CL/400?.

Answer Question   |  June 23, 2010  2:34 PM
AS/400, AS/400 flat file, CL/400, Flat files, Physical File

Looking for software to allow arbitrary apps to share arbitary data amongst themselves
I’m looking for a software that would allow arbitrary applications to share arbitrary data amongst themselves. Data suppliers could communicate with the service to “publish” what data they have available. Consumers can ask the service for what data is available. Consumers do not necessarily work in a “subscribe” model, because there may be a large [...]

Answer Question   |  June 22, 2010  1:42 PM
Data storage, Open source software, Shared databases, Storage in 2010

Direct synchronization in Access 2003
The Direct synchronization in Access 2003 “Synchronize Now” has stopped working. The popup window named ‘Synchronize Database ‘program name”” does now display anymore. It seems to me that a switch of some type has become disabled, but I’m not sure.

Answer Question   |  June 23, 2010  6:03 PM
Access 2003, Access errors, database synchronization

How to send a binary payload with request in JMeter?
Hi everyone, I’m new to Jmeter and couldn’t figure out yet how to send binary data to the server as the body of a POST request. Thanks in advance.

Answer Question   |  June 21, 2010  11:40 AM
Apache, Binary data, JMeter