How do i modify a property in a linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 (e-mail address removed)
Thanks
Bill Kraut
 
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
 
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
 
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.
 
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,
 
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
 
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...
 
Don't know anyhting about that front-end. Sounds like you would need to
unlink that item to make your changes. I would bet that it is accessing the
data at all times and is linked to the database, thus preventing you from
making design changes.

Maybe an MVP will have some more advise.

Rick B
 
Back
Top