Connection to different back-end databases

R

ReidarT

I have an application that looks up a number in a (backend) database and
then closes the connection.
Another database is actual if there has been any changes since last time it
was opened .
Is there any way to check if this database has been changed?
regards
reidarT
 
N

Nikos Yannacopoulos

One way would be to check the back-end db's Last Modified time stamp.
You can get it through something like:

extfile = "Drive:\Folder\FileName of BackEnd.mdb"
Set fldr = CreateObject("Scripting.FileSystemObject")
Set fl = fldr.GetFile(extfile)
lastmodif = fl.DateLastModified

HTH,
Nikos
 
Top