• How to replace a record in Microsoft Access 97 with VB 6.0

    I create a program with vb 6.0 and i connected with ms access 97. Now i don't know how to replace an existing record. For example i have the field "A" and the record is "20" now i want to replace "20" with "15"

    Panossg75 pointsBadges:
  • Server Performance online replication

    I have DB of 60 GB on SQL 2000 running on A/P Cluster. I want to do online replication. What would be the impact over Live server performance. Kindly Suggest.

    Natish10 pointsBadges:
  • Adding an index on fields in a SQL Server table

    I have a massive customer table. The ID is the primary key and thus SQL Server makes a clustered index on that. There is no other index on the table. Can I add an index on fields like age, country and gender to make the results faster?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • Access Error importing data from Lotus Notes

    I have a user that is importing data from Lotus Notes into Microsoft Access and is receiving a Microsoft error. I've already verified with IBM that it is not a Lotus Notes issue in any form. Here is an explanation of the process and the error: How the process is done: Opens lotus notes does the...

    Drumradmin5 pointsBadges:
  • Duplicating records in a table with a SQL query

    How can I duplicate every record in a table with a query in SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Problem with Microsoft Access 2003 write permissions

    users have read and write permission to certain forms in the database but after loggin, they could not enter any data to the form,please could help,i checked users&groups account,users&group permission everything seem to be okay but still.is there something i over looked or have not done yet.

    Nahleykema5 pointsBadges:
  • Edit data in an Access Form

    I have done this before, but cant get it to work in my new database. I have created a form that is based off a query in my database. I want my users to be able to type data into one of the fields on my form and the table driving the query will update with what they type. Every form I've created...

    Lydytunes20 pointsBadges:
  • RPG edit code for signed value

    Hi I have moved a numeric value to a ds. I have used this EVAL F1 = %EDITC(ABC:'3')-here F1 is part of flat file DS and there are decimals required in the output file.I am getting the decimals but my problem is that ABC field from i/p file could be negative but am not sure how to get the sign to...

    0 pointsBadges:
  • Iseries Queries.

    Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it's access in access database, but on Mondays I don't get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I've set for YESTERDAYX. How can I change...

    Querys100 pointsBadges:
  • How to check the existence of a Column in SQL Server 2000?

    - using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.

    Hunkgym5 pointsBadges:
  • inventory

    what kind of DBMS do i need for inventory

    Rookie2learn10 pointsBadges:
  • Bulk Collect loop and Cursor Loop

    Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks

    Nikhildhar35 pointsBadges:
  • Microsoft Access 2007 Data Input & Report

    I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 V V With the 3 pieces of information...

    PD15 pointsBadges:
  • What should our next contest be on ITKnowledgeExchange.com?

    We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. I want...

    ITKE54,755 pointsBadges:
  • DB2 SQL Confusion

    I am failing to understand why the following won't work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don't understand why I get higher values...

    ThorButtox5 pointsBadges:
  • Export Access to Outlook

    Is there a simple way to export an Access Database to Outlook? There seems to be an export to Lotus 123 but not one for Outlook, am I missing something?

    Msquared1110 pointsBadges:
  • Slow JDBC DB2 Connection

    Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the...

    Biohazard425 pointsBadges:
  • AS/400 definitions and Password Change Century

    AS400 is new to me and i realy need help... I have 4 questions :) 1. What is the meaning when i see '1' on the column of 'Password Change Century'? 2. How can i see if ODBC is in use in AS400 and if it is in use, how can i see relevant definitions. 3. How can i see if DDM is in use in AS400 and if...

    AS400 - Ask the Expert485 pointsBadges:
  • Look at query results & pass a value to form in ACCESS 2003

    I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the same part...

    Rbrown3805985 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