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