1
  • Connect DB2 from MS-Excel

    Hi all! I'm trying to connect the AS/400 DB2 from MS-Excel but I'm Getting Communication link failure .comm rc=10061 - CWBO1049 - The IBM i server application is not started or the connection was blocked by a firewall. I have tried STRTCPSVR *ALL STRHOSTSVR *ALL and PING from PC to SERVER is ok....

    Sureyz2,370 pointsBadges:
  • Find a string in text file using MS Access

    I would like to read a multi-row text file, from inside MS Access, search for a string and returns all its occurences. Sample file: ------------ Patch 123456 : applied on Wed Jun 27 15:42:09 CEST 2009 Created on 23 Mar 2009, 00:48:16 hrs PST8PDT ... Patch 654321 : applied on Wed Jun 25 15:41:56...

    masrawi20105 pointsBadges:
  • Access, Searchable Combo Box within a Form?

    Hello, I'm trying to create a combo list box in an access form that has all 12 months (January, February......etc,) listed and depending on the selection will bring up only that particular month within a range of dates. I don't want it to look at the day or the year, but only the month. Example: I...

    Accote15 pointsBadges:
  • MS-Access data inserted in to Oracle 11g CLOB

    I have an old MS-Access database storing data in bullet point format. I need to transfer this data across to an Oracle 11g EE database version at the same time maintain the MS-Access formatting.  How do I go about this?

    Sgafair5 pointsBadges:
  • Export AS/400 to MS Access

    My auditor wants me to export files from my AS/400 to MS Access and I don't have a clue how to do that or if it can be done. I hope someone does.

    Dowagiac5 pointsBadges:
  • Storing array values into an Access database table from a program

    Hi, I’m trying to write a program that stores the values in an array into a database table. The name of the database is Company.mdb and the table that I want to store values is called Employee. Below is the procedure that is supposed to perform the task. The problem is it doesn’t store the...

    Zigzagzig10 pointsBadges:
  • VBA – Mail Merge Automation via Access

    Hi, I'm not sure why my code is not working.. I have code in vba in Access 03 which opens a word document which runs a mail merge process. When the code runs, it asks me what the Header Delimiters are.  I specified those in the export file as a comma for a field delimiter and <enter> as the...

    JK012450 pointsBadges:
  • multiple records update in single query with where class

    Hi I am doing one project using (Vb6.0 + ms-access) I have two tables [Br style="outline-style: none; outline-width: initial; outline-color: initial;" /> [Br style="outline-style: none; outline-width: initial; outline-color: initial;" /> 1.segment-Table:[Br style="outline-style: none;...

    Srbatcha10 pointsBadges:
  • 32 and 64 Bit SQL 2005 on Same Server

    We need to still link to MS Access databases and understand the 64 bit SQL Server does not allow. So, a thought is to have the new 64 bit SQL Server coexist with a 32 bit SQL Server Express instance. The thought is the 32 bit instance will enable linked server access to MS Access databases. We...

    MxPerry25 pointsBadges:
1

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