Modifiying Linked Table

herbc0704

Board Regular
Joined
Jun 22, 2009
Messages
100
I inherited a database. I have been trying to modify a table but I get the following message:

Table 'Sales" is a linked table whose design can't be modified. If you want to add or remove fileds or change their properties or data types, you must do so in the source database.

How do I accomplish that?
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
63,982
Office Version
  1. 365
Platform
  1. Windows
Right click on the tabl name, select Linked Table Manager and see where the source table is coming from.

Also, what exactly is it that you are trying to modify, and for what purpose (the reason why I as asking is because there may be another way around the issue is we know what you are trying to do and where you are going with it).
 

herbc0704

Board Regular
Joined
Jun 22, 2009
Messages
100
Joe,

In this table are extra user definable fields that were designed into the table. I would like to capture information in a couple of fields. The fdata type for tese fields are currently set to text and one of the the fields I would like to capture date time information.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
63,982
Office Version
  1. 365
Platform
  1. Windows
If they were added to the source table, then just refereshing your links should reflect that and start showing the fields.

Just go into the Linked Table Manager liked I described in my last post, checked the table name that has been changed, and click the OK button.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,351
Office Version
  1. 365
Platform
  1. Windows
User-definable fields? How's that working?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,113
Messages
5,857,454
Members
431,880
Latest member
kar2rost

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top