Need the assistance of an Access 2000 Guru........ Help

M

MikeBayneOBA

I am new to a company and the Access developer was let go, now I am in charge
of the database. I have a question regarding how to make changes to table
structures.

When I make a copy of the Networked MDB that is being accessed by several
users, I go into the "copy" on my hard drive to try and make changes to the
DB, but for some reason, when I attempt to make changes to the tables I get
the following message upon opening the tables.

Table 'OBA.Contact' is a linked table with some properties that can't be
modified.
Do you want to open it anyway.

I open anyway, make changes, and try to save and get sort of the same error
message. How can I go about making a copy of the MDB with the ability to
make changes within the copy. I know how to migrate the changes when
everyone is out of the production application, but for the life of me do not
know how to make it so I can access/Edit/Modify existing table information.

Any help is greatly appreciated
Thank You
 
L

Lynn Trapp

You can't make design changes to a linked table. You have to make the
changes in the database the table is actually located in.
 
M

MikeBayneOBA

OK, I found the Linked tables in another DB with DATA included in the title
of teh MDB. This is where my tables are linked. Now here is the question
that can help me start modifying the database. If I make copies of Both
the App MDB and the DATA MDB and copy them to my harddrive to begin
modification, I make changes to the Table structure in the DATA MDB, how do I
get the other MDB to recognize that I am now using a copy of the original as
opposed to the original. I made one change and went into the copy that
should have been affected and the change wasn't made.
 
Top