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 / Multiuser / Networking / November 2005

Tip: Looking for answers? Try searching our database.

Access Client/Server issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jeff - 31 Oct 2005 15:57 GMT
Hello,

I have designed many Access Client Server Applications before where I have
the 1 MDB file on the Hard Drive & the data MDB file on the server & have
the Tables Linked.

For this one client when I do the same when 1 user logs in they are fine.
But when anyone else does they freeze & they have to End Task out of
Access.  So basically it is only allowing 1 user to log in.  So that is my
problem
& that is what I am looking for a solution for.  Should be able to have more
than 1 user on at the same time.  The weird thing too is if 1 user is logged
in
& then when another tries & they freeze, if the original user logs out, then
they will unfreeze & can go in.

Thes are some of things I tried/looked into:
- They have a good server, 3ghz 1GB RAM
- IT person made sure users had full rights to folders
- I tried compacting & repairing
- I tried brand new Access files & copied over all objects.
- It is a small database, hardly any data in it.
- They have Access 2000, Service Pack 3
- Both  the Client & Data mdb file on the Server have Defualt Open Mode set
to Shared

I am stummped.  Does anyone have any advice ?

Any help would be greatly appreciated.

Thank you,
Jeff
Nikos Yannacopoulos - 01 Nov 2005 11:41 GMT
Replied in the formscoding NG.

Please avoid multi-posting (same post to several NG's individually); in
the rare occasion when posting to several groups is required, it is
preferable to cross-post instead (one post addressed to several groups),
so answers will appear in all groups as well; makes life easier for both
yourself and the respondents.

Nikos
 
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.