Hi Jason,
>Then, I go to my database designer and try to "edit referential integrity" for a join. When I do that, I get an error message. It tells me to "clean up database" , by selecting the database tab and choosing that option.
>
>Here is the kicker. It will not let me. The option, "clean up database" isn't in focus( isn't bold).
>
>Any ideas why?
Try this in the command window
CLOSE ALL
OPEN DATA mydata EXCLUSIVE
MODIFY DATA
You should be able to get at the RI Builder now. The problem was that you didn't have exclusive use of the DBC.
HTH,
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development