• Switch/Case statment in access

    how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow: Field Name: Directions in this field i need to write codes like: TAm Field Name: Translation here i need to read TAm as T=Take, Am= Morning. the problem i have more than 200 codes, which they have to be...

    Darkblue4615 pointsBadges:
  • Oracle to SQL Server Migration – CURSOR type conversion

    When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

    Kumar937825 pointsBadges:
  • How to copy selected documents to other database

    Hi, I have a view where people can choose documents. Users must have the option to copy the selected documents to an other database located at the same server. My problem is how can i get the selected documents copied to the other database. But users gets an inputbox for filing in a date these date...

    Ruudboy50 pointsBadges:
  • SQL Integration with Oracle10g

    have created a link between our Oracle DB and SQL server db it was succussfulty created and i was able to select data from oracle table using SQLServer. then i have created a view in sqlserver using this link to read from Oracle, the view was created create view dah_test as ( SELECT count(*) as...

    Kmadani35 pointsBadges:
  • What’s the best way to import an Oracle database?

    I have two databases in two different computers, but my databases are the same name, service and password. I recently updated the structure of one and backed it up using exp full=n file=*** and log=*** etc. I now want to imp this backup to the second machine so as to avoid repetitive work. Each...

    OracleATE190 pointsBadges:
  • Export parameters TABLESPACES, TRANSPORT_TABLESPACE in Oracle 9i

    Do we need to set the parameters TABLESPACES, TRANSPORT_TABLESPACE to export table spaces and transportable table spaces meta data even when the parameter FULL = y. Please suggest me what to do for this case.

    Vini Chandamama100 pointsBadges:
  • autobackup

    How do you enable the autobackup for the controlfile using RMAN

    Narmada5 pointsBadges:
  • Database Project Definiton

    A corporation has decided to move its production data off the OS 390 platform to a windows platform running the windows data center operating system. *There are 18 terabytes of data of mission critical data that needs to be available 24 hrs a day. *Because of the size of the customer database they...

    Shifex0 pointsBadges:
  • Setting isolation levels with hibernate and DB2/AS400

    I am using hibernate with DB2/AS400. When I set any isoltion level other than '0' in the hibernate.cfg.xml and try to insert/update data in the table on DB2/AS400, The Exception '' could not update :" occurs. Update is succesful for isolation level 0. Please guide how this can be solved. Following...

    Saurabhjain5 pointsBadges:
  • Problems with the SQL query function

    I am designing a website, and I’m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command “select * from table where ref_id='1001',” it returns 1002, 1003...

    SQL Server Ask the Experts2,585 pointsBadges:
  • inserting

    from front end we will get 20 records at a time.how can we insert them into a table .

    Sarvasumanth5 pointsBadges:
  • Why sqlcode error=100 comes ?

    sqlcode error=100 comes. The required fields are being populated in table. Still why i am getting this error ?

    NAVIN5 pointsBadges:
  • Access database management

    Hi guys I am managing a database and need to know if there is away of moving 'completed' records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having this...

    Timanderson5 pointsBadges:
  • processing biometric data

    can biometric data be incorporated into desktop or stand-alone applications like ms excel and ms access?

    Benibo15 pointsBadges:
  • SQL insert statement

    Hopefully there are some ASP experts put there who can help me. I am trying to write an SQL insert statement to populate an access database from an HTML form. When I submit the form, I am getting page cannot be displayed with the following error message: Error Type: Microsoft VBScript compilation...

    Sturdy2725 pointsBadges:
  • Microsoft Access export to Excel changes values

    I have a table populated through a form using lookup tables. When this table is exported using "right click,export" to excel or dbase, the values appears increased by 1. For example 0 appears as 1, 1 as 2. When just copy and paste, it does not happens

    Lsegura12125 pointsBadges:
  • Overlapping data on a merge replication between three SQL Servers

    We have a merge replication between our three SQL servers at three different locations. One is the publisher and two are subscribers, and we have a primary key on a table (a unique field with is auto-incremental by one). On the publisher’s server, if the user creates a new order, the table...

    SQL Server Ask the Experts2,585 pointsBadges:
  • is there anything in SharePoint that we could use to exchange data or hook into Visual Source Safe 6.0?

    VSS and SharePoint 2007: From what I understand, Team Server 2008 uses the SharePoint platform. Our team has already committed to making a WSS 3.0 SharePoint website and will not be investing in Team Server. I am wondering - is there anything in SharePoint that we could use to exchange data or hook...

    ITKE1,042,645 pointsBadges:
  • Reindex DBF file from Ms-SQL 2000

    Is it possible to reindex an extenal dbf file via linked server ?

    Mic15 pointsBadges:
  • Does a 802.11n access point or router offer an expanded range to 802.11g devices?

    Does a 802.11n access point or router offer an expanded range to 802.11g devices? Thanks.

    Networking Channel ATE30 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following