Linked Table - with some properties that can't be modified ??

[Will]

OK, I've just split my first data base...

Now I realize I want to add some fields to a table... change the names of
some existing fields... etc

The backend is on a peer to peer computer on our small network... Access
2003 on XP machines.

When I open the table in design view from my computer I get the warning

"Table tblCustomers is a linked table with some properties that can't be
modified. Open it anyway?"

How can I work on a table on the back end from my front end machine?

The backend machine does not have Access on it... so I can't work on the
tables there.

thanks for any help.

 

[tina]

you'll have to move (or copy) the be database onto your PC, make the
changes, and then move it back.

hth

 

[Douglas J. Steele]

You have to open the back-end database to make the changes. You don't have
to be physically at the machine to do that, just navigate to it through the
File Open dialog (or double-click on it through Windows Explorer)

Alternatively, you can create open the back-end database through the
OpenDatabase method and use DAO methods to manipulate the table, you can
create an ADO connection to the back-end and use ADOX methods to manipulate
the table or you can use DDL (Data Definition Language) such as Alter Table.