Form Data Missing

E

ebayauctions

After upgrading to Windows XP SP2, Office XP SP3, I cannot view records
using Forms. The database resides on a network share, with 5 other users
(Win XP SP2, Office XP SP3) who have not problems viewing the information.

I used Linked Table Manager and resolved the problem, only to find the other
5 could no longer to see the data. Any ideas? Thanks
 
T

Tom Wickerath

You've obviously got a split database, since you indicated that you used the
linked table manager. What you didn't indicate is whether each user has their
own copy of the front-end (good), or is everyone sharing a copy of the
front-end on a file server (very bad).

If everyone is sharing a copy, and you used the linked table manager to
re-link tables, did you use UNC naming conventions for the path to the
back-end database (ie. \\Server\Share\). If you simply accepted the default,
which is a mapped drive, then the other users would need to have the same
drive letter mapped the same.


Tom
_______________________________________

:

After upgrading to Windows XP SP2, Office XP SP3, I cannot view records
using Forms. The database resides on a network share, with 5 other users
(Win XP SP2, Office XP SP3) who have not problems viewing the information.

I used Linked Table Manager and resolved the problem, only to find the other
5 could no longer to see the data. Any ideas? Thanks
 
E

ebayauctions

Thanks Tom
On closer look, users had shortcuts back to the forms mdb (front-end) on the
server, and found by copying it to each desktop, then relinking, data was
restored. My colleague and I did this to each user for consistency.

Looks like everything will work out. Thanks for the help.
 
Top