I set up a database and am using a view produced by a query for filtering
the email domains. I don't think that access supports views that way. I am
using IBM DB2 for the database, (the stock odbc drivers seem to work).
Field length isn't much of an issue, but field types are.
userid varchar
password varchar
fullname varchar
useraddr varchar
userdir varchar
maxmsgs int
maxsize int
flags int
type int
You will need to have other fields in your data table, but they should come
after TYPE. You will also have to have an ODBC connection for each domain.
That is one way to do it, if you want to discuss it, call me.
Robert E Shoemaker
Senior Consultant MCSE
Remote Connections Inc
914.383.3820 x107
800.283.2255 x11597 pager
http://www.remoteconnections.com
-----Original Message-----
From: Carolyn Hoagland [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 06, 2000 2:00 PM
To: [EMAIL PROTECTED]
Subject: Re: [IMail Forum] Sample ODBC Database
I would like to use an Access database for Imail. Is this acceptable? We
currently
have about 60 domains and 2000 total mailboxes. Does anyone know where I
could
locate a sample database? The knowledge base shows suggested field names,
but not
field types and lengths. - And the manual is not clear about whether I
need to
create this db first, or if IMail creates it for me...., Also each domain
seems to
require its own separate database. Arrgh - I was hoping that I would end up
with one
database that all my users names, passwords, userid's etc....
Carolyn
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.
