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

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/5693DE7D.4090003@verizon.net

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.