MedicRanger

Hi, need some pointers in the right direction. I have three clients written in VB.net that retrieve data from a SQL server database. Each client watches the same table in the form of a datagrid. I would like it if when one client modifies data in the SQL table, it will automatically update the other clients view. I can get away with just having it refresh every 10 seconds or so, but my main goal is to have it automatically refresh instantaneously once an update is made to the database. The nature of the application depends on up-to-the second accurate information. Are there events that I can hook onto in SQL so that my clients can listen to them and trigger a subroutine that will update my datasets automatically? any help will be appreciated. Thanks! :confused:

Hello, I'm new with mobile databases so I have some concerns that you all can help me with. I am designing a mobile patient reporting program that will be deployed on some 10 different laptops. Each night, the databases on the laptops will synchronize with a master database on a server. Supposed to be a simple process right? One of my concerns is this. When uploading records from the laptops to the server, what happens if there are records that have the same ID? For example, what if users on three different laptops create records and the laptops assign the same ID number for the records? What will happen to child tables that are linked by that ID? What kind of code will I need to accuratley upload records from laptops to the database while keeping unique ID's to the records and child tables? Are there any straight-up resources that I can read to help me out with this problem? Any examples? Thanks.

Right now im using MS Access, with an OLEDB connection.

I hadn't tried it yet but if i needed to update 2 tables and add a new row to a third table, can I put all that into one SQL statement? Or do I have to manipulate one table at a time? David

Hey all, I have a problem with inserting new records into a database when it is a child table. I have a connection to an Access database and have a respective data adapter and command builder for each table in the database. When I fill the dataset, I then build the appropiate data relations programmatically and use it how ever I need to. I can delete and modify records from the child tables just fine, but when I try to insert a new record into a child table, I get a "SYNTAX ERROR IN INSERT-INTO STATEMENT" dialog when I try update the database and the process fails. I am guessing it might be a conflict in the command builder, but I don't know how to fix it. Can anyone help me? All datafields are Text except for TripNumber and ID, which are integers. mod_tripdatabase_returntripbyindex.vb

Howdy guys: I am developing a new EMS Computer Aided Dispatch program for an operation I work for. Since we can't afford SQL server, I have to resort to MS Access for a datastore. The way the setup goes is that the dispatch center will have 4 workstations all connected to a central (MS Access) database tucked away on a computer in a closet (well ventilated of course). I can connect to the database and write to the database just fine. However, I need to have all the workstations display the current data in almost real time. When one computer makes an update to the database, I need all the other workstations to reflect the changes right away. I can set up the program to refill the datasets every 2 seconds, but this is too much of a system drain I think, since the listviews I use to display the data clears and redraws itself whenever there is a dataset change. In other words, the listview will clear and refill itself EVERY 2 seconds, period. Not very efficient. Is there anyway to write the code so that every 2-4 seconds it will check the database for any changes and update the workstations dataset only if there is a change? Or is there a better way of doing this? -David