Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / August 2004

Tip: Looking for answers? Try searching our database.

Strange security Settings

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Klutzz - 17 Aug 2004 12:19 GMT
I have set up a small simple database using access 2003. Having worked thru
all the little bugs an feeling it was ready for "prime time" I compiled it
and put in a shared folder on our company Lan. The problem is that when one
of the users computer opens the database all is fine untill the program is
closed, once this occurs its takes a log-out/ log-in to re open the database
for subsequent entries or use. This seems especialy strange in that this is
the only pc of several exhibiting this condition. The pc's are an assortment
of various flavors of windows and versions of access, the specific pc is
running XP with A2003.
Is there a way to re-set the security of my database to zero and start over
and does anyone have any ideas what might be causing this behaviour //

Thanx in advance for any insights or advice.

Klutzz
Lynn Trapp - 17 Aug 2004 13:56 GMT
It may be that, when the user exits the database, the locking file (.ldb) is
not being deleted. Check the folder that the database is in and see if the
.ldb file is deleted when the user exits Access. Make sure no one else is in
the database when you do this. If the lock file is still there, then you may
need to check to see if the user in question has delete permissions on the
folder that the database is in.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> I have set up a small simple database using access 2003. Having worked thru
> all the little bugs an feeling it was ready for "prime time" I compiled it
[quoted text clipped - 11 lines]
>
> Klutzz
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.