Linked Table on server not updating

[Guest]

We've just updated from Access 2000 to 2007. We've recomplied the code and
all is working normally.

Our problem is our back-end database on the server is not updating from the
front end users at their workstations. I've follow MS instructions on how to
split a database (304932), which pretty much was the way we used to do it.

Out tables are located on the server and our work stations are linked to the
tables there. Yet for some reason the server database is not updating. I
recently found four records in the workstation that were not on the server.
This makes no sense since they are linked?

Any help would be greatly appreciated,
Thanks, Al

 

[Guest]

Your links are wrong. You are linked to the wrong database.

(david)

 

[John W. Vinson]

Out tables are located on the server and our work stations are linked to the
tables there. Yet for some reason the server database is not updating. I
recently found four records in the workstation that were not on the server.
This makes no sense since they are linked?

Use File... Get External Data... Linked Table Manager and select "Always
prompt for new location". Relink your tables to the *correct* backend -
they're almost surely linked to some other (old? test? duplicate? redundant?)
backend data on the server.

John W. Vinson [MVP]

 

[paul wachsman]

going on to day and i will see you again some time if you what to