Hello,

At some stage in our company's history someone decided that we should add two user-defined fields containing a contact's physical address (instead of just using the address1 and address2 fields contained in Max). Reason unknown. Instead, those two fields now contain ony postal addresses.

How do I go about moving the address information now stored in the user-defined fields back into the proper fields in Max? If I was able to open the Maximizer database in something like MS Access then I guess this would be relatively simple. Is there any way of achieving this?

Much appreciated.

>If I was able to open the Maximizer database in something like MS
>Access then I guess this would be relatively simple. Is there any way
>of achieving this?

Maximizer ships with an ODBC driver that you can use. Recent versions of Maximizer have included two versions of the ODBC driver: an Indexed version for normal use and a NonIndexed version for use with Microsoft Access. Check the Maximizer Release Notes for details.

Additional notes:

- AFAIK the current (v9.x) NonIndexed versions of ODBC will work with Access_2003 but not with Access_2000. Dunno about Access_2002 or Access_2007.

- The Maximizer table structures and relationships are rather complex. There is some documentation on the table structures in the User's Guide to support custom reporting, but it is a subset of the full database documentation. The full documentation is in the Customization Suite, which can be purchased separately.

- Be aware that some tables in Maximizer ODBC are read-only. For example: the "Client" table is read-only, but the "Company", "People" and "Address" tables are not.

Thanks a lot, you've been most helpful.