Weird problem after going to XP

  • Thread starter Thread starter Suzette
  • Start date Start date
S

Suzette

Hello All,

I have a customer who has been using an Access Database for a few years.
They just went to both Windows XP and Office XP. When doing so, the
strangest thing started happening.

Background:
Database data is on a server (backoffice)
Screens and all is on local machine with tables linked.

Problem:

When the user creates a new record in one of the tables (for invoicing).
The new autonumber shows on the form BUT the record is not in the linked
table nor is it available to any queries or other fields. The form has a
subform which links through the autonumber field but when you put that field
on the form, it doesn't update. I went to the linked table. New record
doesn't show. If you try to use a field in the subform or try to close the
form, program crashes. When reopened, the record shows.

Any suggestions?

Thanks

Suzette
 
(Guessing only): The first thing I would check is to make sure that your
client uses to correct Back-End database. They may have a few copies of the
Back-End and somehow linking Tables from a copy of the Back-End different
from the one you expect.

Use the Link Table Manger ... or the Connection String of all linked Tables
to check.
 
Good idea but I checked that. Only one database and that's it.
I also tried the Link Table Manager. Even tried refreshing the linked
tables through it but the record never showed until I closed and reopened
the local database.

Suzette
 
Going back to your original post, I am not sure what you meant by:
"... but when you put that field on the form, it doesn't update."

The rest of what you described seems to indicate that the Record has not
been updated into the Table.

As a test, create a CommandButton on the main form with the statement

DBEngine.Idle dbRefreshCache

in the Click Event.

In the FormView, go to New Record, enter some required data then click
somewhere in the Subform to save the Record on the main Form (using the
AutoSave feature). Go back to the main Form and click the CommandButton.
Open the Table in DatasheetView and see if the new Record is there.
 
Back
Top