We run our IMail Server on an external database as well and have encountered
this problem. First off....you have to start and stop the mail services to
get the database to kick in. If you added ANY fields to the IMail database
then those fields MUST not be the first fields in the table. We use the
IMail table as a backend for a free e-mail system. Users sign up right over
the web and it populates the IMail Access DB in one fell swoop. They have
immediate access and everyone is happy.
I hope this helps....
-----Original Message-----
From: Ken Bakunas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 02, 1999 1:43 PM
To: [EMAIL PROTECTED]
Subject: RE: [IMail Forum] Dadabase Access problems, can ay vbody help
I too have the same problem - IMail creates the Access table, enters
the root user, but won't let me change anything for the root user
or add new users with the IMail Admin????
Thanks,
Ken
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Stull
> Sent: Wednesday, June 02, 1999 9:07 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [IMail Forum] Dadabase Access problems, can ay vbody help
>
>
> IMail Control Panel and/or IAdmin open on the console? Both
> will open a connection to the database.
>
> Bob
>
> ---------- Original Message ----------------------------------
> From: "Marcin Zastawny" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Wed, 2 Jun 1999 11:03:27 +0200
>
> >Hi,
>
> as far as I know, Access has a built in user called Admin.
> The password is null (ie. empty).
>
> As for Access being locked, what file system is this on?
> I wrote an activity tracking application which was based on an NT server,
> and several people were entering data into it at once.
>
> I believe that Your problem is in the ODBC setup.
> When You create an Access Data source in ODBC, if You click on the
> "OPTIONS>>" button, You have two check boxes that You can click.
> One is "Read Only", and the other is "Exclusive".
> Check to make sure that Exclusive is not turned on.
>
> regards,
> Marcin Zastawny
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Lajoie
> Sent: Wednesday, June 02, 1999 10:50 AM
> To: [EMAIL PROTECTED]
> Subject: [IMail Forum] Dadabase Access problems, can ay vbody help
>
>
> Hi All,
>
> Product: IMail Server 5.00
> OS: Windows NT Server 4.0
>
> I have set up a virtual server to use an ODBC Database
> (Access .mdb file) and all seems to function except that
> Access will not allow me to open the database as it
> is locked for exclusive use buy user 'Admin'
>
> Firstly I do not have a user 'Admin' on my system.
>
> Secondly I wish to be able to access and modify the
> contents of the database using Cold Fusion. Being locked
> exclusively I cannot modify it at all. I have tried
> removing the ODBC link in ODBC Manager and switching off
> all the IMail services and the database is still locked
>
> Can you suggest a way of IMail not using the database
> exclusively so I can modify and add to it. What I want
> to do is build further fields into the database for client
> billing using the Cold Fusion interface, or have I missed
> the point of DB access?
>
> Thank you in advance
>
> Steve Lajoie
>
>
>
>
> --
> R. Stull
> Programmer
> Ipswitch, Inc.
> http://www.ipswitch.com/
> --
>
---------------------------------------------------------------------
Get your lifetime e-mail at Motocross.com (http://www.motocross.com)
