Koozali.org: home of the SME Server

MS access database unable to operate with more than 1 or 2 users

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: MS access database unable to operate with more than 1 or 2 users
« Reply #30 on: November 19, 2010, 02:47:26 AM »
JBrennan

Did you put the files in the Primary ibay ? If so there is no password protection function for the Primary ibay unless you have done some workarounds eg refer the htaccess howto.
If you have put them in another ibay, then it seems that you have a password set on that ibay for web access.
The username will be the ibay name, and the password will be whatever password you have set in the server manager ibays panel for that particular ibay.

Please read the manual as this is explained there.
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline JBrennan

  • *
  • 18
  • +0/-0
Re: MS access database unable to operate with more than 1 or 2 users
« Reply #31 on: November 19, 2010, 10:30:09 PM »
I checked things out this morning Mary, and can confirm the following:

Using  the Windows workgroup, I was able to confirm that the required files  are in this directory:
\\Elpserver\Primary\html

In the browser, anything that starts with
http://www.elpserver.com/
will result in a window that includes the following:
A username and password are being requested by http://www.elpserver.com. The site says: "Password Protected"

I looked through the Server manager pages for anything relevant. I could only find this :
Under manage domains, the
Brief description is Primary Domain
I-bay is primary site
DNS is Resolve locally

The only other thing that puzzled me is that another name appears under Domain information on the Review Configuration page:
Primary domain: elpwaikato
Virtual domains : elpwaikato
Primary web site : http://www.elpwaikato

However substituting this name for elpserver in the browser prompted a “Failed to load” page message.

I haven’t any ‘workarounds’  Other than the responding to the requests at installation and setting up the Users and Ibays, I have done no other changes to the configuration  outside of what is included in this forum discussion.

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: MS access database unable to operate with more than 1 or 2 users
« Reply #32 on: November 20, 2010, 12:28:57 AM »
JBrennan
 
Quote
Brief description is Primary Domain
I-bay is primary site
DNS is Resolve locally

That suggests the Primary page content is directed to an ibay, but you do not say what the ibay name is.
What other ibays are on the sytem, look in ibays panel in server manager.
Note that ibays can be password protected, so this may be the source of the web page user & password request.
Do you mean it is referring to the ibay name of elpwaikato  ?
 
Quote
Primary web site : http://www.elpwaikato

That appears to be an old domain that is maybe no longer in use for which external DNS records no longer exist, or are setup incorrectly ??? I did not check, just guessing.


Quote
I haven’t any ‘workarounds’  Other than the responding to the requests at installation and setting up the Users and Ibays, I have done no other changes to the configuration  outside of what is included in this forum discussion.

Well someone has done various configuration. Are you suggesting this is a clean install and you did not add that domain or password setups ? Who did ? Please provide the full history of this server.
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline JBrennan

  • *
  • 18
  • +0/-0
Re: MS access database unable to operate with more than 1 or 2 users
« Reply #33 on: November 20, 2010, 06:10:02 AM »
That suggests the Primary page content is directed to an ibay, but you do not say what the ibay name is.
What other ibays are on the sytem, look in ibays panel in server manager.
Note that ibays can be password protected, so this may be the source of the web page user & password request.
Do you mean it is referring to the ibay name of elpwaikato  ?

These are just the default settings, so I presume they are referring to the Primary I-bay

That appears to be an old domain that is maybe no longer in use for which external DNS records no longer exist, or are setup incorrectly ??? I did not check, just guessing.

This came from the setup at time of installation. For better or worse, I chose to give different names for the files server and the web server (at least that is what I thought I was doing).

Well someone has done various configuration. Are you suggesting this is a clean install and you did not add that domain or password setups ? Who did ? Please provide the full history of this server.

It was a clean install. I just set up the users, two I-bays and copied data over from the previous server.

Offline bas60

  • ***
  • 53
  • +0/-0
Re: MS access database unable to operate with more than 1 or 2 users
« Reply #34 on: January 30, 2011, 06:26:53 PM »
did you manage to sort out issues with    MS Access files???

Offline JBrennan

  • *
  • 18
  • +0/-0
Re: MS access database unable to operate with more than 1 or 2 users
« Reply #35 on: January 31, 2011, 07:41:16 AM »
No Bas60 - I concluded that I had come to the end of the line of the community support - and was considering other alternatives (not as good as SME server) - but have been too busy to do anything about it.

I'm still open to working on the problem again if someone is willing to walk alongside.
John