• trigger to update

    My Table Structure is: Table A Table B Table C colA -PK Col B-PK Col C-PK Col B-FK Col B-FK Col C-FK This relation establish a Concurrent relation where in Cascade Property fails.I can set Cascade property for any two tabnles...but not the third table. My requirement is : 1)To Update PK of Table B...

    Adithi5 pointsBadges:
  • How to manipulate data or values in my tables SQL Server

    A question emailed to us i can now connect the database i made (in mssql server) but the problem is i do not know how to manipulate the data or values in my tables. for example, in my login program. i do not know how to declare that the input of the user must compare first to the login_table (in my...

    ITKE342,835 pointsBadges:
  • MS Access Date Time

    I have a date time filed in MS Access a database and woudl like to be able seperate in a query but so they keep the format settings. ie the date is a date and the time is still a time

    Han848490 pointsBadges:
  • Exporting MS Access data to Oracle

    Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access 'Overflow' error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error....

    M15 pointsBadges:
  • ‘m trying to verify that a SQL DATABASE is empty ,

    I am modifying a VB program that is taking ALL the tables from an ACCESS Database and converting them to a SQL DATABASE. They VB Program opens the SQL DATABASE, but I want to verify the database is completely empty. Is there a function or call that can be added to the code??

    MAB TRIBEFAN5 pointsBadges:
  • Generic database design to store logs of every database change

    Hi there, Can anyone help me out by providing a generic database design for having logs of all the changes to my master table so that I can review all the changes at a later point of time through my application. Every response will be appreciated.... thanks, Sudhakar

    NAGA5 pointsBadges:
  • How to read/write Access 2003 mdb records on server via INTERNET connection

    It seems that I'm a rather thick-headed nubee . . . Here's the scenario - Running SBS 2003 on T105 box. Running Access 2003 on client under XP Pro. mdb has been published to wwroot with FP 2003 with full control permissions set on the folder containing mdb. All works when opening mdb locally. When...

    RalphW25 pointsBadges:
  • i want to know some real time applications of RBMS design algorithms

    while observing the relational model and the algorithms in relational database schema designing there were no real time examples for finding the dependencies, closures, minimal cover,loss less join or dependency preservation.can i get a single relation explaining all these algorithms

    Suchi5 pointsBadges:
  • Microsoft Office & AS/400 Database

    I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.

    Lshipley515 pointsBadges:
  • Community Message: Answer these questions and earn Knowledge Points

    Hi all Here is a link to some questions that still need answers. Take a look a see if you can help out your peers and earn Knowledge Points with every answer. Remember the members that earn the most knowledge points have a chance to win some cool prizes in the contest we are having. You can find...

    ITKE342,835 pointsBadges:
  • IIF clause

    Can you help me build the right IIf field in the query with the following conditions : The field DDU consissts of : DDU :[exworks]*2+0,4+0,01 To the above expression i must also add 0,001 if size = 205, etc according to the following table : 205 0.001 60 0.001 20 0.009 1 1.32 4 0,32 0,5 1,67...

    Peljo20 pointsBadges:
  • Visual Basic IF statement…

    I am trying to write an IF statement that will show a message box if the postcode of the customer begins with one of about 20 area codes. I can get it working for one code, but as soon as I add ' Or "HS*" ' (minus the apostrophes) it comes up with Type Mismatch. What am I missing / doing wrong? If...

    Mandi195350 pointsBadges:
  • Passing DataTable to Web Service Function

    Hi! I have fetched out data into datatable from source database and want to pass this datatable into my webservice function. so that webservice function could insert data into destination database. any help will be highly appreciated. m4atiq.

    M4atiq100 pointsBadges:
  • MS Access Query

    I have a table that has item information by store. I am looking to get back the top 25 items in each store. I can't figure out how to run this. If I use the "Top 25" tag I only get the top 25 through all stores, not by store. Anyone have any suggestions?

    Hollouise5 pointsBadges:
  • retrieving data/tables through ODBC to Oracle

    HI I need to pull up oracle tables through ODBC in access is that possible? help.

    Tacoma for life0 pointsBadges:
  • Table partitioning, CLOB and BLOBs in DB2 9 LUW?

    Hi all, My shop has decided that we will take advantage of DB29 table partitioning for some of our large tables. Some of these table have CLOB, LOB and BLOB columns. We intend to split the large tables across several storage objects. I am looking for someone who have done table partitioning and...

    OKONITA15 pointsBadges:
  • Is there a way to Call a Lotus Notes agent from Access code and pass Variables?

    I'm on a Windows XP Pro System using M.S. Access 2003 and Lotus Notes 6.5. I provide adhoc and ancillary reports to our user community. We now have to send a hotspot to the users to inform them where their Excel files can be found. I created an agent that will send an email to a specific user, and...

    VinceP45 pointsBadges:
  • Setup routines for ODBC driver failing

    I have loaded an ODBC Driver 'PB INTERSOLV OEM 3.11 32-BIT INFORMIX 9 ODBC' driver and receive two errors: "The setup routines for the 'PB INTERSOLV OEM 3.11 32-BIT INFORMIX 9 ODBC' driver could not be loaded due to system error code 126." and "Could not load the setup translator library" After...

    State chick5 pointsBadges:
  • Access Module – calculating work minutes

    I have this code that someone else created and I modified to calculate elapsed time between submit time & complete time but exclude hours that aren't between 6AM & 6PM. The problem I am having is if something is submitted at 6:18PM and not completed until 6:30AM the next day it isn't providing the...

    Noetloj5 pointsBadges:
  • Error while performing full import

    While performing full import, I am getting below mentioned error. Please help me out to resolve the issue. IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942:

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following