Add table to split database

  • Thread starter Thread starter sweeneysmsm
  • Start date Start date
S

sweeneysmsm

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
 
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.
 
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
Click to expand...

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.
 
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
 
Get external database,
specify source (local or network)
Link to the data source by creating a linked table
and made sign on your table
Suad
 
Back
Top