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

Hi, Daniel,

Thank you for your so-speedy reply.

One question: When you say "Open your front-end and Import -> Link the new
table", are you saying that I first Import the table, and then link it, or
do you mean to go to Get External Data but choose link instead of import. Or
do you mean import the structure of the table and then Link it? Just want to
be sure that I understand exactly what you are saying.

Mary
"Daniel Pineault" wrote:

> Ensure no one is working in the db (no ldb back-end file) and then you take
> if offline. Do not keep a copy on your server or else people may do work
> which they will loose!
>
> Then make the modifications you require (add the new table).
>
> Then place the back-end file back in place
>
> Open your front-end and Import -> Link the new table
>
> Finally, once you have made the form, queries, reports,... for this new
> table, distribute a new version of your front-end to all your users.
> --
> Hope this helps,
>
> Daniel Pineault
> http://www.cardaconsultants.com/
> For Access Tips and Examples: http://www.devhut.net
> Please rate this post using the vote buttons if it was helpful.
>
>
>
> "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

On Sat, 10 Apr 2010 10:55:01 -0700, sweeneysmsm
<(E-Mail Removed)> wrote:

>go to Get External Data but choose link instead of import

That's what you want to do.
--

John W. Vinson [MVP]

Since we are talking about a split database, then all you want to do is
create a link in your front-end to your newly created back-end table.

"Get External Data but choose link"

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"sweeneysmsm" wrote:

> Hi, Daniel,
>
> Thank you for your so-speedy reply.
>
> One question: When you say "Open your front-end and Import -> Link the new
> table", are you saying that I first Import the table, and then link it, or
> do you mean to go to Get External Data but choose link instead of import. Or
> do you mean import the structure of the table and then Link it? Just want to
> be sure that I understand exactly what you are saying.
>
> Mary
> "Daniel Pineault" wrote:
>
> > Ensure no one is working in the db (no ldb back-end file) and then you take
> > if offline. Do not keep a copy on your server or else people may do work
> > which they will loose!
> >
> > Then make the modifications you require (add the new table).
> >
> > Then place the back-end file back in place
> >
> > Open your front-end and Import -> Link the new table
> >
> > Finally, once you have made the form, queries, reports,... for this new
> > table, distribute a new version of your front-end to all your users.
> > --
> > Hope this helps,
> >
> > Daniel Pineault
> > http://www.cardaconsultants.com/
> > For Access Tips and Examples: http://www.devhut.net
> > Please rate this post using the vote buttons if it was helpful.
> >
> >
> >
> > "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

On Sat, 10 Apr 2010 10:33:01 -0700, sweeneysmsm
<(E-Mail Removed)> 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]

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
> <(E-Mail Removed)> 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]
> .
>

Thank you to all who helped me to clarify my task. I really appreciate it.

Mary