Connection to different back-end databases

  • Thread starter Thread starter ReidarT
  • Start date Start date
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
 
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
 
Back
Top