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.

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):

I have a bunch of VFP tables on a Linux file server.

In the same location is a .dbc file for these tables that is not corrupted.

The connection between the workstation and the server is working.

I do not use private data sessions; all environmental settings are

therefore global.

SET MULTILOCKS is ON

SET EXCLUSIVE is OFF

This is a multi-user application.

The database was explicitly opened: OPEN DATABASE [path\dbc file] SHARED

Many things were done.

Much later, we ensured that all users but this one were logged out,

and created a semaphore file on the server that will prevent any

users from logging back in. We are now in a single-user situation. So we issue:

CLOSE TABLES ALL

CLOSE DATABASES ALL

The database is definitely closed at this point. However, issuing a

correctly-formatted USE command on a table in that database is

supposed to explicitly open the database again.

Next, the code issues:

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").

According to MSDN, I have "attempted to write to a write-protected

database container (.dbc) file."

Again, assuming everything I've told you is true, what could be causing this?

Thanks.

Ken Dibble

www.stic-cil.org

_______________________________________________

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/AF.CA.24793.797DF865@cdptpa-oedge01

** 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.