Prev: Limiting Dat base usage
Next: does ms access use semicolon to terminate a statement
From: Sabineke on 24 Jun 2008 03:58
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
From: Rick Brandt on 24 Jun 2008 07:40
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


From: Sabineke on 25 Jun 2008 02:27
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
>
>
>
From: Rick Brandt on 25 Jun 2008 07:33
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


From: Sabineke on 26 Jun 2008 08:53
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
>
>
>
 | 
Pages: 1
Prev: Limiting Dat base usage
Next: does ms access use semicolon to terminate a statement