Discussion:
Help with TABLE in DBC
(too old to reply)
John Cosmas
2005-07-23 04:08:43 UTC
Permalink
I have a table that used to belong to a database. I have since removed the
database, but when I USE the table from another app, it says that it belongs
to a DBC. Fox then asks me to choose whether I should delete the link.
How can I remove the link to the table when the DBC file itself is not
longer available?
Fred Taylor
2005-07-23 04:40:31 UTC
Permalink
The link is in the table, too. Removing the link should allow it to be used
as a free table.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
I have a table that used to belong to a database. I have since removed the
database, but when I USE the table from another app, it says that it
belongs to a DBC. Fox then asks me to choose whether I should delete the
link. How can I remove the link to the table when the DBC file itself is
not longer available?
John Cosmas
2005-07-23 16:26:58 UTC
Permalink
So how do I remove the link from inside the table? I keep trying to add the
same table to a database and it keeps telling me the same thing but does not
allow me to unlink the table. The database file is no longer available.
Post by Fred Taylor
The link is in the table, too. Removing the link should allow it to be
used as a free table.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
I have a table that used to belong to a database. I have since removed
the database, but when I USE the table from another app, it says that it
belongs to a DBC. Fox then asks me to choose whether I should delete the
link. How can I remove the link to the table when the DBC file itself is
not longer available?
Fred Taylor
2005-07-23 17:43:40 UTC
Permalink
I tried this. All I had to do was try to USE the table (where the DBC
wasn't present) and it asked to delete the link. I did that and I was then
able to open it as a free table. One it's a free table, it can then be
added to another DBC. A table can only belong to one DBC at a time.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
So how do I remove the link from inside the table? I keep trying to add
the same table to a database and it keeps telling me the same thing but
does not allow me to unlink the table. The database file is no longer
available.
Post by Fred Taylor
The link is in the table, too. Removing the link should allow it to be
used as a free table.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
I have a table that used to belong to a database. I have since removed
the database, but when I USE the table from another app, it says that it
belongs to a DBC. Fox then asks me to choose whether I should delete
the link. How can I remove the link to the table when the DBC file itself
is not longer available?
John Cosmas
2005-07-23 19:10:29 UTC
Permalink
Thanks, Fred. That worked like a charm. As always, you're a life saver.
I'm only trying to get this all done until I can get the application
converted from VFP 6.0 to .NET. Hope you can be patient with me a little
longer. Thanks again.
Post by Fred Taylor
I tried this. All I had to do was try to USE the table (where the DBC
wasn't present) and it asked to delete the link. I did that and I was then
able to open it as a free table. One it's a free table, it can then be
added to another DBC. A table can only belong to one DBC at a time.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
So how do I remove the link from inside the table? I keep trying to add
the same table to a database and it keeps telling me the same thing but
does not allow me to unlink the table. The database file is no longer
available.
Post by Fred Taylor
The link is in the table, too. Removing the link should allow it to be
used as a free table.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
I have a table that used to belong to a database. I have since removed
the database, but when I USE the table from another app, it says that it
belongs to a DBC. Fox then asks me to choose whether I should delete
the link. How can I remove the link to the table when the DBC file
itself is not longer available?
John Cosmas
2005-07-23 19:56:35 UTC
Permalink
Fred;

Now I'm getting an internal inconsistency error when I try to add a table to
the database/DBC. I recall someone saying that there is a patch to 9.0.
Would you please let me know if this should resolve my problem. I'm adding
a 6.0 table to a 9.0 database.

John
Post by John Cosmas
Thanks, Fred. That worked like a charm. As always, you're a life saver.
I'm only trying to get this all done until I can get the application
converted from VFP 6.0 to .NET. Hope you can be patient with me a little
longer. Thanks again.
Post by Fred Taylor
I tried this. All I had to do was try to USE the table (where the DBC
wasn't present) and it asked to delete the link. I did that and I was
then able to open it as a free table. One it's a free table, it can then
be added to another DBC. A table can only belong to one DBC at a time.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
So how do I remove the link from inside the table? I keep trying to add
the same table to a database and it keeps telling me the same thing but
does not allow me to unlink the table. The database file is no longer
available.
Post by Fred Taylor
The link is in the table, too. Removing the link should allow it to be
used as a free table.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
I have a table that used to belong to a database. I have since removed
the database, but when I USE the table from another app, it says that
it belongs to a DBC. Fox then asks me to choose whether I should
delete the link. How can I remove the link to the table when the DBC
file itself is not longer available?
Fred Taylor
2005-07-24 00:35:51 UTC
Permalink
No, there's no patches for VFP9, yet, at least none that I'm aware of. Have
you tried to do a VALIDATE DATABASE on your DBC?
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
Fred;
Now I'm getting an internal inconsistency error when I try to add a table
to the database/DBC. I recall someone saying that there is a patch to
9.0. Would you please let me know if this should resolve my problem. I'm
adding a 6.0 table to a 9.0 database.
John
Post by John Cosmas
Thanks, Fred. That worked like a charm. As always, you're a life saver.
I'm only trying to get this all done until I can get the application
converted from VFP 6.0 to .NET. Hope you can be patient with me a little
longer. Thanks again.
Post by Fred Taylor
I tried this. All I had to do was try to USE the table (where the DBC
wasn't present) and it asked to delete the link. I did that and I was
then able to open it as a free table. One it's a free table, it can then
be added to another DBC. A table can only belong to one DBC at a time.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
So how do I remove the link from inside the table? I keep trying to
add the same table to a database and it keeps telling me the same thing
but does not allow me to unlink the table. The database file is no
longer available.
Post by Fred Taylor
The link is in the table, too. Removing the link should allow it to
be used as a free table.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
I have a table that used to belong to a database. I have since
removed the database, but when I USE the table from another app, it
says that it belongs to a DBC. Fox then asks me to choose whether I
should delete the link. How can I remove the link to the table when
the DBC file itself is not longer available?
John Cosmas
2005-07-25 04:30:49 UTC
Permalink
Fred;

VFP 9 DBC will not let me add the problem table to my database
collection/container. I'm to figure out another way to try and import or
repair this. I suppose you have to first add the table to the database and
then perform the VALIDATE function.

John
Post by Fred Taylor
No, there's no patches for VFP9, yet, at least none that I'm aware of.
Have you tried to do a VALIDATE DATABASE on your DBC?
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
Fred;
Now I'm getting an internal inconsistency error when I try to add a table
to the database/DBC. I recall someone saying that there is a patch to
9.0. Would you please let me know if this should resolve my problem. I'm
adding a 6.0 table to a 9.0 database.
John
Post by John Cosmas
Thanks, Fred. That worked like a charm. As always, you're a life
saver. I'm only trying to get this all done until I can get the
application converted from VFP 6.0 to .NET. Hope you can be patient
with me a little longer. Thanks again.
Post by Fred Taylor
I tried this. All I had to do was try to USE the table (where the DBC
wasn't present) and it asked to delete the link. I did that and I was
then able to open it as a free table. One it's a free table, it can
then be added to another DBC. A table can only belong to one DBC at a
time.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
So how do I remove the link from inside the table? I keep trying to
add the same table to a database and it keeps telling me the same
thing but does not allow me to unlink the table. The database file is
no longer available.
Post by Fred Taylor
The link is in the table, too. Removing the link should allow it to
be used as a free table.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
I have a table that used to belong to a database. I have since
removed the database, but when I USE the table from another app, it
says that it belongs to a DBC. Fox then asks me to choose whether I
should delete the link. How can I remove the link to the table when
the DBC file itself is not longer available?
Fred Taylor
2005-07-25 06:10:46 UTC
Permalink
Is this a DBC that EVER had a table named the same as the one you're trying
to add? If it is, you may have to do a VALIDATE on it to clean it up before
you can try to add the newer table.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
Fred;
VFP 9 DBC will not let me add the problem table to my database
collection/container. I'm to figure out another way to try and import or
repair this. I suppose you have to first add the table to the database
and then perform the VALIDATE function.
John
Post by Fred Taylor
No, there's no patches for VFP9, yet, at least none that I'm aware of.
Have you tried to do a VALIDATE DATABASE on your DBC?
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
Fred;
Now I'm getting an internal inconsistency error when I try to add a
table to the database/DBC. I recall someone saying that there is a
patch to 9.0. Would you please let me know if this should resolve my
problem. I'm adding a 6.0 table to a 9.0 database.
John
Post by John Cosmas
Thanks, Fred. That worked like a charm. As always, you're a life
saver. I'm only trying to get this all done until I can get the
application converted from VFP 6.0 to .NET. Hope you can be patient
with me a little longer. Thanks again.
Post by Fred Taylor
I tried this. All I had to do was try to USE the table (where the DBC
wasn't present) and it asked to delete the link. I did that and I was
then able to open it as a free table. One it's a free table, it can
then be added to another DBC. A table can only belong to one DBC at a
time.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
So how do I remove the link from inside the table? I keep trying to
add the same table to a database and it keeps telling me the same
thing but does not allow me to unlink the table. The database file
is no longer available.
Post by Fred Taylor
The link is in the table, too. Removing the link should allow it to
be used as a free table.
--
Fred
Microsoft Visual FoxPro MVP
Post by John Cosmas
I have a table that used to belong to a database. I have since
removed the database, but when I USE the table from another app, it
says that it belongs to a DBC. Fox then asks me to choose whether
I should delete the link. How can I remove the link to the table
when the DBC file itself is not longer available?
Loading...