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 / May 2008

Tip: Looking for answers? Try searching our database.

Access Multi-User Network issues

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DavidF - 13 May 2008 18:31 GMT
We have several Access (2003 SP3) applications running on a Windows 2003
network.  All users have Windows XP on their workstations.  The database's
are not currently split.  Each application is in its own folder with
appropriate (read, write, create, delete) rights to the folder.  The
database's are set to share with record locking.  Each user has a windows
icon and/or windows menu link to the appropriate application.  Here is the
problem:  The first user who clicks the icon opens the application.  Every
other user who tries to open the applcation via an icon or windows menu gets
an hourglass for 5-8 seconds, then nothing.  Same with a menu pick from
windows.  If the user opens Access and then picks the application from within
the access menu (right side), the same thing happens.  However if the
"File/Open" command is used, the application dutifully opens without further
problems.   At present, we have this as a work-a-round, but it is not very
elegant!  Anyone have a suggestion?
Keith Wilby - 14 May 2008 08:20 GMT
> The database's are not currently split.
<snip>
> Anyone have a suggestion?

Multi-users sharing a file is fraught with difficulties so I'd eliminate
that first by splitting.  If it's still a problem afterwards then at least
we know it's not a sharing issue.

http://www.granite.ab.ca/access/splitapp/index.htm

Keith.
www.keithwilby.com
 
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.