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

    ITKE56,495 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:
  • I’m not able to use hints in my tables

    I'm not able to use hints in my tables. TOAD is treating it as comment I think. Do I need to do some setting.????

    Vikas5 pointsBadges:
  • Hyperion Business Rules Error with XP

    We have recently gone on to XP and now we cannot connect to the Hyperion Business Rules designer. The error message is: You are unable to login to the server. com.ms.com.ComError: oracle/jdbc/driver/OracleDriver

    Karzmo5 pointsBadges:
  • Oracle 9i how to create dictionary managed tablespace

    Hi, How can i create database with SYSTEM as dictionary-managed in Oracle 9i?. DBCA creates by default a database with locally managed system tablespace. How can i change it? Thanks in advance.

    Pinki5 pointsBadges:
  • DDS or SQL

    We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?

    Uiiuo50 pointsBadges:
  • Binary Field

    How do I populate a binary field (field length of 9), buffer length of 4, with the value 10002- (right justified) I need to do this in an existing RPG ILE program. Help ?

    Piano510 pointsBadges:
  • HOW TO INCLUDE LOG IN INFORMATION IN AN SQL SCRIPT

    Please I have an SQL update statement which I want to put in an SQL script which users can run to update an oracle9i database running on a windows 2003 server.The statement is as follows: update jobs set JOBSTATE = 3 where APPID = 5 ; COMMIT; Exit I do not want users to be opening the script and be...

    IdongesitDaniel5 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