By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

FE database not showing new table added to BE database

P: n/a
Hello All,

I've checked around a little on Google (and this group) and have found
info similar to what I'm trying to do (i.e., changes that were made in
the BE's tables are not reflected in the FE database) and have heard
suggestions using code, etcetera. But I need a bit more clarification
please.

What I'm doing/have done is this (MS Access 2007, FE stored on WXP
clients, BE stored on a W2K3 server):

My database has been split. A copy of the FE is on each user PC, the
BE is stored in shared folder on the server.

I've had to (don't ask why please, its one of those things where
people don't spend enough time on their biz requirements up front and
instead rush to start using a database) add a new table to the
system.

I added it in the BE file, but when I run the FE, it's not showing up
(the other tables from the BE are showing as linked tables with the
arrows).

I've used the Linked Table Manager in the FE (which isn't available in
the BE), but only see the original set of tables from my BE, no
mention of the new table that I had to add to the BE.

Which brings me to my question, the new table is there in the BE, but
its now showing up in the FE's, how can this be accomplished? Is the
only way to do this via coding?

Rgds,
Amit
Sep 11 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Open the FE. Click on Get External Data. Navigate to your BE and select the
missing table. Click Link. You should now see the missing table in your FE.

Steve
<re******@gmail.comwrote in message
news:97**********************************@79g2000h sk.googlegroups.com...
Hello All,

I've checked around a little on Google (and this group) and have found
info similar to what I'm trying to do (i.e., changes that were made in
the BE's tables are not reflected in the FE database) and have heard
suggestions using code, etcetera. But I need a bit more clarification
please.

What I'm doing/have done is this (MS Access 2007, FE stored on WXP
clients, BE stored on a W2K3 server):

My database has been split. A copy of the FE is on each user PC, the
BE is stored in shared folder on the server.

I've had to (don't ask why please, its one of those things where
people don't spend enough time on their biz requirements up front and
instead rush to start using a database) add a new table to the
system.

I added it in the BE file, but when I run the FE, it's not showing up
(the other tables from the BE are showing as linked tables with the
arrows).

I've used the Linked Table Manager in the FE (which isn't available in
the BE), but only see the original set of tables from my BE, no
mention of the new table that I had to add to the BE.

Which brings me to my question, the new table is there in the BE, but
its now showing up in the FE's, how can this be accomplished? Is the
only way to do this via coding?

Rgds,
Amit

Sep 11 '08 #2

P: n/a
re******@gmail.com wrote:
Hello All,

I've checked around a little on Google (and this group) and have found
info similar to what I'm trying to do (i.e., changes that were made in
the BE's tables are not reflected in the FE database) and have heard
suggestions using code, etcetera. But I need a bit more clarification
please.

What I'm doing/have done is this (MS Access 2007, FE stored on WXP
clients, BE stored on a W2K3 server):

My database has been split. A copy of the FE is on each user PC, the
BE is stored in shared folder on the server.

I've had to (don't ask why please, its one of those things where
people don't spend enough time on their biz requirements up front and
instead rush to start using a database) add a new table to the
system.

I added it in the BE file, but when I run the FE, it's not showing up
(the other tables from the BE are showing as linked tables with the
arrows).

I've used the Linked Table Manager in the FE (which isn't available in
the BE), but only see the original set of tables from my BE, no
mention of the new table that I had to add to the BE.

Which brings me to my question, the new table is there in the BE, but
its now showing up in the FE's, how can this be accomplished? Is the
only way to do this via coding?

Rgds,
Amit
In the past I'd select File/GetExternalData/Line (or Import) from the
menubar. The linked table manager is useful to change the connection
string on files that have already been linked...say you have a test
backend and a production back end...you could change the tables you are
using in your application with the LinkedTableManager.
Sep 11 '08 #3

P: n/a
Hi,

Thanks for your help. What Steve suggested worked perfectly.

Cheers,
A.

On Sep 11, 4:40*pm, Salad <o...@vinegar.comwrote:
reelr...@gmail.com wrote:
Hello All,
I've checked around a little on Google (and this group) and have found
info similar to what I'm trying to do (i.e., changes that were made in
the BE's tables arenotreflected in theFEdatabase) and have heard
suggestions using code, etcetera. But I need a bit more clarification
please.
What I'm doing/have done is this (MS Access 2007,FEstored on WXP
clients, BE stored on a W2K3 server):
My database has been split. A copy of theFEis on each user PC, the
BE is stored in shared folder on the server.
I've had to (don't ask why please, its one of those things where
people don't spend enough time on their biz requirements up front and
instead rush to start using a database) add a newtableto the
system.
I added it in the BE file, but when I run theFE, it'snotshowing up
(the other tables from the BE are showing aslinkedtables with the
arrows).
I've used theLinkedTableManager in theFE(which isn't available in
the BE), but only see the original set of tables from my BE, no
mention of the newtablethat I had to add to the BE.
Which brings me to my question, the newtableis there in the BE, but
its now showing up in theFE's, how can this be accomplished? Is the
only way to do this via coding?
Rgds,
Amit

In the past I'd select File/GetExternalData/Line (or Import) from the
menubar. *Thelinkedtablemanager is useful to change the connection
string on files that have already beenlinked...say you have a test
backend and a production back end...you could change the tables you are
using in your application with the LinkedTableManager.- Hide quoted text -

- Show quoted text -
Sep 20 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.