y*********d 发帖数: 1013 | 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***y 发帖数: 882 | 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*****n 发帖数: 1781 | 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 的大作中提到】 : 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
|
|