Microsoft Access
Hello Jaco, Your iif statement probably looks something like this.. Result: IIf([Field1] > [Field2] ,[Field1],Field2) Assuming that Field 1 is a data type of Text and contains the value “150″, Field2 is also text data type and contains the value of “1040″, The above expression will return 150 as Result because a text comparison is [...]

View Answer   |  May 15, 2008  9:08 AM
Microsoft Access

Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!
Update 5/14 Looks like the race is heating up. <a href=”http://itknowledgeexchange.techtarget.com/profile/Labnuke99″>Labnuke99</a> has taken the lead over <a href=”http://itknowledgeexchange.techtarget.com/profile/Gilly400″>Gilly400</a> but there is a battle starting for 3rd place between <a href=”http://itknowledgeexchange.techtarget.com/profile/Vlvpk”>Vlvpk</a> <a href=”http://itknowledgeexchange.techtarget.com/profile/Ysrd”>Ysrd</a> <a href=”http://itknowledgeexchange.techtarget.com/profile/Bvining”>Bvining</a> Still allot of time left so it is anyones contest to win. UPDATE 5/9 The contest is heating up between Labnuke99 [...]

View Answer   |  May 14, 2008  3:04 PM
AS/400, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP

Connect to Sybase ASE 15 via MS SQL 2005
Install the Sybase drivers on the SQL Server, and configure them as needed. You can then create a linked server from the SQL Server to the Sybase server and access the objects using the four part object name.

View Answer   |  May 14, 2008  8:47 AM
SQL Server 2005, Sybase, Sybase ASE 15

Migrate an Oracle database to SQL2005
The migration tool and white papers on Microsoft.com are a good place to start. After creating your new tables and moving your data, you’ll need to rewrite pretty much every stored procedure and function as Oracle and Microsoft SQL both use different languages. After all this has been tested in Dev and QA you can [...]

View Answer   |  May 14, 2008  8:44 AM
Database, Database migration, Oracle, SQL Server, SQL Server 2005

how to get list of encrypted objets in sqlserver 2005?
You can query from the sys.sql_modules DMV. If the definition is null then it’s encrypted.

View Answer   |  May 14, 2008  8:32 AM
Encrypted stored procedures, Encrypted triggers, SQL Server 2005

Best RAID for Database Server
If your primary goals are performance and redundancy therefore best cost unaware raid must be raid 0+1 This gives you max write performance on a zero stripe with full mirror for redundancy. If your really serious about true production get rid of the SATA as MTB (Mean Time Between Failure)is not as good as SAS, [...]

View Answer   |  May 14, 2008  8:08 AM
Database servers, Intel Xeon, RAID, RAID configuration

Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
No, the table will be locked while the index creation command is running.

View Answer   |  May 14, 2008  7:39 AM
Data availability, Enterprise Manager, Indexes, SQL Server 2000, SQL Server Enterprise Manager

VB.NET ans ORACLE database
VB Express should have no problem connecting to an Oracle database. You will need to install and configure the Oracle drivers on the machine which you are doing your development work on.

View Answer   |  May 14, 2008  7:37 AM
Database connectivity, Oracle 10g, VB.NET 2005 Express Edition, Visual Basic 2005

MS Access ActiveX Control
Hi asuasol On your form that has the Calender (name: slct_date), create a comand button, and a bound or ubound field (name : W_Date) with format short date set the On Click of the command button to Event procedure : W_Date = slct_Date When you select a date from the Calender click the command button, [...]

View Answer   |  May 13, 2008  8:24 PM
ActiveX, Calendar control, Microsoft Access

Open Import window via code in MS Access
First, make a macro that will open the form you want. Then customize the menu tool bar: View | Toolbars | Customize. Then go to File | Get External Data and right click on Import. Click Properties. Select the macro you created to open the form from the drop down of the On Action property.

View Answer   |  May 12, 2008  4:30 PM
Database, Microsoft Access, VBA, Visual Basic for Applications

Error – You are not authorised to access this database
Hi, Please check the acl of that database. It should be editor access to user. Also check mail file belongs to option available in tools — preferences. It should be user,s name.

View Answer   |  May 10, 2008  4:24 AM
Lotus Domino, Lotus error messages, Lotus Notes, You are not authorized to access that database

getting the foot in the door
There is a lot of advice on this board for folks like you. Search for “certification” or “experience” or other terms from previous postings. The best advice I can think of is to get experience any way you possibly can. Volunteer to fix or manage computers at your church (if you attend) or some other [...]

View Answer   |  May 9, 2008  1:28 PM
A+, Certifications, IT careers, MCP, MCSE, Network+

Save Access 2007 format as 2000 format with VBA
In your vba macro when you are creating the activedatabase.SaveAs statement add a parameter FileFormat:= (may be databaseformat, I don’t have access here with me right now.)

View Answer   |  May 8, 2008  2:28 AM
Access 2000, Access 2007, Microsoft Access, VBA, Visual Basic for Applications

While loop Vs Cursor
In a cursor you load all the records into memory and run through the records running a command for each one. In a while loop you run the same command over and over until a condition it met which then terminates the loop.

View Answer   |  May 7, 2008  6:46 PM
Database, Development, WHILE Loop

Is there a query to search text of all SQL Server database objects that reference a specific table/instance?
You can search the syscomments table within each database on the SQL 2000 server for the text you are looking for. This will search all procedures, views, triggers and UDFs. However the DTS packages are stored in a binary format, and the easiest method to use it to use is to open then up and [...]

View Answer   |  May 9, 2013  6:26 PM
Database objects, Query, SQL Server migration

Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?
You can setup a SQL Agent Alert for alertID 1480. Then create a job which the alert runs when it is triggered.

View Answer   |  May 7, 2008  6:23 PM
Database mirroring, SQL Server 2005, SQL Server alerts

Split Databases – BE Structural Changes Version: 2007 (12.0)
Quick answer is no you can’t make changes to an Access backend with the users in it because the link to the FE, if it is being used, locks the structure. As far as the front end, it can be on a network drive, but all the users must have full rights to the directory [...]

View Answer   |  May 7, 2008  3:09 PM
Access 2007, Database, Database design, Microsoft Access

Update table to remove invalid char type (tab) Oracle
Finding the rows: select * from table where column like ‘%’||chr(9)||’%'; to change the rows update table set column = replace(column,chr(9),’ ‘) where column like ‘%’||chr(9)||’%';

View Answer   |  May 7, 2008  1:50 PM
Invalid char, Oracle

Embedded SQL in a Cobol program using a sub-select in the select clause
Hi, The field names in your example don’t match up with your error messages, can you post the code that gives the error messages as well. Regards, Martin Gilbert.

View Answer   |  May 6, 2008  2:16 PM
COBOL, Embedded SQL, SQL, SQLPlus

SQL linking to database in XP
Most common beginner problem is – In the ServerHost box did not try ‘localhost’ and in Username did not try ‘root’.

View Answer   |  May 5, 2008  2:07 PM
Database, ODBC, SQL, Windows XP