|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 1st, 2005, 09:30 PM
|
|||
|
|||
|
how to check if database was modified...
hi guys/gals,
is there a way to check if the database was modified? im using 2 programs/projects using 1 database(ms access). the first one can add, edit, delete entries in the database. the second one is merely for viewing. my problem is if both programs are running at the same time, and the first program, added something to the database. is there a way for the second program to know that there was a change, and refreshes it's entries in the forms (specifically a combo box). thanx in advance! peace! 
|
|
#2
March 2nd, 2005, 11:22 AM
|
|||
|
|||
|
If your database supports triggers you might be able to set up a trigger that updates a "last modified" table.
Another approach is to have your second program update itself on some schedule without worrying if there has been an update or not.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > how to check if database was modified... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
