Show on Access form the last modified date of an Excel workbook

[liljet]

***From previous post***
Is it possible to have an Access form that displays in a text box the
last modified date of c:\myworkbook.xls?

try setting the data property of the text box to ...
= FileDateTime("c:\myworkbook.xls")
My Question

FileDateTime works great for me, but the database I put it in is on a
shared drive.

When other people try to use the database they will get an error on
startup of bad expression on the filedatetime. and they are unable to
use the database.

we set the security to everyone full rights and did not help
unsure the issue

[William Hindman]

....leave the record source blank ...in code check to see if the file exists
first ...if it does, enable the text box, make it visible, and set its
record source.

....hth

William Hindman

<li****@charter.netwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...

***From previous post***
Is it possible to have an Access form that displays in a text box the
last modified date of c:\myworkbook.xls?

try setting the data property of the text box to ...
= FileDateTime("c:\myworkbook.xls")
My Question

FileDateTime works great for me, but the database I put it in is on a
shared drive.

When other people try to use the database they will get an error on
startup of bad expression on the filedatetime. and they are unable to
use the database.

we set the security to everyone full rights and did not help
unsure the issue

[Arno R]

Maybe the file can not be found ??

When I understand you correctly it means that you are using a shared FE??
This is a BAD idea!!
This has been told here like every day or so ...

Maybe only put the xls-file on a shared drive ??
Maybe use UNC-Naming ??

Arno R
<li****@charter.netschreef in bericht news:11**********************@74g2000cwt.googlegro ups.com...

***From previous post***
Is it possible to have an Access form that displays in a text box the
last modified date of c:\myworkbook.xls?

try setting the data property of the text box to ...
= FileDateTime("c:\myworkbook.xls")
My Question

FileDateTime works great for me, but the database I put it in is on a
shared drive.

When other people try to use the database they will get an error on
startup of bad expression on the filedatetime. and they are unable to
use the database.

we set the security to everyone full rights and did not help
unsure the issue