Disk catalog in Access

[Koen]

Hi all,

I want to create a simple disk catalog system with Access.

The important thing is that I want to make sure that the database has one
record for each file in a certain directory. So, I need some synchronising
mechanism.

First I should loop through all the files in the directory and see if for
each filename there is a record in the database (PK is filename). If not, a
record should be created.

To complete the synchronise I think I should loop through all the records
in the database and see if for each record there is still a file in the
directory. If not, the record should be deleted.

I am a newbie to VBA. I am googling for a whole day now, but I've found
nothing. In this group someone pointed me in the direction of using
FindFirstFile and FindNextFile API. I've tried that, but my knowledge of
VBA is too little.

Can please someone help me with the code?

Thanks,

Koen

[Tom van Stiphout]

On 26 Nov 2003 10:46:44 GMT, Koen <[e-mail]> wrote:

That's not how it works, Koen. The newsgroup is not a code factory.
You write the code, we provide hints and feedback.

If you're not a programmer, become one or hire one. This newsgroup's
official site http://www.mvps.org/access/ has a list of books you
might be interested in.

In the Hints department I might add that FindFirstFile is one approach
worth following. Another one is the use of the Dir function that can
be used to get a list of all files in a folder. To keep things
synchrtonized, I would need to know more about why and how critical it
is. Perhaps you can just delete all old records and re-scan the
folder. For advanced synchronization (requiring advanced programming
skills) you can register your app with the file system, so you can get
notifications when something changes (this is what antivirus programs
use).

-Tom.

Hi all,

I want to create a simple disk catalog system with Access.

The important thing is that I want to make sure that the database has one
record for each file in a certain directory. So, I need some synchronising
mechanism.

First I should loop through all the files in the directory and see if for
each filename there is a record in the database (PK is filename). If not, a
record should be created.

To complete the synchronise I think I should loop through all the records
in the database and see if for each record there is still a file in the
directory. If not, the record should be deleted.

I am a newbie to VBA. I am googling for a whole day now, but I've found
nothing. In this group someone pointed me in the direction of using
FindFirstFile and FindNextFile API. I've tried that, but my knowledge of
VBA is too little.

Can please someone help me with the code?

Thanks,

Koen