converting form access to sql is VERY easy....just use the upsizing tool
avaliable with access in office 2000, or download the office 97 upgrade
wizard from the Microsoft site.......
No problems with that! We develop in access and upsize quite often and found
it the easisest thing to do....
Kind Regards
Neil Solomon
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Omar Koudsi
Sent: Tuesday, August 22, 2000 4:02 PM
To: [EMAIL PROTECTED]
Subject: Re: [imail] External DB design approach
I recommend using MS SQL 7, or any other high-end database. I started with
MS Access and wanted to upgrade later. But I wished that I had start with
MSSQL from start. Because its not so hard to install/configure and I had
problems converting from MS access to MSSQL.
I also use a customized table for user authenication that contains other
fields than the imail ones. It works fine, I dont think you can seperate the
imail table into two tables without modifying the imail DLL that talks to
the SQL server.
---------- Original Message ----------------------------------
From: "Nopchai Tangtritham" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 22 Aug 2000 09:56:46 +0700
>So, This mean that number of fields in DB table shouldn't reflect much on
performance? ..
>
>Regards,
>Nopchai
>
>--------- Original Message ----------------------------------
>From: Joker <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>Date: Mon, 21 Aug 2000 22:49:09 -0400
>
>>I have seen MS-Acces with close to a million entries and work fine.
>>At 09:41 AM 8/22/2000 +0700, you wrote:
>>
>>>Hi all,
>>>
>>> Anyone can give me an idea.. will there be any benefit if I
>>> split External DB for IMAIL usage & another DB to keep detail
information
>>> of users. The idea is to keep minimum fields that IMAIL use for
external
>>> DB authentication(this DB will be also used for our own developed web
>>> application for authentication)
>>> Will that be any useful to do this approach? .. since we
will
>>> have to modify some code in EZsignup. Also One drawback I see for this
>>> approach is that we can't have user update their own information on
their
>>> IMAIL user info changing page.(Does IMAIL keep it in DB also or LDAP
only?)
>>>
>>> if this approach doesn't provide any benefit to me, I may
>>> stick with the old one.(single DB table)
>>>
>>> We may use 2 MS-Access DB file (2 System DSN) one for IMAIL
>>> table, another for user info.
>>>
>>> What is possible scale for using MS-Access ? .. thousands?
>>>
>>>Thanks & Regards,
>>>Nopchai
>>>
>>>
>>>
>>>
>>>
>>>______________________________________________________________________
>>>The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc.
>>>Questions, Comments or Glowing Praise...... mailto:[EMAIL PROTECTED]
>>>Searchable List Archive.... http://www.mail-archive.com/[email protected]
>>>To Manage your Subscription......... http://humankindsystems.com/lists
>>
>>
>>
>>
>>
>>______________________________________________________________________
>>The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc.
>>Questions, Comments or Glowing Praise...... mailto:[EMAIL PROTECTED]
>>Searchable List Archive.... http://www.mail-archive.com/[email protected]
>>To Manage your Subscription......... http://humankindsystems.com/lists
>>
>
>
>
>______________________________________________________________________
>The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc.
>Questions, Comments or Glowing Praise...... mailto:[EMAIL PROTECTED]
>Searchable List Archive.... http://www.mail-archive.com/[email protected]
>To Manage your Subscription......... http://humankindsystems.com/lists
>
______________________________________________________________________
The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc.
Questions, Comments or Glowing Praise...... mailto:[EMAIL PROTECTED]
Searchable List Archive.... http://www.mail-archive.com/[email protected]
To Manage your Subscription......... http://humankindsystems.com/lists
______________________________________________________________________
The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc.
Questions, Comments or Glowing Praise...... mailto:[EMAIL PROTECTED]
Searchable List Archive.... http://www.mail-archive.com/[email protected]
To Manage your Subscription......... http://humankindsystems.com/lists
