Connection to different back-end databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ReidarT - 30 Apr 2005 08:01 GMT

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

Reply to this Message

Nikos Yannacopoulos - 03 May 2005 08:52 GMT

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

> I have an application that looks up a number in a (backend) database and
> then closes the connection.
[quoted text clipped - 3 lines]
> regards
> reidarT

Reply to this Message