shared table doesn't show updates

[Karen Skipper]

I've written my reports, modules, macros etc and split the application. (I'm
using Win 2000pro, Access2002)

I used the package and deploy from the Office Developers Package to
distribute because I don't have Access on all of my workstations. I
installed my app on one computer for testing. Here's the problem...

When I append a new record (with a unique numeric key that is assigned in
the VB code) to the table at workstation1 the other workstation
(workstation2) doesn't see that new record and if I try to append a new
record I get messages about duplicate keys. If I use the Last Record button
(at workstation2), the newly appended record isn't shown. If I exit my app
at workstation2 and restart it the record appears.

Any help would be appreciated.

Karen

 

[Karen Skipper]

I forgot to say that I'm working over a Novell 3.12 (show embarassed look
here) network.

 

[Scott McDaniel]

After adding new records from WS1, you'll have to requery from WS2 before
the new records will show up in WS2 ... just issue a DoCmd.Requery