Access 2007 linked table acting weird

[Beginner]

Hi!

I have been coding Access 2003 and now I decided to start using Access 2007.
I have a split database and the conversion to 2007 format went fine.

In my database I have only one table which is in the back-end of the
database. In the front-end I can see, that the linking works. In my code I
have to modify some of the data in the back-end table because the data I get
isn't valid the way I vant it to be. This works also fine. My code basically
adds a field to the linked table and, depending on the information in a
single row, puts something to the field on that row. As I said, this works
and the query results I get (sum queries etc) are fine. But. Here is the
problem. If I open the table to view it in the front-end I see the new field
and the information in every row in it, as I should. When I open the table in
the back-end I see only the column but not the new data.

I don't know if this is a problem, since the queries work and everything
works, but this bothers me a lot. Why do I see the data in the front-end but
not in the back-end, where it should be?

Thanks for any advice!

Beginner

 

[Beginner]

I actually repaired this one myself. I removed the links from the front end
(by deleting the linked table from the front end) and relinked the table
using Import. I think that the conversion from 2003 to 2007 somehow messed my
links up.


"Beginner" kirjoitti:

 

[david]

works, but this bothers me a lot. Why do I see the data in the front-end

but not in the back-end, where it should be?

It might be in the Jet cache, or in the Network cache, or in link data
area. Did you wait a few seconds?

After you add a new field, it is not really settled in until you compact
the database and relink. It's usable, but it's not normal: the way
Jet pages data, there is not always a place to put the new field
in the right place in the file.

(david)