Can only see partial tables without old link

[Steeler]

This is the weirdest thing I've ever come across but I assume I'm
missing something simple.
I have an Access application. I update the front end (FE) occasionally
and then have an automatic re-link routine. When I look at the tables
on the server directly, I don't see all the records. Table "tblTest"
shows me only 2394 records. If I view it through the front end, via an
old link, I see 2700 records. No matter what machine I use (we have
hundreds of them here) I see the reduced set of records. If I update
the link in the FE I'll see the fewer records view also. The kicker is,
I believe the old link is seeing the correct number of records (2700)
but any new link or looking at the database directly shows me the 2394.
Any ideas at all would be GREATLY appreciated it.

[Bob Quintal]

"Steeler" <al**********@pw.utc.com> wrote in
news:11**********************@x69g2000cwx.googlegr oups.com:

This is the weirdest thing I've ever come across but I assume
I'm missing something simple.
I have an Access application. I update the front end (FE)
occasionally and then have an automatic re-link routine. When
I look at the tables on the server directly, I don't see all
the records. Table "tblTest" shows me only 2394 records. If I
view it through the front end, via an old link, I see 2700
records. No matter what machine I use (we have hundreds of
them here) I see the reduced set of records. If I update the
link in the FE I'll see the fewer records view also. The
kicker is, I believe the old link is seeing the correct number
of records (2700) but any new link or looking at the database
directly shows me the 2394.
Any ideas at all would be GREATLY appreciated it.

Look for a backup of your table that contains the 2700 records.
For some reason, Access/SQL Server automatically repoints the
link to a renamed table to the old version when you rename it.
Deleting the link and re-establishing it puts the link to the
current version.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Steeler]

Look for a backup of your table that contains the 2700 records.
For some reason, Access/SQL Server automatically repoints the
link to a renamed table to the old version when you rename it.
Deleting the link and re-establishing it puts the link to the
current version.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Excellent idea! Thanks. I'll try it first thing in the morning when I'm
back at work.