Search results

  1. E

    MSAccess 2003 File in Network - Exclusive Open

    Hello, I have an access file in the shared folder in the intranet, some guy opened and I think he tried to design something, so that, the file is exclusively opened somewhere in the office, there are a lot of computers, so I don't know who is this guy, but the file is like that since yesterday...
  2. E

    C# Windows Vista

    Hello, I have an small application C# that uses an Access2003 file that is in a network folder location. We have been using Windows XP with this application and everything was fine. However, we got new computers with WindowsVista the application runs fine in those computers with Vista, but...
  3. E

    Delete entries from a table that are not in other table

    Hi, I have a Table1 and Table2. They have a relationship with the column "WorkOrder". Table1 has all "WorkOrders" and Table2 has most of them (but not all). I would like to delete from Table1 the "WorkOrders" that are not in Table2. I think it would be something like that but I am not sure...
  4. E

    Only one entry for a query

    Hi, I have a query for selection, for example: SELECT WorkOrderNumber FROM MyTable WHERE HourPlan > 10 Because I have duplicates of "WorkOrdersNumbers" in MyTable, the query gives me more than one row of a simgle "WorkOrdersNumbers", what should I add to the query to make sure it is only...
  5. E

    Arithmetic Operation - Division in Cero

    Hi, I have a query where I am making an arithmetic operation: SELECT * FROM MyTable WHERE HrsAct / HrsPlan > 1 AND USER = "John" It works sometimes, the problem happen when HrsPlan = cero. I tried to do: SELECT * FROM MyTable WHERE HrsPlan > 0 AND HrsAct / HrsPlan > 1 AND USER = "John"...
  6. E

    Select entries that are present in other table

    Hi, I have two tables, TABLE1 that has a column "ORDER_NUMBER" (the primary key) and I have a second table TABLE2 that has also the column "ORDER_NUMBER" these two tables have relationship between using these two columns. However, I have "ORDER_NUMBER" entries in TABLE2 that has a special...
  7. E

    Select last 50 entries

    Hi, I would like to select last 50 entries for certain table, this table has a primary key a string and it has also the date for insertion of the entry. What would be the SQL query to select the last 50 inserted rows of the table?
  8. E

    Select entries that starts with certain chars

    I have a table that has the primary key a string, I would kike to select the rows that starts with certain chars, for exaple if I have the following entries: P1234 P5647 12324 R4563 P4321 I would like to select those that starts with "P": P1234 P5647 P4321 What would be the query?
  9. E

    Update different rows.

    Hi, How can I update multiple rows using a single SQL command, one of the columns involved is the primary key (User): Example: UPDATE MyTable SET Status = true WHERE User = 'John' UPDATE MyTable SET Status = false WHERE User = 'Peter' How can I do this with one SQL command. Thanks...
  10. E

    DateTime queries

    Hi, I have a table with a column date time (it has day, month, year, hours and seconds). I have two questions: 1: I would like to make a query of entries looking for dates, but I am only interested to compare the DAY, MONTH and YEAR only (ignore the seconds, hour and minute) Lets say...
  11. E

    Selection of blank, empty, null cells

    Hello, I have a C# windows application that access to a data base and make some queries using OleDbDataAdapter I would like to SELECT all entries that have empty, blank or null cells in the table: SELECT * FROM MYTABLE where DATACOLUMN = null I have already tried '' and null but it does...
Back
Top Bottom