This months Portland FoxPro / Database Developers Group meeting will be held on Monday June 16th at 19.00 in SE portland, please contact me for venue details and / or directions.

We will be looking at using COM objects configured using DCOMCNFG.EXE to facilitate access to the data whilst preventing Users from browsing the same folder.

We will also be showing how to use the Win32 function DeviceIoControl to Lock a Volume - there must be no currently open files on a volume for this to work. But once a process obtains a lock it effectivly has exclusive access to the volume (see FSCTL_LOCK_VOLUME). A side effect of locking a volume (even momentarily) is that the system flushes all cached data to the volume before locking it. For example, any data held in a lazy-write cache is written to the volume.

Houston.