Re: Problem with OLEDB - can't see all tables in DBC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Looks like the problem was partly because there was a constraint on the
table referencing something I hadn't pulled in. That and the VALIDATE
DATA RECOVER helped as well, I'm sure. I removed the constraints as I
don't need them for my purposes here and I am able to reference the
tables again.

Thank you for the quick response.

-Pete Schott

Lee Mitchell wrote:
Hi Pete:

Have you done a VALIDATE DATA RECOVER on the DBC? If you create a new DBC
and ad the two problem tables to it, can you see them?

Do either of the two table have a read only attribute set?

If you copy all the files to a newly created folder can you see them?

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

I've created a DBC file in Fox 8 and added a handful of tables to that
DBC. However, when I try to read from that using OLEDB (VFP 9 - latest
from MS site), I cannot see two of my tables.

I've tried removing, PACKing, and Re-adding the tables in various
orders, but the tables still will not show up. I can see and work with
the tables without too much trouble from inside of VFP.

I'm kind of at a loss on what I need to do to get the tables to show
up. If anyone has any ideas on what I might need to do, I'd appreciate
it.

Thanks.

-Pete Schott

.

Relevant Pages

  • Re: A philosophical newbie issue: catch redundant errors via relationships or programmically?
    ... foreign key reference" that allows me to do the following: ... AccountCD.CD_symbol referencing 'Certificate of Deposit' and ... It is a matter of focus and scale. ...
    (comp.databases.theory)
  • Re: Child records with no parent in 10.2.0.3
    ... >>> SQL> ALTER TABLE temp_child DISABLE VALIDATE CONSTRAINT ... Because the constraint constrains the child table and only the child ... DISABLE VALIDATE will effectively lock the child table from any ...
    (comp.databases.oracle.server)
  • Re: Slow delete.
    ... Tab2, has Clustered PK: AAA,DDD, the referencing rows BBB,CCC and some ... -- The execution plan differs, probably depending on the content of the ... CONSTRAINT PRIMARY KEY CLUSTERED ...
    (microsoft.public.sqlserver.server)
  • Re: Check Constraints using a subquery - SSrvr 2000
    ... The referencing table need to have the referenced column defined as a PRIMARY KEY ... or a UNIQUE constraint. ...
    (microsoft.public.sqlserver.programming)
  • Re: Deleteing rows
    ... Do you have indexes on the FK columns in the referencing tables? ... You can disable the FK constraint, but that disabling ... > The orderid field is used as a FK on many other tables so the delete ...
    (microsoft.public.sqlserver.server)