Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Loosing data from MS Access. If you enter data & 2 hours later it is gone

Data Loss

Loosing data from MS Access. If you enter data & 2 hours later it is gone

by  assets  Posted    (Edited  )
MS Access database and Novell Netware file sharing issues (Data Loss).
If you have been loosing data from MS Access. If you enter data and 2 hours later it has gone.
It may be Opportunistic Locking. This has been a problem with Netware for a long time.
These are the steps that fixed the problem.
Ensure you have Netware client 4.91SP2 or greater
Right mouse click Netware services icon on the system tray
Click Novell Client properties
On the advanced tab
Change Filing Cashing (change to OFF)
File cashing Exclusively Opened Files (change to OFF)
File commit (change to ON)
Also I have assumed you have check that all user have Read, Write, Modify, File Scan, Erase, and Create permissions to both the file and directory.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top