Editing Linked Table Properties

M

MikeBayneOBA

Hello to anyone and everyone that might point me to a solution.

I have a database on a server that I have copied locally, as well as the
data.mdb that is it associated with. I go into the main database on my C:
drive and do a Link table Manager to point to the data files (Also now on my
C: Drive), it all is successful, except I cannot change any information when
dealing with table properties. Basically all I want to do is remove a
primary key from one table and it gives me the error message: CANT SAVE
PROPERTY CHANGES FOR LINKED TABLES....... DO YOU WANT TO CONTINUE ? Yes/No
are the only choices at this point and it doesn't save my changes. I even
tried using the "Exclusive" access under OPTIONS/ADVANCED.

Any assistance is greatly appreciated
 
R

Rick Brandt

MikeBayneOBA said:
Hello to anyone and everyone that might point me to a solution.

I have a database on a server that I have copied locally, as well as
the data.mdb that is it associated with. I go into the main
database on my C: drive and do a Link table Manager to point to the
data files (Also now on my C: Drive), it all is successful, except I
cannot change any information when dealing with table properties.
Basically all I want to do is remove a primary key from one table and
it gives me the error message: CANT SAVE PROPERTY CHANGES FOR
LINKED TABLES....... DO YOU WANT TO CONTINUE ? Yes/No are the only
choices at this point and it doesn't save my changes. I even tried
using the "Exclusive" access under OPTIONS/ADVANCED.

Any assistance is greatly appreciated
Click to expand...

You have to open the data file and make the changes in there. You cannot
make changes to a linked table from the front end file.
 
Top