View Single Post
  #7  
Old March 23rd, 2010, 06:26 AM posted to microsoft.public.access.tablesdbdesign
Armen Stein[_2_]
external usenet poster
 
Posts: 157
Default Proper Indexing of Table Fields

On Mon, 22 Mar 2010 15:46:01 -0700, QB
wrote:

No server, simply shared off of a NAS Drive -- Each user has the FE


On a side note, I'm concerned about the BE on a NAS. Be aware that if
the back-end is on an OS without the right file locking mechanisms,
very bad corruption can result when multiple users make changes.

Look at the BE folder. If the LDB locking file disappears when
subsequent users start using the database, that's one sign that you're
headed for trouble. Move the BE to a Windows machine.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com