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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing connection to linked database 1
BackEnd database through ODBC-connection 7
back up database 7
Access Access, Error Due to Versioning Differences 0
Copy records from one database to another without linking tables 7
Using Access application through a network 1
Password protecting a linked database 3
Ghost references to deleted tables in a back end database (Access2000 XP) 5

Back
Top