>I've been told it is possible to block people from openning my tables using excel. Does anyone know how to do this using VFP7?
>
>Thank you,
>Bryan Smith
>
>PS: Does it have something to do with database container procedures?

Yes, enable DBC events in your DBC. Open the database, then edit the properties of the database and check the box that say Enable DBC Events, or issue:

DBSetProp('MyDBC','Database','DBCEvents',.T.)

Edit the Stored Procs in the DBC, and add the following method [from VFP Help:

PROCEDURE dbc_BeforeOpenTable(cTableName)
* Just before a table or view is opened. 
* Return .F. to prevent table or view being opened.
   if version(2) <> 2 AND vartype(goApp) <> "O"
      return .f.
   endif
ENDPROC

When you launch your app, make sure you create an object called goApp. Excel and any other software will now not be able to open tables. I added the VERSION(2) to the IF so you can open tables at design time withoug having to create the goApp object.