shared table doesn't show updates

  • Thread starter Thread starter Karen Skipper
  • Start date Start date
K

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
 
I forgot to say that I'm working over a Novell 3.12 (show embarassed look
here) network.
 
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
 
Back
Top