• Many to one relationship in Microsoft Access query

    I have the following tables: ISSUEREASONS(issueID, issueReason = "PNR Change"), Issues(issueID, partNumber), Parts(PartNumber, DDSID), PNR(PNR, DDSID, PNRChangeReason="PNR Change") where there is mostly all one to one relationships besides there is multiple PNR to DDSID. I need to query for both...

    tabooka15 pointsBadges:
  • Microsoft Access: How to create an entry form for a team event with up to 4 members on each entry form

    I am trying to create an entry form (order form) for a golf event. (There are 5 events per year.) Each event is a team event, involving 4 entrants (members.) So I want the entry form to have the event name once, but each of the four members' names on the entry form. I am having great difficulty...

    janeyr5 pointsBadges:
  • How do insert many images (BLOB) into a SQL Server table

    How do I insert several images (BLOB) in to a SQL Server table?

    cjohnNewVIc5 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh43,735 pointsBadges:
  • What are the Advantages of database system over File processing systems?

    What are the Advantages of database system over File processing systems?

    Pepito5 pointsBadges:
  • Microsoft Access 2016 MSO – How to save data to Table A

    I don't know if the table has to be attached to the form to copy to the table and do I have to click save or does each record save when I reach the end of the row

    dannyboy14145 pointsBadges:
  • How to install Apache with MySQL and PHP on Linux CentOS?

    Hello, How can I install Apache with MySQL and PHP on Linux CentOS? Thank you!

    isophiawilson115 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • How to control AS/400 user profile from updating database?

    There are several user profiles created in our AS/400 server. I need to control some of specific set of user profiles from updating database. Is there any option to achieve this request? Example: Consider Profile1 and Profile2 created in AS/400 server. Profile1 should not have access to update the...

    ganeshpavi75 pointsBadges:
  • What test strategy can we use to test procedure and packages in two different databases

    Scenarios: Some code changes have happened to packages and procedure Here few table\views are replaced .by other table\view. They kept the old packages\proc in one database and modified packages\proc are moved to some other database. Here my question is which kind of testing QA team can perform?

    ramukl5 pointsBadges:
  • DBMS software for knowledge management

    What DBMS software would be recommendable for knowledge management for bureau of agriculture to manage the data for their irrigation projects.

    JalalJebelli5 pointsBadges:
  • Is DBMS_OUTPUT.PUT_LINE works in DB2 tool such as DBvisualizer instead of only in db2Command Line Processor?

    I ant to print output of stored procedure using dbms_output.put_line. I am using DBvisualizer tool.

    rockstar185 pointsBadges:
  • Informix SQL Update using an inner join

    I have a need to update 270,000 records with a particular flag. Using temporary tables and multiple update queries I have creating a staging table to put the original value and the new value. So the table structure is like this: ID ORIG_VALUE NEW_VALUE 1223 A B 1234 D A 1334 ... I'm struggling with...

    bloucks5 pointsBadges:
  • Migrate data from MySQL to SQL Server

    Hi all SQL Server experts, I'm new to SQL Server. Can you please help me out from I want to migrate data from MySQL to MS SQL. What steps do I need to follow? Can you please tell me in step-by-step? Thanks in advance.

    nasarbabu30 pointsBadges:
  • Access Database table validation

    Access database table validation: Set these validation the transaction type is limited to cash or credit card. How can I do that?

    onetimejibb25 pointsBadges:
  • Check if a column exists in SQL Server database

    In a SQL Server database, is there a way to check if a column exists in a table? This is what I came up with but it keeps returning false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') Thanks!

    ITKE380,335 pointsBadges:
  • SQL Server 2008 R2 database isolation change

    I want to change my database isolation to read uncommitted in SQL server 2008 R2. Can someone tell me the exact process and how should I can achieve this?

    edwinjhoffer3,140 pointsBadges:
  • Export SQL Server database to SQL script

    For my SQL Server database, is there a way to export it to an SQL script? I need something like mysqldump. It would take the database's name, and create a script that will remake the tables, data, stored procedures, etc. Does anyone know of anything like this?

    ITKE380,335 pointsBadges:
  • How to save query in Visual Basic

    There's one other thing that might cause a problem. Microsoft Access, if that's what you're using, doesn't support COUNT DISTINCT. (At least, it didn't in Access 97. I don't have Access 2000 or 2003, so I can't test it.) To get around this, just use a saved query, which is the equivalent of a view...

    Habibg7975 pointsBadges:
  • How to fix error in database: Microsoft Office access has detected corruption in this file

    I am in the process of developing an Access 2003 application, and almost done. While I was fixing some errors with controls on one of the reports, seems like the database corrupted. Now, I keep getting "microsoft office access has detected corruption in this file....etc". It instructs me to Compact...

    kennethrich047x5 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