On 1/8/2016 10:37 AM, Ken Dibble wrote:

Hi folks,

I realize that at this stage of my career I should really understand the simple stuff. Apparently there's something I don't understand though.

It's not so much "understanding the simple stuff" as it is wading through the frequent (often useless) underlying OS differences and quirks from version to version. No one can understand it all.

For this scenario, please humor me by assuming that all of the following is true (some of it is verified by my error logging system, but the system does not explicitly test each of these assertions):

...

CLOSE TABLES ALL CLOSE DATABASES ALL

...

IF NOT USED [appropriate alias, of which there can be only one for this table] USE [full correct path\some.dbf] IN 0 ENDIF

The USE line sometimes, but not very often, generates Error 1569 ("Database [path\dbc file name]: File access denied").

I recommend opening the database (use the OPEN DATABASE command) before performing the USE statement. And, in fact, if you do you that do not need to path qualify the DBF (note: I always path qualify my OPEN DATABASE though <g>).

-Charlie