>I was trying to set up Referential integrety on two table and got a message box that I need to clean up DATABASE Item, it sait go have the database design window open and go to the database menu and choose clean up database. When I try that that option is not availiable, I've made sure I had everything exclusive. VFP 6.0
Issuing a CLEAR ALL before opening DB also helps as well. Close the database before trying to reopen it exclusively. e.g. --
open data MyDbc && opens as shared
open data MyDbc Exclusive && does not close the db first, then reopen as excl.
&& this does work with tables.
close databases
clear all
open data MyDbc excl
Mark McCasland
Midlothian, TX USA