Search results

Hi, Is it possible to select a bunch of data from a table (or more than one table) and get an index in the result set? I.e, I select a bunch of names that all have "ab" in them somewhere from this huge table. In my result set I want an index from 1 (or 0) to x where x is the last row in the...

Hi and thanks for your replies. Thats exactly what I want to do, but what is wrong with the concept? Oh, so if I am using Jet to connect to a .mdb file from my web app, it is not using a RDBMS? If I use a program that is seems to be programmed in acces, it ends with .mdb and when I open it it...

Hi, that I said row and column number where to expalin things, which didnt work :) Anyway, what I want to do is that when the value of a column (on any of the rows) changes I want something to happen. Exactly what I want to happen is this: When a program changes a value in a table, I want to...

Hi, Is it possible to have a procedure that automatically triggers when a field (ex. row 5 column 3 in table tTable) changes? Remember something about that beeing possible in microsoft sql server, but not how and that may have absolutely nothing to do with access. Anyway, thats my question...

Hi again and thanks for your reply. Only problem I have is that I havent created the "other program". Im only using the DB it is using. Guess that means I can't do anything about it then. Mattias

Hi, Is there a way to tell MS Access not to write/read protect a database when it opens it? Trying to do a webapplication that uses some tables in a .mdb database, it is working together with another program that is programmed in MS Access. But the other program locks the db while it is using...