Excessive database errors - 3051

[Jebez]

This is a new installation...

We are running PageGate v4.0 Scheduler, GetMail, GetWeb, and dialers (1-16) on a Windows 2003 server via services using a Local user account that is in the administrators group and has the right to "run as a service".

The program files, database, and log files are all local. The database and log files [which are in a subfolder within database] folder are in a network share. The local users group has "access this computer from network", "bypass traverse checking", NTFS modify access and full control access to this share.

Sending pages works fine from the server.

I installed additional admin, monitor and client on a WindowsXP workstation. When attempting to run PG Admin accessing the database and log files via an UNC or mapped drive letter from this workstation with a user in the servers local user group, we get the following message:

PG Admin Fatal Error: Excessive database errors: 3051 The Microsoft Jet database engine cannot open the file '\\Server\PageGate\pagegate.mdb'. It is already opened exclusively by another user, or you need permission to view its data. in Procedure: main Program Halted.

From reading previous postings regarding this error, I see that this error indicates a permission issue. What have I over looked?

Please advise,

--Jeff

[OzCom]

Is the "local account" user name that you used to run PageGate Server the same one that you are using on the PageGate Admin pc?

_________________
Aaron D. Osgood
Streamline Communications, LLC
* Authorized Notepage, Inc. Development Partner and Re-seller
TEL: 207-518-8455
AOsgood@streamline-solutions.net
Creators of AutoPage Spillman CAD interface for PageGate

[Tech Support]

Since the error you're running into is from the workstation running the 'remote' version of the Admin, does the user currently logged onto that workstation have the appropriate network rights to the PageGate Database directory? Bera in mind, they must have full control (read, write, and modify) because the Admin (and client) modify the database.

[Jebez]

Thank you for your time.

OzCom,

Both the workstation and the server are members of the same domain. The PageGate Admin workstation is using a domain account that is in the server`s local user group.

Tech Support,

What are the exact appropriate rights that differ from what I`ve already stated?

On the server:
> local users group membership includes domain users
> local folder NTFS permissions permit "modify" access to the local users group; permissions are propagated
> local folder is shared and permits "change" access to the local users group
> local user rights assignment permits the local users group:
o ...Access this computer from the network
o ...Bypass traverse checking
> What else is there? What am I missing...?

[Jebez]

I`m not sure why, but NTFS "full control" permissions appeared to have resolved the issue. "Modify" should be sufficient.