Make sure that IUSR_MachineName and/or IWAM_MachineName (depends on if you
are in or out of process) have appropriate permissions to write to the
database table.
You didn't mention if you were on NT 4 or Win 2K or if FP 2K was involved.
There are other headaches with FP 2K and Win 2K with the accounts FP sets
up.
Roger
----- Original Message -----
From: Marcin Zastawny <[EMAIL PROTECTED]>
To: IMail_Forum <[EMAIL PROTECTED]>
Cc: Administrator <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 1999 8:39 AM
Subject: [IMail Forum] Access Database locked by IMAIL?
> No I dont think so.
> I had seen that problem before - lets ask the list with this:
>
> Hello everyone,
> Carlos is trying to set up the ASP script which I sent him, and for some
> reason IIS is saying:
> [Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database
> engine cannot open the file '(unknown)'. It is already opened exclusively
by
> another user, or you need permission to view its data.
>
> I had seen that problem before, but I dont remember the solution.
> Imail operates fine with the Access database already, its just that the
APS
> script does not really want to work for him.
> Does anybody know?
>
> thanks,
> Marcin
>
> -----Original Message-----
> From: Administrator [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 28, 1999 5:22 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Adding users via web.
>
>
> Marcin,
>
> I mapped the drive as you told me, but this is the message I got when I
ran
> the ASP:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database
> engine cannot open the file '(unknown)'. It is already opened exclusively
by
> another user, or you need permission to view its data.
>
> /exchange/USA/newaccts.asp, line 240
>
> My IIS server is on another machine, I have my IMail alone (NT 4 SP5). My
> ODBC driver is the default from NT.
> Do you thing the IMail is locking my Access database?
>
> Thanks,
>
> Carlos Llanos
> -----Original Message-----
> From: Marcin Zastawny [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 27, 1999 12:34 PM
> To: Llanos Carlos
> Subject: RE: Adding users via web.
>
>
> First of all, make sure that You have an external database as your source
of
> user info.
> Place this somewhere on your disk and set up an ODBC source (system) to
it.
> Lets say that you called the system dsn source IMAIL.
> Lets say that You called this IMAIL.MDB, and you placed in in d:\database\
> Lets also say that IMAIL is installed in d:\imail\ and that the user
> directory is in d:\imail\users.
>
> Lets say that your domain is called @mail.mydomain.com (with an alias to
> @mydomain.com).
>
> Make sure that the table that is in the Access database is called
> MAIL_MYDOMAIN_COM
>
> This is the first step.
> Basically, you have to ensure that your imail is working with your
database.
> Add a few users, delete a few, and see them get added to the access table.
> Likewise, add a user into the access table, and see him appear in the
IMAIL
> Administrator.
> This must first work before you go ahead to automate this process.
> Once this works, you would alter the beginning of that ASP script to
> something like this:
>
> Domain = "mail.mydomain.pl"
> Alias = "mydomain.pl"
> UserDir = "d:\imail\users"
> IMailServerURL = "http://www.mydomain.com"
> AccessMDB = "d:\database\imail.mdb"
> SQLConnect="DSN=IMAIL"
> Maxsize = 5242880
> MaxMsgs = 1000
> Flags = 128
> AcctType = 0
>
> Try this, if it does not work tell me and I will try to help you.
> I must soon go home however (it is 21:30 in Poland ;-).
>
> cheers,
> Marcin
>
> PS - I will be around for abother 30-60 minutes.
> -----Original Message-----
> From: Administrator [mailto:[EMAIL PROTECTED]]On Behalf Of
> Llanos Carlos
> Sent: Wednesday, October 27, 1999 9:19 PM
> To: '[EMAIL PROTECTED]'
> Subject: Adding users via web.
>
>
> I tried your asp, it did not work. I am using a MS access database. Are
> there any particular changes I have to do to make it work for my case?
>
> Thank you very much for all your help.
>
> Carlos Llanos
> Systems Manager
> Whittier College
> 562-907-4287
>
>
> Please visit http://www.ipswitch.com/support/mailing-lists.html
> to be removed from this list.
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
