Add Fields to a Split Database Table

We split our Access database as suggested with a front end application
on local machines and back end tables on a data server. We need to
add a field to one of the tables but it looks as if splitting the
database prevents us from making changes to the structure of the
tables. Is there any way around this problem?

Many thanks

re: Add Fields to a Split Database Table

QBCM wrote:[color=blue]
> We split our Access database as suggested with a front end application
> on local machines and back end tables on a data server. We need to
> add a field to one of the tables but it looks as if splitting the
> database prevents us from making changes to the structure of the
> tables. Is there any way around this problem?
>
> Many thanks[/color]

You can make the changes in the same manner as you would with a non-split
applicatuon. You get all users out, open the back end file and then make the
changes. A revised front end that has had the links refreshed (to see the
changes) then needs to be distributed to all users.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com