[ic] How to use MSAccess with Interchange

[Chris Chaney]

It's pretty stone-aged text but It'll get people who understand
databases up and running.

You can use MS Access to Integrate with Interchange.  Must be using a
non-textfile database (eg.MySQL)

- Install an ODBC Driver...
	I use MyODBC 2.50.39 (Do A Search - note it works on XP as well)
- Set up the ODBC to connect to your server
	- Use a UserDSN
	- Enter all Information asked for
	- If you need to change this info later go to Control
Panel/Administrative Tools/ODBC Sources
- Start Access
- To Link a Database click Open, type: ODBC Databases(), Select the
ODBC(), it will import link tables.
- To Import Click import and do the same as the last (note to export you
will have to download a add-on called MyAccess, using myaccess rename
all the server databases to [name of table]2 for backup, then move your
imported tables over to the server with MyAccess (note the reason we are
doing this is that it changes data type lengths and not NULL filters but
will allow you to export without trouble meaning errors).
	(Its easier starting with a Linked database. And using MyAccess
to allow NULL for most entries - this will get rid of errors)
	- Now you can export tables from Access without using MyAccess
(I however just link my tables)
- You can set up forms to interact with the database
- The first form you should set up is your products form.  Then set up
an options form, then a inventory form.  Inventory and Options can now
be placed as subforms of the products form.  This way data will be
filtered exclusively.
- Use a test database while you set up (foundation, keep note of table
data to help you set up forms)
- This is much quicker than using the UI, and can be a nice way for
customers to set up products, manage orders

Chris Chaney