• Database how to connect OpenOffice base to Visual Basic

    How do I connect OpenOffice base to Visual Basic?

    Learn5 pointsBadges:
  • Trigger removed

    How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?

    Anu143525 pointsBadges:
  • Trigger

    Guys, we got a problem here...our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?

    Anu143525 pointsBadges:
  • Trouble creating SQL statement from MS Access Form

    I'm creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while...

    MarcC5 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • MS Access database

    I have a MS Access database with records that I have uploaded to Windows Server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It seems that...

    Mgregory0 pointsBadges:
  • MS Access 2007, IIF and Null expressions

    Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. I believe that I should be using...

    Phil12550120 pointsBadges:
  • Is there a query to search text of all SQL Server database objects that reference a specific table/instance?

    We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

    SQL Server Ask the Experts2,585 pointsBadges:
  • AS/400 – iSeries SQL Update of on table with values from another joined table

    I've use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant'I no...

    Mark90990 pointsBadges:
  • Configuring Cisco Wireless Router

    Greetings, I have a Cisco 871 wireless router and am having problems configuring it to act as a Wireless Access Point for my small internal network using Microsoft Small Business Server 2003. I am trying to set up one client access via wireless. Using Cisco’s SDM Express, when trying to change...

    RP@ADF15 pointsBadges:
  • Applying an ACL in Packet Tracer for class

    I'm having a problem figuring out how to configure the following:Allow hosts on the 192.168.30.0/24 network web access to any destination Allow hosts on the 192.168.30.0/24 network ICMP access to any destination. Explicitly deny any other access origination from the network.Now the they say...

    MRLS71815 pointsBadges:
  • Find and replace text in text file using MS Access VBA

    Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text.Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim...

    Vgnadeau15 pointsBadges:
  • Schedule SQL job to run and export to CSV file

    Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

    Sesa5 pointsBadges:
  • Database connectivity ASP.NET using C#

    Hi, I'm new in ASP.NET so excuse me if this is a stupid question. I'm trying to connect a page to the database but there may be some problem. Please help me...... This the ASPEX file cod: using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using...

    Fabregas5 pointsBadges:
  • ITKE Discussion tool bar

    It's been a few weeks since I had the discussion tool bar. ITKE development can not replicate the problem. Did you experience this problem? How did you resolve it? Thanks Phil 5/7/13 .. added tags that have nothing to do with this task but might get some attention

    philpl1jb49,540 pointsBadges:
  • Upgrade from Access 97 to Access 2010

    Hi All, I have a client requirement to upgrade our existing application which is developed on Access 97 and running on Win Xp to Access 2010 Win 7. The Access 97 database has file like .MDB, .MDE and .MDW. Can someone, please suggest a way to upgrade form Access 97 to Access 2010. This application...

    mercuryspark10 pointsBadges:
  • MS Access 2010 database – contracts and provisions

    Is this possible - legal dept of about 100 people; need database to track perhaps top 250 customer contracts (basic contract info - names/term/type/ID; then need to track how each contract treats certain provisions (affiliates, assignment, insurance, etc). We have standard provisions and can put...

    LegalData5 pointsBadges:
  • Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.

    Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as '%' and if Numeric default till the length of the field with -9999. As per now I'm getting two options. 1. Create the...

    ddaswani170 pointsBadges:
  • I want to assemble a workstation and I don’t know which correct board to use

    I have this task of assembling a workstation, and I have been thinking of what model of system motherboard to use, and what Intel processor type to use and the type of media card to use The workstation is going to be used to hold large amount of data, and stores some high resolution media contents...

    dixton20105 pointsBadges:
  • Crystal Reports 9

    Hi, I'm using Crystal Reports 9 version and in the database expert, it is not displaying all the schemas of the DB2 database connected. Only fewer are displayed. I'm unable to query it even after I have verified all the options such as tables, views etc in the "Options". But none of them have...

    code4565 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