Check this article out...
http://support.microsoft.com/support/kb/articles/Q166/0/29.ASP
-----Original Message-----
From: Llanos Carlos <[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Date: Thursday, October 28, 1999 2:53 PM
Subject: RE: [IMail Forum] Access Database locked by IMAIL?
>Those are all taking care of, but still does not work.
>
>-----Original Message-----
>From: Scott Pouliot [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, October 28, 1999 8:43 AM
>To: [EMAIL PROTECTED]
>Subject: RE: [IMail Forum] Access Database locked by IMAIL?
>
>
>Check to make sure the DSN is not set to read-only or to Exclusive use.
>Also make sure that MS Access doesn't have the DB open as this sometimes
>causes problems
>
>**********************************************
>Scott Pouliot
>Webmaster - Motocross.com
>[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>**********************************************
>Visit us for all your Motocross needs!
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Marcin Zastawny
>Sent: Thursday, October 28, 1999 11:40 AM
>To: IMail_Forum
>Cc: Administrator
>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.
>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.
