• Update Microsoft Access database from VB6

    Using an MS Access database. From a list box I get a record into a text box. Once it is edited it shows in the listbox but the original is there. I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and the new version there? I...

    Codeless5 pointsBadges:
  • Query showing vbCRLF in string data

    Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I'm trying to list records where the user input 2 or more lines of data in a simple text field. E.g., "John Q. vbCRLFSmith" as opposed to just "John Q....

    Sandisk25 pointsBadges:
  • Disconnecting a Crystal 8.5 report while report is open in VB6

    Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which require...

    Slscheer5 pointsBadges:
  • DATABASE FoxPro 2.6

    How to recover a damaged database file in Foxpro

    Prabhakaran20095 pointsBadges:
  • Would you go with iSCSI or Fibre Channel for mass storage in this case?

    Is there any TPS benchmarking available in deciding whether to go for Fibre channel or iSCSI? We are using Oracle database which requires a Terabyte of storage and will be operating at the 1000TPS at peak level. In this case - should we go for iSCSI or Fibre Channel as the mass storage device?...

    BrentSheets6,925 pointsBadges:
  • Using MySQL message API on Windows

    I am new to MySQL message API. I want to use MySQL message API on Windows platform. But MySQL message API is tested and developed on open source platform (Linux, Unix, etc). I think MySQL message API is nothing but a udf, which uses spread toolkit (spread daemon). So I tried to build a dll for the...

    Linux - Ask the Expert270 pointsBadges:
  • Execute a query on table in different db that will make a table in currentdb

    Cheers, I have an Access 2007 application that uses mostly vb.net code to create an excel spreadsheet with all the necessary data in the right places... The program uses a specific set of data that resides in a different database. What I would like to do is connect to the foreign table (which I can...

    Rjwilcox45 pointsBadges:
  • Conversion of table into XML

    How to load a table into XML in a CLOb using Oracle 8.1.4

    SBK20095 pointsBadges:
  • pasting a database query into crystal

    I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?

    Messe5 pointsBadges:
  • What backend works best with Cognos frontend?

    Our company is looking to install Cognos as an upgrade from the Access reporting system we currently use. What is the best backend database to a Cognos frontend? We are considering SQL Server, but aren't sure if that is the best option. Any suggestions?

    Jayne46245 pointsBadges:
  • How to retrieve images from the database programmatically using .NET?

    insert and retrieve pictures from database

    Danielrajthedon5 pointsBadges:
  • Capitalize First Character

    How can ensure that when certain columns in a row are INSERTed/UPDATEd, the first letter of the value is capitalized and the rest are lower case? For example "QUESTION" or "question" should be converted to "Question".

    VelameLaCosa110 pointsBadges:
  • Find and replace in Foxpro 2.06 for DOS

    Hello i am using foxpro 2.06 for dos fro my small application needs. i want use find and replace a character in low level file opening..... ( using fopen() ) pls help. 2nd Q : How to use the ; (semicolon ) as Delimiter in fox 2.06 for dos. Thx Giri

    Giri7525 pointsBadges:
  • ORA-01031 Insufficient privileges

    I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

    SRDBA5 pointsBadges:
  • How to publish a MS Access application as a regular web page in Internet Explorer.

    I'm publishing a Microsoft Access application, on a Windows Server 2008 machine, with RemoteApp. I want to know if there is a way to access this application over the Internet without using the web access feature. To be more precise, I want to publish my application as a regular web page in Internet...

    WindowsServerATE335 pointsBadges:
  • Storing image in Oracle 9i

    how to store and retrieve image having size more than 1 GB in oracle 9i

    Anupama795 pointsBadges:
  • Lotus Notes Calendar to Microsoft Project or Access

    I want to be able to track the current meetings in my Lotus Notes (LN) calendar. Am I am able to link my meeting entries to Project or Access to track them. I realize there are CRM databases and etc. However, I do not want to re-write the information that is already in my meeting calendar. Any...

    Hillars775 pointsBadges:
  • How to use an form field in a SQL from a combobox

    I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn't work. what is the...

    Haro5 pointsBadges:
  • Connect Wireless G ADSL2+ router with Access Point

    i have a d-link wireless g adsl2+router dsl-2640u connect direct to phone line with : ssid=blink ip= 192.168.1.1 wep=0022b0c2cd61 so, i dont have the user name and password for administrator to logon and change the wep code. but,when i connect to access point, the wep of access point didnt take the...

    Army125 pointsBadges:
  • Becoming a networking or database admin with a business information systems degree

    I have a bachelor's degree in Business Information Systems. I can't seem to find a job in IT. I graduated in 2002. I worked as a security officer while going to college. I'm interested in networking or database administration. If you were me what would you next?

    NetworkingATE1,545 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