A large number of WAN users accesses (read-only) a single record in a table
trough SQL to a dbsrvr (very efficient).

5-8 administrative users on the same LAN as the dbsrvr must be able to view
the the same table (1000 records) in a table view and edit a record now and
then - making the changes immediately readable to the WAN users.

For the local administrative program - should I access the table as a local
table (from the server on the LAN) - or should I use the dbsvr also
locally??

It looks like to be more efficient to access the table locally as file
tables - but is this the better solution?

If a LAN PC crashes with the table open - is there a risk on crashing the
table - making the table unavailable to all the WAN users?

All comments are greatly appreciated.
Im using standard DBISAM 4.25.

Michael, Denmark

Michael,

<< For the local administrative program - should I access the table as a
local table (from the server on the LAN) - or should I use the dbsvr also
locally?? >>

I would also use the dbsrvr for the admin access.

<< If a LAN PC crashes with the table open - is there a risk on crashing the
table - making the table unavailable to all the WAN users? >>

Yes, which is why I recommend the above.

--
Tim Young
Elevate Software
www.elevatesoft.com