Prev: Linked servers
Next: Compile: File Not Found
From: John W. Vinson on 10 Apr 2010 16:16
On Sat, 10 Apr 2010 10:33:01 -0700, sweeneysmsm
<sweeneysmsm(a)discussions.microsoft.com> 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]
From: sweeneysmsm on 10 Apr 2010 18:10
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
> <sweeneysmsm(a)discussions.microsoft.com> 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]
> .
>
From: sweeneysmsm on 10 Apr 2010 18:12
Thank you to all who helped me to clarify my task. I really appreciate it.

Mary
First  |  Prev  | 
Pages: 1 2
Prev: Linked servers
Next: Compile: File Not Found