• Create a procedure to audit changes done in a database

    I want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.

    Shwetamishra5 pointsBadges:
  • Access 2003 – Setting Form’s Recordsource

    Hi I have a SQL query which I know works.  I tested it by creating a pass-thru query in Access and running the query below: SELECT PcSd.PRICE_SCHEDULE_ID, CASE WHEN PcSd.PRICE_LEVEL_CD IN ('BGA', 'BNG') THEN 'Brand' ELSE 'Generic' End As Price_Level, PcSd.PRICE_TYPE_CD, PcSd.DISPENSE_FEE_AMT,...

    JK012450 pointsBadges:
  • Create a database with Java

    I need to create a database with tables using Java language, only Java. It must be very simple database. maybe you have some sources, books etc. I really need help with this.

    Excelent5 pointsBadges:
  • Convert AS/400 file to Excel and PDF

    I would like to transfer a PF data into Excel but my add-ins not working. Can you provide me any other ways to do that?

    As400programm10 pointsBadges:
  • Back-up copies of the database

    We have an access database that has multiple users for data entry. without fail, we end up with several "back-up" copies. Is this the result of the different users "saving" or is it from having shortcuts on their individual laptops?

    Joyrider64825 pointsBadges:
  • How do you update Cisco access point 1200?

    How can I update Cisco access point 1200?

    Rossy145 pointsBadges:
  • Access 2007 Report displaying the content of three different fields in one box?

    I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & " " & [First Name] & " " & [Last Name] but in 2007 I am getting an error. Any...

    JustDave5 pointsBadges:
  • Access form won’t clear after each entry is added

    I have an access form with an add button. The button adds the record to the table, but the form won't clear that entry out. How do I clear the entry?

    Bonniw5 pointsBadges:
  • How can I view the contents of a damaged DBF file?

    I want to view the contents of a dbf file but one column appears with "strange characters". It seems to be locked or encoded or encrypted. I can see the other columns with no problem. The problem exists only in one column. Is it possible to "unlock or decode or..." and view the contents of that...

    artuaslella5 pointsBadges:
  • How can we migrate Oracle database to Microsoft Access?

    How do I migrate an Oracle database to Microsoft Access?

    Vsrameshkumar025 pointsBadges:
  • GROUP BY MySQL

    Hi, I have started working with a MySQL databse. I need a query that will either make use of "DISTINCT" or "GROUP BY" but that selects the record that has the highest 'VersionNumber' Can anybody suggest how I would achieve this? Thanks in advance.

    LewisT5 pointsBadges:
  • Importing Data GAL entries into Access 2007

    Need to import outlook GAL entries into Access 2007 & have the database updated when I change a field in the GAL entry.

    AGB25 pointsBadges:
  • Connection of Crystal Report 2008 with VB6.

    Please let me know the procedure to bring the controls of Crystal Report 2008 in VB6? What control has to be select and what coding should be use for the same? I'm using SQL 2000 as a back-end. Please help.

    Anishrohlx5 pointsBadges:
  • Which database is better: MySQL or NoSQL?

    We are e-learning company and have a product based on client server model. We are currently using MySQL but facing problems with the installation as it takes longer time to install all the prerequisites. Is there a better way or better database option available? Switching to NoSQL-Mongo DB will be...

    RyanHaris5 pointsBadges:
  • E-mail hacking

    How can I hack my own e-mail address? Is there software available for this (commercial or freeware)?

    Brainstorm225 pointsBadges:
  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When I tried to insert 5000lines of HTML code to the variable in Java, I'm getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • FoxPro 2.6 for DOS

    When programs (small or large) runs in FoxPro 2.6 for DOS the CPU usage showing 100%. How can I solve this problem?

    Zarkos5 pointsBadges:
  • Database connectivity between Microsoft Access and C++

    How can I give database connectivity in code of C++, and my database is stored in Microsoft Access?

    Myinfy185 pointsBadges:
  • Case Statements SQL

    I'm running a query that returns a specific status code. However, within my query that specific status doesn't always exist and I get a null value. I would like to return another status when that is the case. I can't seem to get the case statement to work.

    Wilso01115 pointsBadges:
  • How to use API to access DB2 file on iSeries

    Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he's searched the IBM manual, but he couldn't find the APIs that he can use. Can you help him? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 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