Is this possible?

[mscertified]

We are inventory-ing all our Access databases in preparation for converting
all to Access 2000 (we still have many 97).

Is there any way to tell the Access version of an MDB and an MDE without
opening the database and without altering the Windows 'Last Access' date?

Also is there any way to tell if there are linked tables without altering
the Windows 'Last Access' date?

I guess if there is a way to set this date, we could store it, then access
the database, then reset it afterwards.

Any help or tips most appreciated.

 

[Douglas J. Steele]

There's no way that I'm aware of to open a database without altering the
file's timestamp.

However, you can look at the tables from outside of the database without
altering the timestamp.

If what you want is to see if there are linked tables, the following will do
it:

Dim dbCurr As DAO.Database
Dim tdfCurr As DAO.TableDef

Set dbCurr = OpenDatabase("C:\MyDatabase.mdb")
For Each tdfCurr In dbCurr.TableDefs
With tdfCurr
If Len(.Connect) > 0 Then
Debug.Print .Name & "-> " & .Connect
End If
End With
Next tdfCurr

 

[John Nurick]

There's software here http://www.aylott.com.au/software.htm that I think
lets you check the Access versions without opening the databases.

Doug's approach will tell you about linked tables.

The GetFileTime() and SetFileTime() API functions can manipulate
timestamps; there's sample VB code at http://www.allapi.net/ (and
probably many other places).

 

[david epsom dot com dot au]

BTW, If you mark the database as read-only, you can open
the database (in read-only mode) without changing the file
timestamp.

Actually, you don't even have to mark the file as read-only
- just open the file in read-only mode. But you have to
be a bit more careful if you try to do it that way.

(david)