Scott, thanks for the advice. Mine is now working, seems strange
but here is what I did.
After IMail was configured to use the database and created the
table I went back in and changed the name of the table in the
IMail admin screen. Imail then creates another table with
that name. I deleted the old table and everything works!
Ken
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Frank J Nastro
> Sent: Wednesday, June 02, 1999 3:51 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Re[2]: [IMail Forum] Dadabase Access problems, can ay vbody
> help
>
>
> This is precisely what I did and all works great!!!
>
> Frank J Nastro
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Scott Pouliot
> Sent: Wednesday, June 02, 1999 3:30 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Re[2]: [IMail Forum] Dadabase Access problems, can ay vbody
> help
>
>
> I spent a number of hours on this trying to figure it out until I finally
> called Ipswitch support. Igor(the tech we spoke with) was VERY
> knowledgeable in this area. He walked us through every step on the phone
> and then BAM! it worked like a charm. What I did originally was
> create the
> table myself(per the specs) and then have IMail use it. IMail didn't seem
> to like this so I dumped that table and had IMail create the table for me
> since it seemed to know what it liked. It of course created a
> table called
> abc_def_com(based on hostname of the IMail machine) so I didn;t
> want to use
> that in my ASP code. I renamed the table to 'Users' and then had to setup
> IMail again to point to this new table. It worked like a charm.
>
> I got numerous Dr. Watson errors on iadmin.exe when IMail didn;t like my
> data table. Since I did the steps listed above....no problems. I wasn;t
> sure exactly which services to stop during the table rename....so
> I stopped
> them all, made my changes, and then restarted them. I've had no trouble
> since....
>
> Good Luck!
>
> -----Original Message-----
> From: Steve Lajoie [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 02, 1999 3:13 PM
> To: Scott Pouliot
> Subject: Re[2]: [IMail Forum] Dadabase Access problems, can ay vbody
> help
>
>
> Hi Scott, Thanks
>
> Wednesday, June 02, 1999, 7:52:08 PM, you wrote:
> > 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....
>
> OK, just to ensure I have this right, jump through all the
> hoops again setting up a DB, ODBC and IMail, using the
> required field first (I had that, in fact had not yet added
> any of my own fields is there any particular order, I did it
> as per the dialogue when configuring the database.
>
> Then start and stop All the mail services? to get the DB to
> kick in, then I should be able to re-access the database to
> add my fields and add cold Fusion queries I need to add
> modify delete data records.
>
> Ironically that is the very purpose I am evaluating the
> product for a Free Email system for the Guernsey Community,
> our State owned Teleco (I am their consultant) are
> introducing a free Islandwide service, and we need the DB as
> with Cold fusion we will be controlling all manner of
> peripherals such as business pages, phone directories and all
> sorts of good stuff, but if I cannot get the thing to work
> we are snookered, certainly with IMail and that would be a
> shame it is a great product.
>
> Thanks agian, Steve
>
> > 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)
>
>
>
> ---------------------------------------------------------------------
> Get your lifetime e-mail at Motocross.com (http://www.motocross.com)
>
>
