We have been watching quietly from the sidelines waiting for IMail 7 to reach reasonable stability. It seems like it's at least most of the way there, so we're preparing to upgrade.
We have just under 500 domains served from an external (Access) database. I know... Not the best choice. However, so far it's been problem free and the vast majority of these domains have only a few users so we're sticking with it for now. The problem is changing +/- 500 existing tables to add the new required fields and required defaults to existing customers. Before I try and reinvent the wheel, has anyone written an Access macro or SQL code to handle this? It looks like the simple SQL solution won't work in Access as it doesn't support the full suite of ALTER TABLE functions. Anybody got anything to assist? Anybody got the name of the person at Ipswitch that thought multiple, identically-structured tables was even remotely normalized db construction? Thanks in advance for any help you may be able to provide. --- Ed Perrine / Network Tallahassee --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.282 / Virus Database: 150 - Release Date: 9/25/2001 Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
