• Navigation Pane

    In Access 2003, my database window showed me all my database objects. Now I have a navigation pane that I have to scroll through to locate things. Is there any way to display all the objects in my database at once?

    Medved5 pointsBadges:
  • Conditional processing in embedded SQL

    I'd like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = 'AgtMaster' C+ Then C+ Fetch Next From...

    Cwc4,290 pointsBadges:
  • User security based on table in database

    I am using Access 2003. I have a small (2 table) database. One table contains unit rework information. The second table contains User information(ID, FirstName, LastName, Security level). I built a form with a place for 3 users to 'sign off' - one for operators, one for supervisors & one for QA....

    Rbrown3805985 pointsBadges:
  • Complex Database Issue

    I'll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is "roughly" the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table (at minimum, 25 tables) can...

    Mreed725 pointsBadges:
  • Microsoft Access menus

    How do you setup menus using MS Access?

    Danljonessr10 pointsBadges:
  • Converting a varchar to a numberic in SQL query

    How can we convert a varchar field to Numberic in a SQL Query in db2 400?

    AS400 - Ask the Expert485 pointsBadges:
  • Granting and Revoking DB2 authority

    We've had several requests to grant 'temporary' SELECT authority on a table (meaning they want the user to have the authority for today, and not tomorrow). The DBAs don't want the housework of remembering to revoke the authority tomorrow, so we were wondering if anyone knows a way to grant...

    Nperk20 pointsBadges:
  • DB2 update query giving error STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.

    The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2? SQLQuery=update EMP set validityenddate='01-JAN-07' WHERE username='XYZ' Exception: msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and...

    Saimadhu455 pointsBadges:
  • Database hang on AIX

    I'm experiencing a database hang and so far I haven't discovered the root cause of the problem. We are running DB2 v9 fixpak 3a on AIX 5.3. The instance is hanging and we can't kill the DB2 processes so the only way to restore services is rebooting the server. The following is the output from the...

    AS400 - Ask the Expert485 pointsBadges:
  • Database offline vs Database stopped vs Database network disconnected?

    How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Oracle ERP single signon using Active Directory

    We are on Oracle 9i and will like to implement a solution to allow Oracle ERP users to signon using Microsoft Active Directory. Thanks Thanks

    Morounfolu15 pointsBadges:
  • Using Dlookup to populate form fields

    I have a simple database with one table(Issue log). What I want is a form that allows for creating a new "issue" within the table or updating the status of an existing issue. I want the form (Issue log) that will update an issues' status to auto-populate based on which issue number you enter....

    Dave4015 pointsBadges:
  • How to push the Database into deadlock state?

    Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.

    Saimadhu455 pointsBadges:
  • How to import Microsoft Access to SQL Server 2005

    hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa

    Deepatss5 pointsBadges:
  • Amending a Product Price without altering existing orders in Microsoft Access

    Platform; Windows XP Microsoft Office - Access 2000 Adapting the example database that was supplied with Access - Northwind Sample Database. I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution. Currently, If...

    Skipy10 pointsBadges:
  • How do I convert a Unix text file from IFS to a DB file on AS400?

    I've got a flat text file that I want to convert from AS400 IFS to a Database file. First I want to convert to a flat file just to prove I can. The File is being Sent via FTP from Unix to AS400/IFS. Files have been sent in both unix txt format and MDOS format. Both files can be displayed on IFS no...

    slack4002,705 pointsBadges:
  • SQL Server database backup (URGENT)

    Hi I have a db backup requirement. As shown in the attached image current system is as follows: There are three source databases such as DB001, DB002 and DB003. Each DB having one table as dbo.EMP and same table schema. Emp table consists of EmpID (PK) and EmpName. One backup database i.e, DBbackup...

    Plugsharma40 pointsBadges:
  • cluster

    what's the steps to use ( Clustering ) in any SQL Server 2005 System??

    ScorpionSQL10 pointsBadges:
  • Mainframe quality assurance testing tools

    I need to find a quick and cheap mainframe testing tool for an insurance application. The client will not spend the dollars till the concept is proven. I have looked for open source for the mainframe and found nothing. The client is running a batch system processing input are batch claims. Any help...

    Frankd0 pointsBadges:
  • Converting SQL data to Microsoft Access through coding in VB.NET

    I have tables in SQL and i want to port them to MS access through coding in VB.NET

    Kiti15 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