Split database - Update table in BE

Hi,

Have split up my database in a BE and FE database. Users now want an extra
field in one of the tables. Put in this field in the table in the BE
database. Went to the FE database and relinked the table, but the field
isn't visible.

What did I miss?

Sabineke

Sabineke wrote:
Hi,

Have split up my database in a BE and FE database. Users now want an
extra field in one of the tables. Put in this field in the table in
the BE database. Went to the FE database and relinked the table, but
the field isn't visible.

What did I miss?

Sounds like your front end is not pointing to the back end you think it is.
For a Jet back end (mdb) you usually don't even need to relink. Changes
just show up.

Are you looking at the table link in the front end or at a form? The latter
might require additional changes before it will see the new field.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Hi,

I'm looking at the table link in the front end. (Linked table manager) I've
already deleted them and remade them, but still got the same problem. When I
open the BE, I linke to, I see the modifications I made to the table.

Is it possible it has something to do with security issues? I'm working in
access2007 with file format access 2002-2003 and secured the BE and FE.

Sabineke

"Rick Brandt" wrote:

Sabineke wrote:
Hi,

Have split up my database in a BE and FE database. Users now want an
extra field in one of the tables. Put in this field in the table in
the BE database. Went to the FE database and relinked the table, but
the field isn't visible.

What did I miss?

Sounds like your front end is not pointing to the back end you think it is.
For a Jet back end (mdb) you usually don't even need to relink. Changes
just show up.

Are you looking at the table link in the front end or at a form? The latter
might require additional changes before it will see the new field.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Sabineke wrote:
Hi,

I'm looking at the table link in the front end. (Linked table
manager) I've already deleted them and remade them, but still got the
same problem. When I open the BE, I linke to, I see the
modifications I made to the table.

Is it possible it has something to do with security issues? I'm
working in access2007 with file format access 2002-2003 and secured
the BE and FE.

Open the link in design view and look at the property sheet. This will show
the path to the file where the link is pointing. Are you absolutely sure
that it is pointing to the same file you modified? Because all of what you
are saying suggests otherwise.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Hi,
You were right. I open the database BE through a shortcut on my desktop and
it seems that this pointed to the wrong BE database. Now it works. Thanks
for your help and sorry. Going to double check next time.



"Rick Brandt" wrote:

Sabineke wrote:
Hi,

I'm looking at the table link in the front end. (Linked table
manager) I've already deleted them and remade them, but still got the
same problem. When I open the BE, I linke to, I see the
modifications I made to the table.

Is it possible it has something to do with security issues? I'm
working in access2007 with file format access 2002-2003 and secured
the BE and FE.

Open the link in design view and look at the property sheet. This will show
the path to the file where the link is pointing. Are you absolutely sure
that it is pointing to the same file you modified? Because all of what you
are saying suggests otherwise.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com