Add table to split database


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
 
Ad

Advertisements

S

sweeneysmsm

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
 
D

Daniel Pineault

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.
 
J

John W. Vinson

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.
 
S

sweeneysmsm

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
 
Ad

Advertisements

S

sweeneysmsm

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

Mary
 
Ad

Advertisements

Joined
Mar 11, 2016
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top