Can Access do this?

[Guest]

I need to poll a folder on the network every so often, say every 5 mins to
check for the creation of a text file.
Once this file exists, I need to update a table based on data in it.
I then need to move the file to a store folder.

Is access capable of doing this, or should I look at .NET, and maybe create
an app which runs as an icon in the system tray?

Any help appreciated.

 

[Alex Dybenko]

Yes, access can also do this:
to check if file created - use Dir()
to copy file - FileCopy
to delete file - Kill

 

[Dirk Goldgar]

Yes, access can also do this:
to check if file created - use Dir()
to copy file - FileCopy
to delete file - Kill

And to take some action every 5 minutes, use the Timer event of a form.
Note that the database and form must be open at all times in order for
this to work.

 

[John Nurick]

And to take some action every 5 minutes, use the Timer event of a form.
Note that the database and form must be open at all times in order for
this to work.

For that reason I'd be inclined to do this independently of Access, with
a script that runs as a scheduled task in the operating system. I'd use
DAO to execute an append query against the text file using syntax like
this
FROM [Text;HDR=No;Database=D:\Folder\Subfolder\;].MyFile#txt
with field definitions in a schema.ini file if necessary.

 

[Dirk Goldgar]

And to take some action every 5 minutes, use the Timer event of a
form. Note that the database and form must be open at all times in
order for this to work.

For that reason I'd be inclined to do this independently of Access,
with a script that runs as a scheduled task in the operating system.
I'd use DAO to execute an append query against the text file using
syntax like this
FROM [Text;HDR=No;Database=D:\Folder\Subfolder\;].MyFile#txt
with field definitions in a schema.ini file if necessary.

I'm inclined to agree with you, but we don't know enough about the
details of just how the table is supposed to be updated from the text
file.