Thank you for this good advice. I am actually not making a change to an
existing table, but rather adding an additional table. I will keep what you
said in mind for the future.

Mary

"John W. Vinson" wrote:

On Sat, 10 Apr 2010 10:33:01 -0700, sweeneysmsm
wrote:

I have a split Access Database on a network. I need to add a new table to the
database. Do I export it to both the front end and the back-end or do I run a
relinking module or do they just find each other "across a crowded room" when
the stars align?

Thank you for any insight.

Mary

One note: I've found problems when you make design changes to tables in the
backend. It may be a bit paranoid but now if I make ANY structural change to a
backend table, I'll be sure to open the backend exclusively; make the change
(or add the table or whatever); open the frontend and DELETE the link and
compact and repair the frontend. Then I'll use File... Get External Data...
Link to (re)link to the table.

--

John W. Vinson [MVP]
.