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