Linked Table - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Linked Table

Linked Table# Database - 数据库

y*d2008-02-24 08:02

1 楼

I want to delete some fields for a table in Access, but get the following
prompt:
"Table tblCustomers is a linked table with some properties that can't be
modified. Open it anyway?"
I opened it anyway, but can't deleted fields
who knows what's problem with that?
thanks in advance

j*y2008-02-24 08:02

2 楼

you have to go for the data source

【在 y*********d 的大作中提到】

: I want to delete some fields for a table in Access, but get the following
: prompt:
: "Table tblCustomers is a linked table with some properties that can't be
: modified. Open it anyway?"
: I opened it anyway, but can't deleted fields
: who knows what's problem with that?
: thanks in advance

j*n2008-02-24 08:02

3 楼

you have to find out the relationship b/w those tables.
for example， tblSales is referring tblCustomers. that is, if you delete one
customer information, you will screw up your sales information.
that's so called data integration.
if you really want to delete the customer, you have to go sales table and
delete the sales info for that customer first.

【在 y*********d 的大作中提到】