Database

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...

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...

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...

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?

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)?

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...

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?

Paste records in OLE Unbound Excel Object in Access Form

Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build a database with a table...

Estimate SQL Server tempdb space for a query

Database - MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge - about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns retrieved 2. Join...

unable to connect to SQL from Access

I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...

Qualified Data Structures

What is a Qualified Data Structure? Where can I find information on them? IBM RedBooks dont seem to have the answer????

new CCNA certifications

Hi all, I have recnetly get my mcsa2003 certification and looking to enter in cisco arena, but confused which track to chose security, wirless or voice. I personally dont consider myself well for security are then 2 left, can anyone advise which is the best in context of future prospective....

MySQL Database - Multiple Images

Hi, I am going to build a database soon for a website that can grow tremendously in the long run when it comes to the amount of records being added. This will be a MySql Database integrating with a Flash website. My main question is how should I handle multiple images being uploaded. A user will...

Access - Bound sub form trying to set the value of an unbound field

I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

Program Described file

I have defiend the program described file (flat file) as update mode and defined the data structure (for the flat file). i'm trying to update the specifice data that i structured in DS. But, when i try to compile, i'm getting an compilation error saying that record format as not defined (for...

Database Last modified.

I have a 150 databases in a server. and i want to know the last modified date of each database

Learning SQL Part 2

Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?

view data from ODBC to Crystal Reports

i am using Crystal Reports 10 to display data from ODBC. The error "Failed to open rowset. Details:HY000:[UVODBC][1401030] ERROR ID:46 Severity: ERROR Facility: DBCAPERR-UCI.Error. Func: SQLPrepare(DML);State:S1000;Universecode:950088; MSg:[SQL Client][Universe]universe/sql syntax error.unexpected...

SQL server as data source for OBI EE

hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but i get following errors when...

Database modeling question

I have a quandry on my hands. Another developer and I are designing a replacement for an older custom application, and we're deep into data modeling. We can't agree on a solution. More precisely, I think it should go one way, he thinks it should go a different way, and I can't quite prove that...