How do i modify a property in a linked table

B

Bill Kraut

I have a linked table and i am tring to change my country field from 10 to
15, its not letting me, it says i cant save because it a "linked table"
please send me info at [email protected]
Thanks
Bill Kraut
 
R

Rick B

You need to open the table in the database to which you are linked. You
can't change the properties in another database.

You most likely will not get an email response here. That kinda defeats the
purpose of posting to a newsgroup where folks can look back and find answers
to their questions in the future (in other words, these are designed for
people to try to help themselves first by searching for an answer).

Rick B
 
B

Bill Kraut

I try to open the table in design view, and it tells me that my table
"members" is a linked table with some propertys that can't be modified, do
you want to open it anyway (Yes or No) So I click yes it opens, then i goto
the country field and change it from 10 to 15 and try to save and it wont
save it.
Bill
 
R

Rick B

If all the linked databases are closed, then you can open the back-end and
change the table.

If you get an error, then someone is linked to the table. Tell them to
close whatever they are doing.
 
R

Robin Chapple

Right click on the table name will provide a drop down which includes
"Link Table Manager". This will tell you where the original table is
saved. Open the original,
 
B

Bill Kraut

It still gives me the error, my backoffice is access and the front end is
MySQL online, my website is linked to the database.
The database was design by the former web person, so im walking into this
blind
Bill
 
B

Bill Kraut

It tells me (DSN=members;Database=members;)

Robin Chapple said:
Right click on the table name will provide a drop down which includes
"Link Table Manager". This will tell you where the original table is
saved. Open the original,
Click to expand...
 
Top