>I am working with a proprietary form with about 50 tables (no views) in the DE and the source code removed (Visual AccountMate)

>When the form is run from a workstation on a Novell server, I get an error saying that a table cannot be accessed. No one else is logged in and the server has been downed and re-started. Just prior to calling the form I checked the EXCLUSIVE status and it is OFF.

>When I re-installed the programs and data to a local HDD, the program (i.e. form) ran fine. I then tried copying the tables and DBC from the local HDD to the server. I still got the same problem.

>Can anyone think of a way to tell which table(s) is giving me the headache...instead of the generic msg?

>TIA
>Larry

You could try something like this:

LPARAMETERS tcDBName
LOCAL laTables, lcTableName, lcKey
CD myData
OPEN DATABASE (tcDBName) SHARED
DIMENSION laTables[1]
ADBOBJECTS(laTables, 'TABLE')
FOR EACH lcTableName IN laTables
USE (lcTableName) SHARED IN 0
SELECT (lcTableName)
lcKey=DBGETPROP(lcTableName, 'TABLE', 'PrimaryKey')
SET ORDER TO &lcKey
CursorSetProp('Buffering',5)
ENDFOR

Use the debugger and see wich table gives you trouble. It won't solve your problem but you'll know where to look.