Hi

I'm trying to define the best aproach on a LAN based aplication...
My question is:
should a I open my tables and never close then (to speed up data operations) or in the other end, should I open tables just when I need them, since as I understand, Foxpro tables are fragile and could get damaged in a LAN failure.

I know I should use SQL Server as the best way of doing this, but I'm no expert and dont have that much time to get the proper training and do a SQL Server application.

(any sugestions, samples and so on would be great)

TIA