Database

Error 2282 in Microsoft Access

Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...

The most-watched IT questions this week: Sept. 22, 2009

Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

SQL join two counts on same table

I have two different SQL statements that each is a count on the same table, but a count of different columns. I'm trying to combine them into a single statement, but am having trouble doing so.  The two statements are:  SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM...

How do I set decimal places with VB Access

I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...

dbcc checkdb error; object id 0

Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to...

What are the career prospects of three yrs. diploma holder in computer Engg. ?

career related Software/Hardware used: MS office

The most-watched IT questions this week: Sept. 15, 2009

As part of a new feature on the IT Knowledge Exchange Community Blog, we're highlighting the top 10 most-watched questions. Here are the top 5: Virtualization vs. Consolidation, Tracing a computer to an IP address, Connect remote Oracle 11g server in VB 6.0, How to utlize multiple static IP's when...

DB question(s) that I have never heard a direct answer for

In designing a database for use where I work, I ran smack-dab into a few old questions I have always had relating to relational databases.  I say "old" questions because I developed them a long time prior.  However, I think the answers are entirely relevant today (obviously, otherwise I wouldn't...

How to create a virtual shared disk on for a cluster setup?

How to create a virtual shared disk on for a cluster setup? This question is from the Microsoft Virtualization Chat held on August 27th.

Oracle ODBC Windows Server 2003 scheduling issue

I have a win 2k3 server running an MS Access odbc application that automatically links to an oracle database using the Oracle Instant client. The problem is that it runs fine when run from the Servers console as a local machine user, but fails when run from the windows at.exe scheduler. It seems...

PeopleSoft Index Peformance

Should a PeopleSoft table that has only 1 field in it have that field also defined as a key? Software/Hardware used: PeopleTools 8.17 / Oracle 9i

Controlling tempdb Growth

I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...

Do you have any idea approximately when MS & Marathon will have the capability of clustering completed?

Do you have any idea approximately when MS & Marathon will have the capability of clustering completed? This question is from the Microsoft Virtualization Chat held on August 27th.

Community Update: The IT Blog Top 10 for Sept. 10, 2009

As part of a new feature on the Community Blog, each week we'll be doing a run down of the 10 most popular blog posts over the previous week, in case you were wondering what your peers were reading or a hot topic somehow missed your radar. Still think we missed something? Send me an e-mail at...

Error copying indexes in DTS package

I have a DTS package in SQL Server 2000 that copies data from one database to another.  The copy indexes option is checked.  For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over.  At first it was maybe once or twice a...

odbc error while generating crystal reports

Crystal reports are not getting generated with odbc error. After the upgradation of rational tools from SQL to DB2 version, refreshing crystal reports template is not fetching data and end with ODBC Error. What could be the reason for this? Is any settings needed for this upgradation?

How to connect Forms 6i with MS Access

Can anyone help me in connecting the Oracle Forms 6i with Microsoft Access Database. Please send me an example also, so that i may be understood properly and clear my logics tooooo. Best Regards Rashid Shah

What does it mean by related data in a database?

What does it mean by related data in a database?

Flat file

How to copy records from a file to flat file in RPG III Software/Hardware used: AS400

Advantages and disadvantages of MySQL 5.0

Can someone explain me what are the advantages and disadvantages of MySQL 5.0??