Is this possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 14 Jan 2005 20:55 GMT

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.

Reply to this Message

Douglas J. Steele - 14 Jan 2005 22:21 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> We are inventory-ing all our Access databases in preparation for
> converting
[quoted text clipped - 10 lines]
>
> Any help or tips most appreciated.

Reply to this Message

david epsom dot com dot au - 28 Jan 2005 07:42 GMT

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)

> There's no way that I'm aware of to open a database without altering the
> file's timestamp.
[quoted text clipped - 31 lines]
> >
> > Any help or tips most appreciated.

Reply to this Message

John Nurick - 15 Jan 2005 07:09 GMT

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).

>We are inventory-ing all our Access databases in preparation for converting
>all to Access 2000 (we still have many 97).
[quoted text clipped - 9 lines]
>
>Any help or tips most appreciated.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message