Linked tables

[Mozz]

Hello,

I've inherited someone elses databases and I'm tryi ng to update some tables to add new fields. When I look at these in design view I get this message:

"Table ... is a linked table with some properties that can't be modified" And it won't let me add these new fields.

How do I get access to change this to allow me to add these fields?

[BTWI'm using Access 2003.]

Thanks for any help

 

[freakazeud]

re:

Hi,
you would actually have to modify the design in the source file of the linked tables. Go to the table tab in the database window...right click on a linked table (identified with a black arrow)...go to linked table manager. This should show you the location of the file which actually houses the table. You would need to open that file to do any design changes.
HTH
Good luck

 

[tarek_habal]

Hi there freakazeud, I am having the same issue and i am positive the excel column is formatted as "number", but when the excel sheets linked to access (via File - Get external data - Link Tables) the field "No of Products" which is formatted in excel as a "Number" shown in access as "Double"

As i have a pivot table based on a union query on two tables (both linked from excel) causing the pivot table to treat as if its not a number so i can get a count but when i use "sum" in the pivot table I get "0" instead of summing the number of products.



any ideas?