• Create table by comparising 2 tables

    I am new at Access but have some help with creating a db. I would like to know if it is possible to compare table 1: prior data and table 2: current data, and then create a table 3, with all the changes/deletions from the 1st table to the 2nd. All the data is workflow tasks that are dates. I need a...

    Gooies5 pointsBadges:
  • Access control list error: ‘The name is not in the list’

    When I try to remove a Notes user from my ACL, I get this error: "The name is not in the list." Does anyone have any ideas as to why I am receiving this error message?

    Domino Ask The Experts435 pointsBadges:
  • About UPDATE query

    hi friends , i am using VB 2008 . database access 2003 in my project , i include an update query,its below con.Open() Dim cmd As New OleDbCommand("update device set manu='" + mtxt.Text + "',desc='" + dtxt.Text + "',model='" + mdtxt.Text + "',pdate='" + prodate.Text + "',price='" + ptxt.Text +...

    Ashar5 pointsBadges:
  • Issue SQL Query with Localized String through PowerShell

    Hello, I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (') somewhere within the localized string. You can look at the following...

    Bgsullivan15 pointsBadges:
  • Embedded SQL in RPG ILE

    I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven't figured out is how to code the fetch statement to populate variables that aren't known until execution time

    Jeffm125 pointsBadges:
  • Access 2007 Replace operation

    In Access 2007, can a replace operation be performed using wildcard to replace a variable string with a known string.

    Gmmdm5 pointsBadges:
  • Connecting to a remote DB on a UNIX server with SQL

    I am trying to connect to a remote DB on a UNIX server. I am using embedded SQL statements to achieve this task. I have a file that contains DB name, ID & PW that I pass to the connect statement, rather than hardcoding the info to the program (for security reasons). C EstConnect BegSr * C Eval...

    AS400 - Ask the Expert485 pointsBadges:
  • FORMAT keyword in non-join logical files — what and how?

    How do I use FORMAT keyword in a non-join logical file? What is the main purpose of that keyword?

    AS400 - Ask the Expert485 pointsBadges:
  • SQL proceedure to join header and detail file

    I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

    AS400 - Ask the Expert485 pointsBadges:
  • Database design schema for Test Data Management?

    For test data analysis across the builds, platforms etc, we are thinking of storing the test execution results into the database. Please let me know if any one has already designed the db schema for test case & report management.

    Saimadhu455 pointsBadges:
  • Spool to Flat

    Can anyone please guide me on the following: 1) How can I convert Spool to Flat and vice cersa ? 2) If I already have a Flat file. Can I convert it back into spool ? using what utility ? 3) What are the archivers that convert Flat to Spool and vice versa ?

    SyedJR10 pointsBadges:
  • How do you update cisco access point 1200?

    how you update cisco access point 1200 ?

    Rossy145 pointsBadges:
  • IT department administration integration

    My company was just acquired by a larger one, and we are now preparing to combine our IT departments. What is the best way to do this and guarantee that everyone maintains access to the data/resources that they need? Should we create clusters based on who needs what? Can you recommend any...

    Linux - Ask the Expert270 pointsBadges:
  • Not allowed to edit Microsoft Access forms

    A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...

    Donnerblue5 pointsBadges:
  • Connection with two Database for an Application

    I have an application that makes use of 2 different database say A and B. I am working with A but using some datas as views from database B. How can I establish the connection with two database using Bridges?

    Rashik5 pointsBadges:
  • Database Oracle

    hi please answer the question how to create database in oracle9 and link the database in sqlserver 2000 table in oracle and table in sql

    Berouty3020 pointsBadges:
  • Copy data from flat file to a flat file

    My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto 3mb. Can...

    Supriyob2165 pointsBadges:
  • JDBC/ODBC to Excel 2007 getting Exception

    Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at...

    Ansipar288315 pointsBadges:
  • Access mailbox through the file system?

    We are running Exchange 2003 Server Enterprise with SP2, on Windows 2003 SP1. We have a user who wants to make a connection to an Exchange mailbox folder from an MS Access database. I know that Exchange 2000 used to have the M: drive for file system access, but that no longer exists in Exchange...

    Serendipity100 pointsBadges:
  • How much access do you give users?

    I am auditing a enterprise data warehouse and am concerned at the level of access provided. I've found many users who have read, update, and delete rights to all working environments (testing, QA, Production)

    JimHayward5 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