• Storing values into a 2-Dimensional Array

    Hello, Here I'm directly passing the crystal reports parameters through the code, and generating the report but for some obvious reason, I want the records to be stored first of all into a 2-dimensional array and from there writing it back onto Crystal reports. Note : The reason why I'm looking for...

    Jobseeker1435 pointsBadges:
  • Shared Access Database

    I'm having a problem with opening a shared database in Access 2002. I open it on a specific workstation as a shared database others users cannot open it. But when I open it on any other workstation as a shared database everyone can open it.

    Blbushmen5 pointsBadges:
  • How to create a trigger for updating a table for a quantity decrease?

    How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column? 1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions. 2. The trigger must fire for each row that is...

    OracleATE190 pointsBadges:
  • DB2 and talend

    I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 - A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error

    Jacky160 pointsBadges:
  • Rusty and Need Help

    I've been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone....

    Bluize20 pointsBadges:
  • How can I add Multiple Subdata Sheets to a single Table in Access 2007?

    I'm attempting to add subdata sheets that come from several different tables in my database to my master table. I have found, however, that no matter how I manipulate the different relationships I can only get one subdata sheet to work at a time. Is there anyway to link multiple tables as subdata...

    Zwoods10 pointsBadges:
  • How to find out what is happening in a Database?

    We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database's tables. All I can report is that an insert, update or delete has occurred, the...

    Mjf75 pointsBadges:
  • How to manage memory for SQL 2005 x64 on 64-bit WS2003 Ent

    I have a Windows 2003 Enterprise 64-bit server running SQL 2005 x64 with 32GB RAM. The SQL database is acting as a transaction database. What is the best way to manage memory on this server? Should I adjust the paging file? If so, to what? Any ideas are appreciated!

    Jean.young5 pointsBadges:
  • Not able to coonect to SQL Server 2005 from Front End in windows Vista Home Basic

    Im not able to connect to SQl Server 2005 installed in my local PC to .net application.But im able to open SQL server 2005 seperatley & able to create tables.Im getting connection failed error while trying to connect.Please give slution for this.

    Karanam5 pointsBadges:
  • Access 2007 form from a query

    I have an Access 2007 database that lists rules for specific types of systems. I've run the specific query to pull up the rules I need and put it in a form. The rules are un-editable and that is what I need but how do I get 1 field to be editable so the users can answer the questions posted by the...

    V-Ger5 pointsBadges:
  • MS Access conversion to CSV files

    I am using MS Access 07. Whenever I use the control to export the table as a .csv file, it changes all the fields properties, returning to the "text 255 cha" values. I need specifically to keep the same properties. I used to be able to do it and is not working now.

    Hsisan5 pointsBadges:
  • Sending MS Access reports in the body of an email.

    How to send a report in MS Access to the body of an email in MS Outlook.

    Rarto10 pointsBadges:
  • SQL Query

    I created a SQL query to restore several databases from a remote location to a test environment. I would like to add a check in the script so that it will not run if connected to certain servers so production databases are not accidentally overwritten

    Asdemers5 pointsBadges:
  • Need help with FILEAID in BATCH

    I'm new to FILEAID, so I'd be grateful for some sage guidance on FILEAID command syntax's and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I'm trying (desperately) to create a work-around in order...

    Jonty Walker105 pointsBadges:
  • upgrade cisco aironet access point 1130 from autonomous to lightweight

    please how to upgrade cisco aironet access point 1130 from autonomous to lightweight , how can i do this step by step

    Cisco solutions5 pointsBadges:
  • open a file in access by clicking button

    I have several directory paths in a list box and I want to highlight one and double click on it and have it open the file

    Rmaylath25 pointsBadges:
  • Building A File Searching/ Tagging System

    Hello...I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn't exist, alert user. More description: My name is Steven, I'm a college student and now I'm running my practical session to complete my...

    Stevio10 pointsBadges:
  • Database Window Stuck Behind Title Bar

    When I open a specific database in Access, the Database Window is helplessly stuck behind the title bar. I've tried everything to get it out including closing and reopening, moving menus, everything. Here is a screen shot to show you what I mean: http://i35.tinypic.com/2mq7zux.jpg If anybody could...

    Makeshiftmonkey5 pointsBadges:
  • Refusal to recognize SQL Server 2005 Express on a client PC

    I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that was...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Designing Table Layout

    Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times...can anyone help?

    CMS5 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