Connecting Tech Pros Worldwide Help | Site Map

Max users?

magmike
Guest
 
Posts: n/a
#1: Aug 24 '07
Is there a way to set max users of a network shared database? We seem
to be having a problem getting a fourth user (yes, it's a small
office) onto the database. Or is there possibly something else going
on?

Thanks

mike
(the closest thing to an IT department our company has)

pemigh
Guest
 
Posts: n/a
#2: Aug 25 '07

re: Max users?


On Aug 24, 6:10 pm, magmike <magmi...@yahoo.comwrote:
Quote:
Is there a way to set max users of a network shared database? We seem
to be having a problem getting a fourth user (yes, it's a small
office) onto the database. Or is there possibly something else going
on?
If the other user's computer has Internet Explorer 7, I might have the
answer, and it has nothing to do with the number of other users.

Here's what I posted just a few minutes ago:

I've seen several problems cropping up on computers with Internet
Explorer 7. The oddest so far: Shortcuts to .mdb files fail silently
when another user on the network has the file open.

The more typical manifestation of the problem: You try to open a
Microsoft Access file that resides on a different computer, and are
told:

'Microsoft Access cannot open this file.

This file is located outside your intranet or on an untrusted
site.
Microsoft Access will not open the file due to potential
security
problems."


The fix in both instances:

In Internet Explorer, choose Tools Internet Options.
Then click the "Security" tab. Select the "Local intranet" zone.
Click the "Sites" button. Clear the checkbox for
"Automatically detect intranet network".

It was serendipity that helped me troubleshoot this problem, making me
a minor-league hero to two clients one morning. Hopefully this
posting will help bestow hero status on some of you other designers
out there!

Phyllis Emigh

Larry Linson
Guest
 
Posts: n/a
#3: Aug 25 '07

re: Max users?


Even if almost every factor for a multiuser database is less than optimal,
logging in four users should not be a problem. Thus I suspect "something
else is going on."

Larry Linson
Microsoft Access MVP

"magmike" <magmike7@yahoo.comwrote in message
news:1187993414.691043.37170@q3g2000prf.googlegrou ps.com...
Quote:
Is there a way to set max users of a network shared database? We seem
to be having a problem getting a fourth user (yes, it's a small
office) onto the database. Or is there possibly something else going
on?
>
Thanks
>
mike
(the closest thing to an IT department our company has)
>

magmike
Guest
 
Posts: n/a
#4: Aug 28 '07

re: Max users?


On Aug 24, 8:13 pm, "Larry Linson" <boun...@localhost.notwrote:
Quote:
Even if almost every factor for a multiuser database is less than optimal,
logging in four users should not be a problem. Thus I suspect "something
else is going on."
>
Larry Linson
Microsoft Access MVP
>
"magmike" <magmi...@yahoo.comwrote in message
>
news:1187993414.691043.37170@q3g2000prf.googlegrou ps.com...
>
>
>
Quote:
Is there a way to set max users of a network shared database? We seem
to be having a problem getting a fourth user (yes, it's a small
office) onto the database. Or is there possibly something else going
on?
>
Quote:
Thanks
>
Quote:
mike
(the closest thing to an IT department our company has)- Hide quoted text -
>
- Show quoted text -
I haven't had any problems since I implemented Phyllis' suggestion, so
it must have worked.

Closed Thread